Course Duration in Hours
60
60
Introduction to Oracle Data Guard
1.1 Data Guard Configurations
1.2 Data Guard Services
1.3 Data Guard Broker
1.4 Data Guard Protection Modes
1.5 Client Failover
2 Getting Started with Data Guard
2.1 Standby Database Types
2.2 User Interfaces for Administering Data Guard Configurations
2.3 Data Guard Operational Prerequisites
2.4 Standby Database Directory Structure Considerations
3 Creating a Physical Standby Database
3.1 Preparing the Primary Database for Standby Database Creation
3.2 Step-by-Step Instructions for Creating a Physical Standby Database
3.3 Post-Creation Steps
4 Creating a Logical Standby Database
4.1 Prerequisite Conditions for Creating a Logical Standby Database
4.2 Step-by-Step Instructions for Creating a Logical Standby Database
4.3 Post-Creation Steps
5 Data Guard Protection Modes
5.1 Data Guard Protection Modes
5.2 Setting the Data Protection Mode of a Primary Database
6 Redo Transport Services
6.1 Introduction to Redo Transport Services
6.2 Configuring Redo Transport Services
6.3 Cascaded Redo Transport Destinations
6.4 Monitoring Redo Transport Services
6.5 Tuning Redo Transport
7 Apply Services
7.1 Introduction to Apply Services
7.2 Apply Services Configuration Options
7.3 Applying Redo Data to Physical Standby Databases
7.4 Applying Redo Data to Logical Standby Databases
8 Role Transitions
8.1 Introduction to Role Transitions
8.2 Role Transitions Involving Physical Standby Databases
8.3 Role Transitions Involving Logical Standby Databases
8.4 Using Flashback Database After a Role Transition
9 Managing Physical and Snapshot Standby Databases
9.1 Starting Up and Shutting Down a Physical Standby Database
9.2 Opening a Physical Standby Database
9.3 Primary Database Changes That Require Manual Intervention at a Physical Standby
9.4 Recovering Through the OPEN RESETLOGS Statement
9.5 Monitoring Primary, Physical Standby, and Snapshot Standby Databases
9.6 Tuning Redo Apply
9.7 Managing a Snapshot Standby Database
10 Using RMAN to Back Up and Restore Files
10.1 About RMAN File Management in a Data Guard Configuration
10.2 About RMAN Configuration in a Data Guard Environment
10.3 Recommended RMAN and Oracle Database Configurations
10.4 Backup Procedures
10.5 Registering and Unregistering Databases in a Data Guard Environment
10.6 Reporting in a Data Guard Environment
10.7 Performing Backup Maintenance in a Data Guard Environment
10.8 Recovery Scenarios in a Data Guard Environment
10.9 Additional Backup Situations
10.10 Using RMAN Incremental Backups to Roll Forward a Physical Standby Database
11 Data Guard Scenarios
11.1 Converting a Failed Primary Into a Standby Database Using Flashback Database
11.2 Using Flashback Database After Issuing an Open Resetlogs Statement
11.3 Recovering After the NOLOGGING Clause Is Specified
11.4 Creating a Standby Database That Uses OMF or Oracle ASM
11.5 Recovering From Lost-Write Errors on a Primary Database
11.6 Converting a Failed Primary into a Standby Database Using RMAN Backups
11.7 Changing the Character Set of a Primary Without Re-Creating Physical Standbys
A Troubleshooting Data Guard
A.1 Common Problems
A.2 Log File Destination Failures
A.3 Problems Switching Over to a Physical Standby Database
A.4 What to Do If SQL Apply Stops
A.5 Network Tuning for Redo Data Transmission
A.6 Slow Disk Performance on Standby Databases
A.7 Log Files Must Match to Avoid Primary Database Shutdown
B Data Guard and Oracle Real Application Clusters
1 Configuring Standby Databases in an Oracle RAC Environment
2 Configuration Considerations in an Oracle RAC Environment
3 Troubleshooting
C Creating a Standby Database with Recovery Manager
1 Prerequisites
2 Overview of Standby Database Creation with RMAN
3 Using the DUPLICATE Command to Create a Standby Database
Oracle DBA
AMK Technologies, BTM Ist Stage (Bangalore),Bangalore,IN