Course Contents
In this course, delegates learn how to use Oracle Data Guard to help protect their Oracle database against planned and unplanned downtimes. They also learn how Data Guard standby databases can be used to support production functions such as reporting, querying, and testing, while in a standby role. The course includes Data Guard architecture, the configuration of a physical standby database, and role transitions.
Training Course Contents
Oracle Data Guard Introduction
- Requirements for Maintaining a
- Standby Database
- Describe the basics of
- Data Guard
- Role Management Services
- High availability usage of Data Guard architecture
- Considerations of planned and unplanned down time
- Types of Standby Databases
- Data Guard Installation
- Standby Database Creation
Oracle Data Guard Architecture
- Data Guard Configuration
- Architectural Components
- Operational requirements of Data Guard
- Data Guard Apply Modes
- Archive Gap Sequence
Log Management Services
- How Redo data is sent
- Control Redo Data
- Handle Transmission Errors
- Manage Archive Gap
- Data protection modes
- Service Configuration Options
Oracle Data Guard Environment
- Understanding the differences of configuration with Data Guard
- Initialization parameters
- Data Guard views
- Performance configurations
Implementing Standby Databases
- Prepare the Primary Database
- Datafile & Controlfile Duplication
- Create Standby Instance
- Archive Log Loss
- Database Switchover
- Monitoring the Primary & Standby Databases
Role Transition Commands
- Preparing the Primary
- Preparing the Standby
- Switchover
- Failover
- The Failed Primary
Oracle Data Guard 11g New Feat
- Support for the Oracle Active Data Guard Option
- Failover enhancements
- Enhanced data protection
- Redo Transport enhancements
- Apply performance enhancements
- Transient Logical Standby
- RMAN enhancements for Data Guard
- Enhanced security
- Enhanced SQL Apply support
- SQL Apply Manageability