Oracle Data Guard - ORA600
This course steps you through creating and managing Data Guard, both physical and logical standby databases.
Course ID: ORA600
Duration: 3 days
Audience: Oracle database administrators
Prerequisites: Basic DBA knowledge
Topics:
Introduction to Data Guard
- Failover options
- Basic Standby concepts
- Physical vs. Logical standby
- Archive log repository
- Standby database lifecycle
DataGuard architecture
- Apply modes
- Archive gap sequence
- Data Guard Broker architecture
Implementing a standby database
- Creating physical standby
- Creating logical standby
- Configuration options
Standby administration
- General administration tasks
- Monitoring
- Managing schema objects
- Managing standby with time lag
- Resolving archive gap sequences
- Cascading standby databases
Log management
- Log transport services
- Log apply services
- Log management policies
- Standby redo logs
- Standby protection modes
Switchover and failover
- Role transitions
- Implementing switchover (physical and logical)
- Verifying switchover
- Implementing failover (physical and logical)
Performance
- Monitoring performance
- Tuning performance
- Gathering statistics
- Configuring for better performance
Data Guard Broker
- Broker concepts
- Preparing to use DG Broker
- Managing DGMGRL
Recovery Manager and Data Guard
- RMAN review
- Creating physical standby with RMAN
- Creating backup sets
- Backing up standby
Troubleshooting Data Guard
Data Guard reference