Oracle Database 12c Data Guard Administration Training & Placements in Chennai "ISQL Global"

Oracle Database 12c: Data Guard Administration
(Course Materials and Course Completion Certificates are directly delivered from Oracle University to those required for Foreign Opportunity)

(Government of India Approved Education Center)

This Oracle Database 12c: Data Guard Administration Ed 1 training teaches you how to use Oracle Data Guard. Learn how it protects your Oracle database against planned and unplanned downtimes. In this course, you will be introduced to Oracle Database Exadata Cloud Service.
This Oracle Database 12c: Data Guard Administration Ed 1 training teaches you how to use Oracle Data Guard. Expert Oracle University instructors will demonstrate how this solution protects your Oracle database against planned and unplanned downtimes. In this course, you will be introduced to Oracle Database Exadata Cloud Service.
Learn To:

• Buildhighly available systems.
• Offloadbusiness processing needs to another system.
• Offloadbackup needs to another system.
• Gain an understanding of Oracle Database Exadata Cloud Service.

Benefits to You You'll walk away from this course with an understanding of how Data Guard standby databases can be used to support various production functions. These functions include reporting, querying and testing, while in a standby role. Oracle Data Guard 12c This course will also teach you about the new Oracle Data Guard 12c features and architecture. You'll get a chance to explore topics like Oracle Active Data Guard, Far Sync, rolling upgrades and snapshot standby databases. Furthermore, enrolling in this course will help you learn how to manage and troubleshoot a Data Guard configuration. Prerequisites Suggested Prerequisite

• Linux operating system fundamentals
• Database Administration
• Basicunderstanding of PL/SQL and Triggers

Required Prerequisite

• Oracle Database 11g: Administration Workshop I Release 2
• Oracle Database 11g: Administration Workshop II Release 2

Audience

• Database Administrators
• Support Engineer
• Technical Consultant

Course Objectives

• UseData Guard standby databases to support production functions suchas reporting, querying, testing, and performing backups
• Create and manage physical and logical standby databases
• UseEnterprise Manager Cloud Control and the Data Guard command-lineinterface (DGMGRL) to maintain a Data Guard configuration
• UseData Guard to achieve a highly available Oracle database
• Gain an understanding of Oracle Database Exadata Cloud Service

Course Topics
Introduction to Oracle Data Guard

• Oracle Data Guard: Architecture(Overview)
• Types of Data Guard Services
• RoleTransitions: Switchover and Failover
• WhatIs Oracle Data Guard?
• Choosing an Interface for Administering a Data Guard Configuration
• Types of Standby Databases
• PrimaryDatabase Processes
• Oracle Data Guard Broker Framework

Networking for Oracle Data Guard

• Listener.oraConfiguration
• Staticsvs. Dynamic Registration
• StaticEntries for Broker Operations
• Tnsnames.oraConfiguration
• StaticEntries for Database Duplication and SQL Maintenence
• Oracle Network Configuration Tuning
• Networking Overview

Creating a Physical Standby Database by Using SQL and RMAN Commands

• Stepsto Create a Physical Standby Database
• Configuring Standby Redo Logs
• Viewing Standby Redo Log Information
• Creating Standby Redo Logs
• FORCELOGGING Mode
• Using SQL to Create Standby Redo Logs
• Setting Initialization Parameters on the Primary Database to Control RedoTransport
• Preparing the Primary Database

Oracle Data Guard Broker: Overview

• DataGuard Broker: Components
• DataGuard Broker: Configurations
• DataGuard Monitor: DMON Process
• Benefitsof Using the Data Guard Broker
• Oracle Data Guard Broker: Features
• Comparing Configuration Management With and Without the Data Guard Broker
• DataGuard Broker: Management Model
• DataGuard Broker: Architecture

Creating a Data Guard Broker Configuration

• DataGuard Broker: Log Files
• Creating a Broker Configuration
• DataGuard Monitor: Configuration File
• DataGuard Broker and the SPFILE
• Adding a Standby Database to the Configuration
• DataGuard Broker: Requirements
• Defining the Broker Configuration and the Primary Database Profile
• Enabling the Configuration

Creating a Physical Standby Database by Using Enterprise Manager Cloud Control

• Standby Database Creation: Progress
• Creating a Configuration
• Adding a Standby Database to an Existing Configuration
• StandbyDatabase Creation: Processing
• Using the Add Standby Database Wizard
• Using Oracle Enterprise Manager to Create a Broker Configuration
• Creating a New Configuration
• Verifying a Data Guard Configuration

Creating a Logical Standby Database

• Benefitsof Implementing a Logical Standby Database
• Checking for Tables with Unsupported Data Types
• UnsupportedObjects
• Preparing to Create a Logical Standby Database
• UnsupportedData Types
• LogicalStandby Database: SQL Apply Architecture
• SQLApply Process: Architecture
• Checking for Unsupported Tables

Creating and Managing a Snapshot Standby Database

