Corporate Oracle Data Guard Administration Training Course

1. Data Guard architecture

1. Primary database components
2. Standby database components
3. Redo transport services
4. Log apply services
5. Data Guard broker components

1. Redo transport modes

1. LGWR sync mode
2. LGWR async mode
3. ARCH sync mode
4. ARCH async mode

2. Real-Time Apply

1. Failover process

2. Automatic failover

1. Configuration requirements
2. Role transition steps
3. Switchover validation

 3. Manual failover

1. Manual role transition steps
2. Switchover validation

 4. Switchover process

1. Preparing for switchover
2. Executing switchover commands
3. Post-switchover tasks
4. Switchover validation

1. Data Guard protection modes

2. Maximum availability mode

1. Configuration requirements
2. Redo transport considerations
3. Log apply considerations

3. Maximum performance mode

1. Configuration requirements
2. Redo transport considerations
3. Log apply considerations

4. Maximum protection mode

1. Configuration requirements
2. Redo transport considerations
3. Log apply considerations

1. Overview of Data Guard broker

1. Role and benefits of Data Guard broker
2. Architecture and components

2. Configuration files

1. Initialization files
2. Parameter files
3. Configuration file locations

 3. Command-line interface (DGMGRL)

1. Accessing DGMGRL
2. Basic commands and syntax
3. Managing broker configurations

 4. Broker configuration and management

1. Creating and managing broker configurations
2. Modifying configuration properties
3. Monitoring and managing Data Guard using a broker

1. Understanding data gaps

1. Causes of data gaps
2. Impact of data gaps

2. Gap detection and resolution

1. Monitoring for data gaps
2. Determining the cause of gaps
3. Resolving data gaps

3. Log apply services and gap resolution

1. Configuring log apply services
2. Gap resolution techniques
3. Monitoring and managing log apply services

1. Configuring protection modes

1. Configuring protection mode at the database level
2. Configuring protection mode at the configuration level

2. Redo transport configuration

1. Redo transport mode selection
2. Configuring network settings
3. Monitoring and managing redo transport

3. Role transitions and protection modes

1. Protection mode considerations during role transitions
2. Managing protection mode changes

1. Supported operating systems

1. Windows
2. Linux
3. UNIX

2. Hardware requirements

1. CPU
2. Memory
3. Disk storage

3. Software prerequisites

1. Oracle Database software version compatibility
2. Additional software requirements

1. Steps for creating a physical standby database manually

1. Preparing the primary database
2. Preparing the standby database host
3. Configuring initialization parameters
4. Setting up redo transport services
5. Synchronizing data files and standby control file

1. Configuring Data Guard using Oracle Enterprise Manager Cloud Control

1. Configuring Cloud Control for Data Guard Management
2. Registering primary and standby databases
3. Monitoring and managing physical standby databases

2. Switchover and failover operations using Cloud Control

1. Performing switchover using Cloud Control
2. Performing failover using Cloud Control
3. Monitoring and managing switchover/failover operations

1. Introduction to logical standby databases

1. Purpose and benefits of logical standby databases
2. Architecture and components

2. Data Guard configuration for logical standby

1. Database and network configuration requirements
2. Log apply, and SQL apply considerations
3. Role transitions and logical standby databases

3. SQL Apply and DDL replication

1. Configuring SQL apply
2. Managing DDL replication
3. Monitoring and managing logical standby databases

1. Creating a logical standby database using Oracle Enterprise Manager Cloud Control

1. Configuring Cloud Control for logical standby creation
2. Step-by-step setup process
3. Validation and verification

2. Monitoring and managing logical standby databases

1. Performance monitoring and tuning
2. Log apply, and SQL apply to monitor
3. Alert notifications and troubleshooting

3. Switchover and failover operations using Cloud Control

1. Performing switchover/failover with Cloud Control
2. Configuring automatic failover policies
3. Testing and validating failover scenarios

1. Backup strategies in a Data Guard environment

1. Full database backups
2. Incremental backups
3. Archivelog backups

