Oracle Database 11g Release 2 Data Guard

Course Introduction

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

Session 1: DATA GUARD OVERVIEW

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

Session 2: DATA GUARD ARCHITECTURE

• Data Guard Architecture
• Processes Active on the Primary Database
• Processes Active on the Standby Database
• Data Guard Architecture and Initialization Parameters
• Data Guard usage with a Multitenant Database
• PDB Creation and Cloning in a Multitenant Architecture Environment

Session 3: CREATE A PHYSICAL STANDBY DATABASE WITH SQL COMMANDS

• Prepare the Primary Database for Data Guard
• Initialization Parameters for the 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
• Far Sync Instance
• Monitor the Primary and Standby Databases

Session 4: 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
• Fast-Sync Mode

Session 5: REDO APPLY SERVICES

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

Session 6: 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
• Overview of Application Continuity in a Data Guard Environment

Session 7: 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

Session 8: 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

Session 9: 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

Session 10: 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

Session 11: TUNING A STANDBY DATABASE

• Overview of Tuning a Physical Standby Database
• Temporary Undo, Global and Session Variables
• 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 Transmission
• Optimize SQL Apply
• Optimize Redo Apply

Session 12: BACKUP AND RECOVERY CONSIDERATIONS IN AN ORACLE DATA GUARD CONFIGURATION

• Implement a Backup and Recovery Strategy
• The Usage of RMAN in a Data Guard Configuration
• 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
• Restore and Recover Datafiles across the Network
• Enable Block Change Tracking for a Physical Standby Database

Session 13: USE FLASHBACK 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

Session 14: DATA GUARD BROKER OVERVIEW

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

Session 15: BUILD A CONFIGURATION USING THE BROKER

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

Session 16: 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