In this course, students learn how to use Oracle Data Guard to help protect their Oracle Database against planned and unplanned downtimes. Data Guard architecture is discussed, as well as the creation of physical and logical standby databases. In addition, the course examines the performance implications of using various Data Guard features and offers some troubleshooting tips
Dirigido a
Database Administrators. Support Engineer. Technical Consultant
Camelia 17 (Urb. las Torres) Las Palmas de Gran Canaria 35010 Las Palmas (España)
Consultar con el centro Zaragoza 00000 Zaragoza (España)
Temario del curso
Configure Primary Database. Create physical Standby. Create logical standby. Manage Data Guard configuration with Enterprise Manager Grid Control. Use Data Guard with Real Application Clusters
Oracle Data Guard: Overview
Factors affecting planned and unplanned down time Components of Oracle Data Guard Differences between physical and logical standby databases Benefits of creating a Data Guard environment Use of Data Guard in high availability architecture
Understanding the Oracle Data Guard Architecture
Data Guard architecture Operational requirements of Data Guard Data Guard processes, transports, and redo log apply Standby database mode
Data Guard Broker and Enterprise Manager
Data Guard broker architecture Data Guard broker components benefits of the Data Guard broker Data Guard broker configurations Enterprise Manager to manage your Data Guard configuration DGMGRL to manage your Data Guard configuration
Creating a Configuration with Enterprise Manager
FORCE LOGGING create a broker configuration monitor the broker configuration
Creating a Physical Standby Database by Using SQL
SQL commands to create a physical standby database
Data Protection Modes and Log Transport Services
Data protection modes Changing the data protection mode of your configuration Modify log transport services
Data Guard SQL Apply Architecture
Advantages of SQL Apply When to use a logical standby database Creating a logical standby database by using Enterprise Manager
Creating a Logical Standby Database by Using SQL
Use SQL commands to create a logical standby database
Switchover and Failover
Database roles Switchover Failover Flashback Database after a failover
Using Data Guard with RAC
Data Guard in a Real Application Clusters environment Assign threads to standby redo logs Switchovers and failovers with RAC
Other Considerations for Oracle Data Guard
Back up the primary database with a physical standby database Back up a logical standby database Flashback Database features in a Data Guard configuration Encrypt redo information Cascaded redo log destinations