Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: DATA GUARD OVERVIEW

• Requirements for Maintaining a Standby Database
• Data Guard Terminology
• Levels of Protection
• Data Guard Monitor
• Physical and Logical Standby Databases
• Role Management Services
• Failover and Switchover
• Data Guard Interfaces
• Standby Database Creation
• Data Guard Installation

Session 2: DATA GUARD ARCHITECTURE

• Data Guard Configurations
• Data Guard Architecture
• Log Transport Services
• Log Apply Services
• Processes Active in Standby Configurations
• Data Guard Architecture and Initialization Processes

Session 3: CREATE A PHYSICAL STANDBY DATABASE WITH SQL COMMANDS

• Prepare the Primary Database
• Datafile and Controlfile Duplication
• Initialization Parameters for a Standby Database
• Create the Standby Instance
• Networking Issues
• Verify Primary and Standby Databases are Working
• Archive Log Loss
• Database Switchover
• Run the Data Guard Configuration
• Shut Down and Start Up the Data Guard Environment
• Monitor the Primary and Standby Databases

Session 4: REDO TRANSPORT SERVICES

• How Data Guard Sends Redo Data
• Control when Redo Data is Sent
• Handle Transmission Errors
• Manage Archive Gaps
• Levels of Protection

Session 5: REDO APPLY SERVICES

• Apply Services Configuration Options
• Terminate Redo Apply Services

Session 6: ROLE TRANSITION USING SQL COMMANDS

• Preparing the Primary Database
• Preparing the Standby Database
• Switchover
• Failover
• The Failed Primary

Session 7: CHANGE MANAGEMENT

• Adding Datafiles or Tablespaces
• Dropping Datafiles or Tablespaces
• Transportable Tablespaces
• Renaming Datafiles
• Adding or Dropping Redo Log Files
• Nologging Operations

Session 8: CREATE A STANDBY DATABASE WITH RECOVERY MANAGER

• Create a Suitable Backup with RMAN
• Standby Path and File Names
• Build the Standby Instance
• Build the Standby Database with RMAN

Session 9: CREATING A LOGICAL STANDBY USING SQL COMMANDS

• Preparing the Primary
• Convert Physical Standby to Logical Standby
• Rebuild the Password File
• Start the Standby Instance
• Verify Primary and Standby Databases are Working
• Real Time Apply
• Useful Dictionary Views
• Monitoring SQL Apply Progress

Session 10: MANAGING A LOGICAL STANDBY DATABASE

• SQL Apply Architecture
• Transaction Size Considerations
• DML and DDL Apply Considerations
• Intercept DDL Statements
• Skip DML and DDL on the Standby
• Modify a Logical Standby Database
• Materialized Views
• Table Instantiation
• Restart SQL Apply
• Customize DBA_LOGSTDBY_EVENTS

Session 11: TUNING A STANDBY DATABASE

• Overview of Tuning a Standby Database
• Tables without Primary Keys
• Statistics on the Logical Standby
• Transaction Consistency
• Adjusting the Number of Applier Processes
• Adjusting the Number of Preparer Processes
• Tuning the Memory for the LCR Cache

Session 12: BACKUP AND RECOVERY CONSIDERATIONS

• Backup and Recovery Strategy
• Backup the Primary Database with a Physical Standby Database
• Backup a Logical Standby Database
• Recovery from Loss of Datafiles
• Recovery from Loss of Control Files
• Loss of Online Redo Logs
• Flashback Database Features in a Data Guard Configuration

Session 13: DATA GUARD BROKER OVERVIEW

• Oracle Enterprise Manager
• Command Line Interface
• Data Guard Monitor
• Installing Data Guard
• Using the Data Guard Broker
• Starting up the Data Guard Broker

Session 14: BUILD A CONFIGURATION USING THE BROKER

• Preparation
• Configuring the Primary System
• Configuring the Standby System
• Enable and Disable the Configuration

Session 15: MANAGE A CONFIGURATION USING THE BROKER

• Database Properties
• Set the Configuration Protection Mode
• Configure Fast Start Failover
• Execute a Switchover
• Execute a Failover
• Alter the state of a Database
• Monitor the Configuration

Session 16: DATA GUARD AND ORACLE ENTERPRISE MANAGER

• Access the Data Guard User Interface
• Configure fast Start Failover
• Execute a Switchover
• Execute a Failover
• Alter the state of a Database
• Monitor the Configuration