Oracle Database 10g: Data Guard Administration

Co se naučíte

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. Students use Enterprise Manager Grid Control to create and manage their Data Guard configuration in the classroom. The course includes a workshop where students have the opportunity to apply what they have learned to meet stated business requirements.

Prepare the primary database for a Data Guard Configuration
Monitor a Standby configuration
Create a Physical Standby database
Create a Logical Standby database


Posluchači
Database Administrators
Support Engineer
Technical Consultant

Cíle kurzu
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

Témata kurzu

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