facebook twitter googleplus linkedin blogger

Oracle Database 10g/11g:Data Guard

Administration Course (15 Hours)

1. Oracle Data Guard Overview

  • What Is Oracle Data Guard?
  • Types of Standby Databases
  • Data Guard Broker Framework
  • Types of Services
  • Benefits of Implementing Oracle Data Guard
  • 2. 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
  • 3. Using Oracle Data Guard Broker

  • Oracle Data Guard Broker Features
  • Data Guard Broker Configurations
  • Benefits of Using the Data Guard Broker
  • Data Guard Broker Interfaces
  • 4. 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
  • 5. Configuring Data Protection Modes and Log Transport Services

  • Setting the Log Transport Mode
  • Setting the Data Protection Mode
  • Delaying the Application of Redo
  • Using Flashback Database as an Alternative to Apply Delay
  • Additional Attributes that Affect Log Transport Services
  • 6. 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
  • 7. Performing Switchover and Failover

  • Choosing the Best Role Transition Operation
  • Performing a Switchover by Using SQL
  • Performing a Failover by Using SQL
  • Restoring Databases After a Role Transition
  • Flashback Through Standby Database Role Transitions
  • 8. Enabling Fast-Start Failover

  • When Will Fast-Start Failover Occur?
  • Configuring Fast-Start Failover
  • Prohibited Operations After Enabling Fast-Start Failover
  • Managing the Observer
  • Performing Role Changes
  • 9. Using Data Guard in 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
  • Apply Instance Failover
  • Role Transitions with RAC
  • 10. Other Considerations for Oracle Data Guard

  • Using a Physical Standby Database for Read/Write Testing and Reporting
  • Offloading Backups to a Physical Standby Database
  • Using Flashback Database and Real-time Apply
  • Using Flashback Database After RESETLOGS
  • Enabling Redo Encryption
  • Configuring Cascaded Redo Log Destinations
  • Contact

    Phone no. - 00-971564914177


    OraSols - The Complete Oracle Solutions in one place.

    All training sessions if online will be recorded and training Video is shared at the end of session. Class Room Training for a batch of 4 and above will be provided. Individual online training by special focusing on Real time examples and Interviews and job related queries will be covered in details to meet the IT best practices.  Click to read more....