Session 1: 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
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 Processes
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
- 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
Session 5: 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
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
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
- 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
Session 12: BACKUP AND RECOVERY CONSIDERATIONS IN AN ORACLE DATA GUARD CONFIGURATION
- 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
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 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
Session 15: BUILD A CONFIGURATION USING THE BROKER
- Prepare for a Configuration Build
- Configure the Primary Database
- Configure the Standby Database
- 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
Session 17: OVERVIEW OF 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