Oracle Data Guard Basics

• Describe the Architecture of Oracle Data Guard

• Explain the applicability between physical and logical standby and snapshot databases

• Explain the benefits of implementing Oracle Data Guard

• Explain Data Guard use with the Oracle Multi-tennant databases

Creating a Physical Standby Database by Using Enterprise Manager Cloud Control

• Create a Data Guard broker configuration

• Create a physical standby database

• Verify a Data Guard configuration

• Edit database properties related to Data Guard

• Test a Data Guard configuration

Managing Oracle Net Services in a Data Guard Environment

• Configure client connectivity in a Data Guard configuration

• Implement failover procedures to automatically redirect clients to a new primary database

• Using Application Continuity in a Data Guard Environment

Creating a Physical Standby Database by Using SQL and RMAN Commands

• Configure the primary database and Oracle Net Services to support the creation of the physical standby database and role transition

• Create a physical standby database by using the DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE RMAN command

Using Oracle Active Data Guard

• Use Real-time Query to access data on a physical standby database

• Enable RMAN block change tracking for a physical standby database

• Use Far Sync to extend zero data loss protection for intercontinental configurations

• Using Temporary Undo. Global Sequences and Session Sequences

• Using Automatic Block Media Recovery

• Configure Real-Time Cascading

Creating and Managing a Snapshot Standby Database

• Create a snapshot standby database to meet the requirement for a temporary, updatable snapshot of a physical standby database

• Convert a snapshot standby database back to a physical standby database

Creating a Logical Standby Database

• Determine when to create a logical standby database

• Create a logical standby database

• Manage SQL Apply filtering

Oracle Data Guard Broker Basics

• Describe the Data Guard broker architecture

• Describe the Data Guard broker components

• Explain the benefits of the Data Guard broker

• Describe Data Guard broker configurations

Creating a Data Guard Broker Configuration

• Create a Data Guard broker configuration

• Manage the Data Guard broker configuration

Monitoring a Data Guard Broker Configuration

• Use Enterprise Manager to manage your Data Guard configuration

• Invoke DGMGRL to manage your Data Guard configuration

Configuring Data Protection Modes

• Describe the data protection modes

• Change the data protection mode of your configuration

Performing Role Transitions

• Explain the database roles

• Perform a switchover

• Perform a failover

Using Flashback Database in a Data Guard Configuration

• Configure Flashback Database

• Explain the advantages of using Flashback Database in a Data Guard configuration

Enabling Fast-Start Failover

• Configure fast-start failover

• View information about the fast-start failover configuration

• Manage the observer

• Perform role changes in a fast-start failover configuration

• Manually reinstate the primary database

Backup and Recovery Considerations in an Oracle Data Guard Configuration

• Use Recovery Manager (RMAN) to back up and restore files in a Data Guard configuration

• Offload backups to a physical standby database

• Recovering databases in a Data Guard Environment

• Managing Archive Redo Logs in a Data Guard Environment

Patching and Upgrading Databases in a Data Guard Configuration

• Patch and upgrade databases using traditional patch methods

• Perform rolling upgrades

Optimizing a Data Guard Configuration

• Monitor configuration performance

• Optimize redo transport for best performance

• Optimize SQL Apply