Oracle Database 11g Data Guard

Course Introduction

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

Data Guard Overview

• Overview of Data Guard
• Requirements for Maintaining a Standby Database
• Data Guard Terminology
• Levels of Protection
• Physical, Logical and Snapshot Standby Databases
• Role Transition Management Services
• Data Guard Interfaces
• Standby Database Creation
• Data Guard Installation

Data Guard Architecture

• Data Guard Architecture
• Processes Active on the Primary Database
• Processes Active on the Standby Database
• Data Guard Architecture and Initialization Processes

Create a Physical Standby Database with SQL Commands

• Prepare the Primary Database for Data Guard
• Initialization Parameters for a Standby Database
• Datafile and Controlfile Duplication
• Create the Standby Instance
• Network Files Configuration
• Activate the Standby Database
• Verify Primary and Standby Databases are Working
• Archive Log Loss
• Open the Standby Database
• Shut Down and Start Up the Data Guard Environment
• Active Data Guard
• Monitor the Primary and Standby Databases

Redo Transport Services

• Overview of Redo Transport Services
• How Data Guard Sends Redo Data
• Control when Redo Data is Sent with the VALID_FOR Option
• Handle Transmission Errors
• Manage Archive Gaps
• Levels of Protection

Redo Apply Services

• Overview of Log Apply Services
• Apply Redo Data Immediately
• Delay Redo Data Application
• Terminate Redo Apply Services
• Create a Snapshot Standby Database

Role Transition Using SQL Commands

• Role Transition Overview
• Prepare the Primary Database
• Prepare the Standby Database
• Perform a Switchover
• Perform a Failover
• Reinstate the Failed Primary

Change Management

• Change Management Overview
• Add Datafiles or Tablespaces
• Drop Tablespaces and Delete Datafiles
• Transportable Tablespaces
• Rename Datafiles
• Add or Drop Redo Log Files
• Nologging Operations
• Lost Write Detection

Create a Standby Database with Recovery Manager

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

Creating a Logical Standby using SQL Commands

• Overview of Creating a Logical Standby Database using SQL Commands
• Prepare the Primary Database
• Prepare the Standby Database
• Transition a Physical Standby to a Logical Standby
• Start the Standby Instance
• Real Time Apply
• Delete Archives
• Dictionary Views Containing useful Standby Information
• Monitor the SQL Apply Progress

Managing a Logical Standby Database

• Overview of SQL Apply Architecture
• Transaction Size Considerations
• DML and DDL Apply Considerations
• Intercept DDL Statements
• Skip DML and DDL on the Standby Database
• Modify a Logical Standby Database
• Materialized Views on the Primary Database
• Table Instantiation
• Restart SQL Apply
• Customize DBA_LOGSTDBY_EVENTS
• Rolling Upgrades using Logical Standby
• Rolling Upgrades on a Physical Standby
• Job Scheduling on a Logical Standby

Tuning a Standby Database

• Overview of Tuning a Standby Database
• The Significance of Tables without Primary Keys
• Statistics on the Logical Standby
• Transaction Consistency
• Adjusting the Number of Applier Processes
• Adjusting the Number of Preparer Processes
• Tune the Memory for the LCR Cache
• Set the ReopenSecs and NetTimeout Database Properties
• Compress Redo Data
• Optimize SQL Apply

Backup and Recovery Considerations

• Implement a Backup and Recovery Strategy
• Backup and Recovery of a Primary Database with a Physical Standby Database
• Backup and Recovery of a Logical Standby Database
• Use a RMAN Recovery Catalog in a Data Guard Configuration
• Create the Recovery Catalog
• Register a Database in the Catalog
• Configure Daily Incremental Backups
• Recover a Datafile on the Primary Database
• Recover a Datafile on the Standby Database

Use Flaschback Database in a Data Guard Configuration

• Overview of Flashback Database Usage in a Data Guard Configuration
• Configure Flashback Database
• Use Flashback Database Instead of Apply Data
• Use Flashback Database and Real Time Apply
• Flashback through Standby Database Role Transitions
• Use Flashback Database after Failover

Data Guard Broker Overview

• Overview of Oracle Data Guard Broker
• Oracle Enterprise Manager Grid Control
• The DGMGRL Command Line Interface
• Data Guard Monitor
• Install Oracle Data Guard
• Use the Data Guard Broker
• Start up the Data Guard Broker

Build a Configuration Using the Broker

• Prepare for a Configuration Build
• Configure the Primary Database
• Configure the Standby Database
• Enable and Disable the Configuration

Manage a Configuration using The Broker

• Display and Edit 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

Data Guard and Oracle Enterprise Manager

• Access the Data Guard User Interface
• Execute a Switchover
• Execute a Manual Failover
• Alter the state of a Database
• Configure Fast Start Failover
• Enable and Disable Fast Start Failover
• Monitor the Data Guard Configuration
• Create a Physical Standby Database Using EM Grid Control