Oracle Dataguard 11g Training

  1. Home
  2. Oracle Dataguard 11g Training

Oracle Data Guard Training - Online Data Guard Training 11g 

Reviewing tools and Support Sites

  • Introduction to Commonly used Tools : Putty, VNC, Winscp, VPN , telnet . ssh
  • Introduction to Online DBA Support Sites : DBALounge Forum , Oracle Support Sites

Understanding the Oracle Data Guard Architecture

  • Oracle Data Guard Architecture
  • Data Guard Redo Apply Architecture
  • Data Guard SQL Apply Architecture
  • Specifying Role-based Destinations
  • Configuring Standby Redo Logs
  • Standby Database Modes

Using Oracle Data Guard Broker

  • Oracle Data Guard Broker Features
  • Benefits of Using the Data Guard Broker
  • Data Guard Broker Interfaces

Creating a Physical Standby Database by Using SQL

  • Preparing the Primary Database
  • Setting Initialization Parameters on the Primary Database
  • Backing Up the Primary Database Using RMAN
  • Creating a Control File for the Standby Database
  • Setting Initialization Parameters on the Standby Database
  • Setting Up the Environment to Support the Standby Database
  • Starting the Physical Standby Database
  • Performing Additional Configuration Tasks

Configuring Data Protection Modes and Log Transport Services

  • Setting the Log Transport Mode
  • Setting the Data Protection Mode
  • Delaying the Application of Redo
  • Additional Attributes that Affect Log Transport Services

Creating a Logical Standby Database by Using SQL

  • Preparing to Create a Logical Standby Database
  • Creating a Physical Standby Database
  • Preparing the Primary Database
  • Transitioning to a Logical Standby Database
  • Opening the Logical Standby Database
  • Verifying the Logical Standby Database
  • Performing Additional Configuration Tasks

Performing Switchover and Failover

  • Choosing the Best Role Transition Operation
  • Performing a Switchover by Using Enterprise Manager
  • Performing a Switchover by Using SQL
  • Performing a Failover by Using SQL
  • Restoring Databases After a Role Transition

Enabling Fast-Start Failover

  • When Will Fast-Start Failover Occur?
  • Configuring Fast-Start Failover
  • Managing the Observer
  • Performing Role Changes

Using Data Guard in a Real Application Clusters Configuration

  • Real Application Clusters and Data Guard
  • Configuration Considerations with RAC
  • Configuring a Primary Database with RAC
  • Configuring a Standby Database with RAC