Loading...

Oracle 10g Data Guard

Course code: O1041

2 days

Learn how to use Oracle Data Guard to help protect the Oracle Database against planned and unplanned downtimes.

Course content >

Who Should Attend?

Everybody

Prerequisites

None

Course Contents

Learn how to use Oracle Data Guard to help protect the Oracle Database against planned and unplanned downtimes. The Data Guard architecture is used to create physical and logical standby databases, including Primary Database Configuration, Implementation and Monitoring.

Training Course Contents

Oracle Data Guard Introduction

  • Describe the basics of Oracle Data Guard
  • High availability usage of Data Guard architecture
  • Considerations of planned and unplanned down time
  • Physical and Logical differences

Oracle Data Guard Architecture

  • Data Guard architecture
  • Operational requirements of Data Guard
  • Advantages of multiple Standby databases

Log Transport Services

  • Service architecture
  • Capabilities of services
  • Service Interfaces
  • Describe archive log gap detection
  • Data protection modes

Oracle Data Guard Environment

  • Understanding the differences of configuration with Data Guard
  • Initialization parameters
  • Data Guard views
  • Performance configurations

Data Guard Broker

  • Management Model
  • Data Guard Broker architecture
  • Data Guard Broker components
  • Benefits of Data Guard Broker
  • Data Guard Broker configurations
  • Configuration management using DGMGRL

Data Guard SQL Architectecture

  • When to use a logical standby database
  • Create a logical standby database using Enterprise Manager

Switchover and Failover

  • Database roles
  • Switchover / Failover
  • Flashback Database after a failover

Physical Standby Database

  • Create & manage a Physical Standby database

Logical Standby database

  • Create & manage a Logical Standby database

Further Considerations

  • Back up the primary database with a physical standby database
  • Back up a logical standby database
  • Flashback Database features in a Data Guard configuration
  • Encrypt redo information
  • Cascaded redo log destinations
Contact us for more information