12c Dataguard Admin

• 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

• Understand the basics of Oracle Net Services
• Configure client connectivity in a Data Guard configuration
• Implement Data Guard best practice solutions in networking setup

• 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 

• 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

• 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

• Determine when to create a logical standby database
• Create a logical standby database
• Manage SQL Apply filtering

• The Data Guard broker architecture
• Data Guard broker components
• Benefits of the Data Guard broker
• Data Guard broker configurations
• How to use Enterprise Manager to manage your Data Guard configuration
• How to invoke DGMGRL to manage your Data Guard configuration

• Create a Data Guard broker configuration
• Manage the Data Guard broker configuration

• Use Enterprise Manager Cloud Control to monitor the configuration
• Use DGMGRL to monitor the configuration
• Use SQL to monitor the configuration

• Describe the data protection modes
• Change the data protection mode of your configuration

        – Using Enterprise Manager Cloud Control

        – Using DGMGRL

        – Using SQL

• Explain the database roles
• Perform a switchover
• Perform a failover

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

• 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

• Use Recovery Manager (RMAN) to back up and restore files in a Data Guard configuration
• Offload backups to a physical standby database
• Recover your primary database by using a file from the physical standby database

• Configure client connectivity in a Data Guard configuration
• Implement failover procedures to automatically redirect clients to a new primary database

• By using Standby-First Patch Apply technique
• By using traditional upgrade methods
• By performing rolling upgrades
• By using the DBMS_ROLLING package with Active Data Guard

• Monitor configuration performance
• Optimize redo transport for best performance
• Optimize SQL Apply

• Describe the architecture and capabilities of Exadata Cloud Service
• Compare and contrast between Exadata Cloud Service and an on-premise Exadata implementation

• Describe the basic components of Oracle Data Guard
• Explain the differences between physical and logical standby databases
• Explain the benefits of implementing Oracle Data Guard