Oracle Dataguard
Module 1 : Introduction to Oracle Data Guard
- 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
Module 2 : 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
Module 3 : Oracle Net Services in a Data Guard Environment
- Understand the basics of Oracle Net Services
- Configure client connectivity in a Data Guard configuration
- Implement Data Guard best practice solutions in networking setup
Module 4 : 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
Module 5 : 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
Module 6 : 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
Module 7 : Creating a Logical Standby Database
- Determine when to create a logical standby database
- Create a logical standby database
- Manage SQL Apply filtering
Module 8 : Oracle Data Guard Broker: Overview
- 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
Module 9 : Creating a Data Guard Broker Configuration
- Create a Data Guard broker configuration
- Manage the Data Guard broker configuration
Module 10 : Monitoring a 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
Module 11 : Configuring Data Protection Modes
- Describe the data protection modes
- Change the data protection mode of your configuration
- Using Enterprise Manager Cloud Control
- Using DGMGRL
- Using SQL
Moudle 12 : Performing Role Transitions
- Explain the database roles
- Perform a switchover
- Perform a failover
Module 13 : Using Flashback Database in a Data Guard Configuration
- Explain the advantages of using Flashback Database in a Data Guard configuration
- Configure Flashback Database
Module 14 : 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
Module 15 : 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
- Recover your primary database by using a file from the physical standby database
Module 16 : Enhanced Client Connectivity 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
Module 17 : Patching and Upgrading Databases in a Data Guard Configuration
- 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
Module 18 : Optimizing a Data Guard Configuration
- Monitor configuration performance
- Optimize redo transport for best performance
- Optimize SQL Apply
Module 19 : Oracle Database Exadata Cloud Service Overview
- Describe the architecture and capabilities of Exadata Cloud Service
- Compare and contrast between Exadata Cloud Service and an on-premise Exadata implementation