• SnapshotStandby Database: Architecture
• Converting a Physical Standby Database to a Snapshot Standby Database
• Activating a Snapshot Standby Database: Issues and Cautions
• Converting a Snapshot Standby Database to a Physical Standby Database
• Viewing Snapshot Standby Database Information
• SnapshotStandby Database: Target Restrictions
• Using DGMGRL to View Snapshot Standby Database Information
• SnapshotStandby Databases: Overview

Using Oracle Active Data Guard

• Monitoring Apply Lag: V$DATAGUARD_STATS
• Configuring Zero Lag Between the Primary and Standby Databases
• Using Real-Time Query
• OracleActive Data Guard
• Setting a Predetermined Service Level for Currency of Standby Queries
• Checking the Standby’s Open Mode
• Understanding Lag in an Active Data Guard Configuration
• Monitoring Apply Lag: V$STANDBY_EVENT_HISTOGRAM

Configuring Data Protection Modes

• MaximumAvailability Mode
• Maximum Performance Mode
• Maximum Protection Mode
• Setting the Data Protection Mode
• DataProtection Modes and Redo Transport Modes
• Comparing Data Protection Modes
• Setting the Data Protection Mode by Using DGMGRL

Performing Role Transitions

• Switch over
• Considerations When Performing a Switch over to a Logical Standby Database
• SituationsThat Prevent a Switchover
• Performing a Switchover by Using Enterprise Manager
• Preparing for a Switchover
• RoleTransitions: Switchover and Failover
• Performing a Switchover by Using DGMGRL
• RoleManagement Services

Using Flashback Database in a Data Guard Configuration

• Configuring Flash back Database by Using Enterprise Manager
• Overview of Flashback Database
• Using Flashback Database in a Data Guard Configuration
• FlashbackThrough Standby Database Role Transitions
• Using Flashback Database After RESETLOGS
• Configuring Flashback Database
• Using Flashback Database and Real-Time Apply
• Using Flashback Database Instead of Apply Delay

Enabling Fast-Start Failover

• Configuring Fast-Start Failover
• Fast-Start Failover: Overview
• Fast-StartFailover Prerequisites
• Installing the Observer Software
• Configuring the Primary Database to Shut Down Automatically
• WhenDoes Fast-Start Failover Occur?
• Setting the Lag-Time Limit
• AutomaticReinstatement After Fast-Start Failover

Managing Client Connectivity

• Creating Services for the Data Guard Configuration Databases
• Understanding Client Connectivity: Using a Database Service
• Adding Standby Databases to Oracle Restart Configuration
• Managing Services
• Understanding Client Connectivity: Using Local Naming
• Preventing Clients from Connecting to the Wrong Database
• Understanding Client Connectivity in a Data Guard Configuration
• Configuring Role-Based Services

Backup and Recovery Considerations in an Oracle Data Guard Configuration

• Setting Persistent Configuration Settings
• Creating the Recovery Catalog
• Offloading Backups to a Physical Standby
• Registering a Database in the Recovery Catalog
• Using RMAN to Back Up and Restore Files in a Data Guard Configuration
• Restrictionsand Usage Notes
• Using the RMAN Recovery Catalog in a Data Guard Configuration
• Backup and Recovery of a Logical Standby Database

Patching and Upgrading Databases in a Data Guard Configuration

• Upgrading Oracle Database in a Data Guard Configuration with a PhysicalStandby Database
• Upgrading Oracle Database in a Data Guard Configuration with a LogicalStandby Database
• Upgrading an Oracle Data Guard Broker Configuration
• Performing a Rolling Upgrade by Using DBMS_ROLLING
• Trailing Group Databases and Trailing Group Master
• Leading Group Databases and Leading Group Master
• Requirements for Using DBMS_ROLLING to Perform a Rolling Upgrade
• Using DBMS_ROLLING to Upgrade the Oracle Database

Monitoring a Data Guard Broker Configuration

• Monitoring the Data Guard Configuration by Using Enterprise Manager CloudControl
• DataGuard Metrics
• Managing Data Guard Metrics
• Viewing Metric Value History
• Viewing the Data Guard Configuration Status
• Monitoring Data Guard Performance
• Viewing Log File Details
• Enterprise Manager Metrics and Alerts

Optimizing a Data Guard Configuration

• Optimizing Redo Transmission by Setting Max Connections
• Setting the MaxConnections Database Property
• Setting the ReopenSecs Database Property
• Compressing Redo Data by Setting the RedoCompression Property
• Delaying the Application of Redo
• Setting the NetTimeout Database Property
• Monitoring Configuration Performance by Using Enterprise Manager CloudControl
• Optimizing Redo Transport Services

Oracle Database Exadata Cloud Service Overview

• Migrating to Exadata Cloud Service
• Data Security & Management Responsibilities
• SimpleWeb-Based Provisioning & Management
• Introducing Exadata Cloud Service
• ServiceConfiguration, Connection, Architecture & Availability
• Backup and Recovery
• RESTAPIs
• StorageConfiguration & Management Details