2. RMAN backup and recovery

1. Configuring RMAN for Data Guard
2. Backup and restore operations
3. Data Guard and RMAN best practices

3. Configuration best practices

1. Configuring backup retention policies
2. Optimizing backup performance
3. Testing backup and restore scenarios

1. Overview of Flashback Database feature

1. Purpose and benefits of Flashback Database
2. Architecture and prerequisites

2. Flashback Database and Data Guard integration

1. Configuring Flashback Database with Data Guard
2. Using Flashback Database for role transitions
3. Monitoring and managing Flashback Database

3. Flashback Database best practices

1. Flashback Database considerations
2. Configuring and optimizing Flashback Database
3. Troubleshooting Flashback Database issues

1. Automatic failover setup and configuration

1. Preparing for automatic failover
2. Configuring Data Guard for automatic failover
3. Testing and validating automatic failover

2. Fast-Start Failover (FSFO)

1. Introduction to FSFO
2. Configuring and managing FSFO
3. Monitoring and troubleshooting FSFO

1. Configuring Cloud Control for Automatic Failover

1. Cloud Control configuration for FSFO
2. Monitoring automatic failover using Cloud Control
3. Alert notifications and event handling

 2. Monitoring and managing failover using Cloud Control

1. Failover status and health monitoring
2. Failover testing and verification
3. Failover performance optimization

1. Switchover process and considerations

1. Planning and preparation for the switchover
2. Executing switchover operation
3. Validating switchover and verifying role transition

2. Post-switchover tasks

1. Post-switchover database synchronization
2. Monitoring and managing switchover operations
3. Troubleshooting switchover issues

1. Configuring Cloud Control for switchover operations

1. Configuring switchover policies in Cloud Control
2. Monitoring and managing switchover using Cloud Control
3. Alert notifications and event handling

 2. Notifications and alerts for switchover events

1. Configuring notification rules and recipients
2. Alert notifications for switchover events
3. Event handling and resolution procedures

1. Introduction to Fast-Start Failover (FSFO)

1. Purpose and benefits of FSFO
2. Architecture and prerequisites

 2. Configuring and managing FSFO

1. Configuring FSFO properties
2. Managing FSFO observer
3. Troubleshooting FSFO issues
4. Best practices for FSFO configuration

1. Configuring and managing failover clients

1. Configuring TAF for failover clients
2. Implementing connection failover
3. Client configuration best practices

2. Implementing Transparent Application Failover (TAF)

1. TAF configuration for JDBC, ODP.NET, and OCI clients
2. Testing and validating TAF scenarios
3. Troubleshooting TAF issues

1. Introduction to snapshot standby databases

1. Purpose and benefits of snapshot standby
2. Architecture and considerations

2. Configuration and management of snapshot standby

1. Snapshot standby configuration requirements
2. Snapshot standby management operations
3. Converting a physical standby to a snapshot standby

1. Overview of Oracle Active Data Guard

1. Features and benefits of Active Data Guard
2. Licensing considerations

2. Real-time query and reporting

1. Performing real-time queries on standby databases
2. Active Data Guard read-only operations
3. Reporting and analytics with Active Data Guard

1. Monitoring Data Guard using Enterprise Manager

1. Setting up Data Guard monitoring in Cloud Control
2. Monitoring standby database performance
3. Alert notifications and event handling

2. Troubleshooting and resolving common issues

1. Diagnosing and resolving data synchronization issues
2. Handling network and configuration problems
3. Troubleshooting log apply and redo transport

3. Patching and upgrading Data Guard configurations

1. Patching primary and standby databases
2. Rolling upgrades and phased upgrades
3. Best practices for patching and upgrading

1. Data Guard considerations for database upgrades

1. Preparing for database upgrades in a Data Guard environment
2. Impact of upgrades on primary and standby databases

2. Rolling upgrades and phased upgrades

1. Performing rolling upgrades in a Data Guard configuration
2. Planning and executing phased upgrades
3. Best practices for successful upgrades in Data Guard