Oracle Database 11g: Data Guard Administration (Self-Study Course)

 

Who should attend

  • Technical consultants
  • Database administrators

Prerequisites

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

Course Objectives

  • Use Enterprise Manager Grid Control and the Data Guard command-line interface (DGMGRL) to maintain a Data Guard configuration
  • Use Data Guard to achieve a highly available Oracle database
  • Use Data Guard standby databases to support production functions such as reporting, querying, testing, and performing backups
  • Create and manage physical and logical standby databases

Product Description

  • Introduction to Oracle Data Guard
    • Causes of Data Loss
    • Oracle Data Guard Architecture
    • Types of Standby Databases (benefits of each type)
    • Using the Data Guard Broker
    • Differentiating Between Standby Databases and Data Guard Broker Configuration
    • Data Protection Modes
    • Performing Role Transitions
  • Creating a Physical Standby Database by Using SQL and RMAN Commands
    • Preparing the Primary Database
    • Creating the Physical Standby Database
  • Oracle Data Guard Broker: Overview
    • Oracle Data Guard Broker Features
    • Oracle Data Guard Broker Configurations
    • Data Guard Monitor Process
    • Data Guard Monitor Configuration Files
    • Benefits of Using the Data Guard Broker
    • Comparing Configuration Management With and Without the Broker
    • Using DGMGRL
  • Creating a Data Guard Broker Configuration
    • Defining a Data Guard Configuration (overview)
    • Setting up the Broker Configuration Files
    • Setting the DG_BROKER_START Initialization Parameter to TRUE to start the Data Guard Broker
    • Creating the Broker Configuration
    • Adding the Standby Database to the Configuration
  • Creating a Physical Standby Database by Using Enterprise Manager Grid Control
    • Using Enterprise Manager Grid Control to Create a Physical Standby Database
    • Using the Add Standby Database Wizard
    • Verifying a Configuration
    • Editing Standby database properties
    • Viewing the Data Guard Configuration Status
  • Creating a Logical Standby Database
    • Monitoring the Data Guard Configuration by Using Enterprise Manager Grid ControlVerifying the ConfigurationViewing Log File Details
    • Using Enterprise Manager Data Guard Metrics
    • Using the DGMGRL SHOW CONFIGURATION Command to Monitor the Configuration
    • Viewing Standby Redo Log Information
    • Monitoring Redo Apply
  • Creating and Managing a Snapshot Standby Database
    • Snapshot Standby Database: Architecture
    • Converting a Physical Standby Database to a Snapshot Standby Database
    • Activating a Snapshot Standby Database: Issues and Cautions
    • Viewing Snapshot Standby Database Information
    • Converting a Snapshot Standby Database to a Physical Standby Database
  • Using Oracle Active Data Guard
    • Using Real-Time Query
    • Enabling and Disabling Real-Time Query
    • Enabling Block Change Tracking on a Physical Standby Database
    • Creating Fast Incremental Backups
    • Monitoring Block Change Tracking
  • Configuring Data Protection Modes
    • Preparing to Create a Logical Standby Database
    • Checking for Unsupported Objects , Data Types, and Tables
    • Ensuring Unique Row Identifiers
    • Creating the Logical Standby Using SQL Commands and Grid Control
    • Securing your Logical Standby Database
  • Performing Role Transitions
    • Contrast switchover vs. failover
    • Preparing for a Switchover
    • Performing a Switchover using DGMGRL and Enterprise Manager
    • Types of Failovers
    • Re-enabling Disabled Databases
  • Using Flashback Database in a Data Guard Configuration
    • Overview of Flashback Database
    • Configuring Flashback Database
    • Using Flashback Database Instead of Apply Delay
    • Using Flashback Database and Real Time Apply
    • Flashback Through Standby Database Role Transitions
    • Using Flashback Database After Failover
  • Enabling Fast-Start Failover
    • Installing the Observer Software
    • Configuring Fast-Start Failover
    • Configuring Automatic Reinstatement of the Primary Database
    • Initiating Fast-Start Failover from an Application
    • Disabling Fast-Start Failover
    • Starting and Stopping the Observer
    • Moving the Observer to a new Host
  • Managing Client Connectivity
    • Understanding Client Connectivity in a Data Guard Configuration
    • Preventing Clients from Connecting to the Wrong Database
    • Creating Services for the Data Guard Configuration Databases
    • Automating Client Failover in a Data Guard Configuration
    • Automating Failover for OCI Clients
    • Automating Failover for OLE DB Clients
    • Configuring JDBC Clients for Failover
  • Performing Backup and Recovery Considerations in an Oracle Data Guard Configuration
    • Backup and Recovery of a Logical Standby Database
    • Using the RMAN Recovery Catalog in a Data Guard Configuration
    • Creating the Recovery Catalog
    • Registering a Database in the Recovery Catalog
    • Configuring Daily Incremental Backups
    • Using a Backup to Recover a Data File on the Primary Database
    • Recovering a Data File on the Standby Database
  • Patching and Upgrading Databases in a Data Guard Configuration
    • Upgrading an Oracle Data Guard Broker Configuration
    • Using SQL Apply to Upgrade the Oracle Database
    • Performing a Rolling Upgrade by Using SQL Apply
    • Performing a Rolling Upgrade by Using an Existing Logical Standby Database
    • Performing a Rolling Upgrade by Creating a New Logical Standby Database
    • Performing a Rolling Upgrade by Using a Physical Standby Database
  • Monitoring a Data Guard Configuration
    • Monitoring the Data Guard Configuration by Using Enterprise Manager Grid ControlVerifying the ConfigurationViewing Log File Details
    • Using Enterprise Manager Data Guard Metrics
    • Using the DGMGRL SHOW CONFIGURATION Command to Monitor the Configuration
    • Viewing Standby Redo Log Information
    • Monitoring Redo Apply
  • Optimizing a Data Guard Configuration
    • Using Enterprise Manager Grid Control to monitor configuration performance
    • Setting the ReopenSecs and NetTimeout database properties
    • Compressing Redo Data
    • Delaying the Application of Redo Data
    • Optimizing SQL Apply
    • Adjusting the Number of APPLIER and PREPARER processes

Price on request

BUY NOW