About this Course

In this course, students learn how to use Oracle Data Guard to help protect their Oracle database against planned and unplanned downtimes. They also learn how Data Guard standby databases can be used to support production functions such as reporting, querying, and testing, while in a standby role.

The course includes Data Guard architecture, the configuration of physical and logical standby databases, and role transitions. Oracle Data Guard 11g features, including Oracle Active Data Guard and snapshot standby databases are outlined. In addition, management of a Data Guard configuration and troubleshooting are discussed.

COURSE OUTLINE

• Introduction to Oracle Data Guard
  
• Creating a Physical Standby Database by Using SQL and RMAN Commands
  
• Oracle Data Guard Broker: Overview
  
• Creating a Data Guard Broker Configuration
  
• Creating a Physical Standby Database by Using Enterprise Manager Grid Control
  
• Creating a Logical Standby Database
  
• Creating and Managing a Snapshot Standby Database
  
• Using Oracle Active Data Guard
  
• Configuring Data Protection Modes
  
• Performing Role Transitions
  
• Using Flashback Database in a Data Guard Configuration
  
• Enabling Fast-Start Failover
  
• Managing Client Connectivity
  
• Performing Backup and Recovery Considerations in an Oracle Data Guard Configuration
  
• Patching and Upgrading Databases in a Data Guard Configuration
  
• Monitoring a Data Guard Configuration
  
• Optimizing a Data Guard Configuration
  

LEARNING OUTCOME

Upon successful completion of this course, students will be able to:

• Use Data Guard standby databases to support production functions such as reporting, querying, testing, and performing backups
  
• Create and manage physical and logical standby databases
  
• Use Enterprise Manager Grid Control and the Data Guard command-line interface (DGMGRL) to maintain a Data Guard configuration
  
• Use Data Guard to achieve a highly available Oracle database
  

TARGET AUDIENCE

This course is intended for:

• Database Administrators
  
• Support Engineer
  
• Technical Consultant
  

Suggested Pre-requisite

Oracle Enterprise Manager 10g Grid Control 

Oracle Database 11g: Administration Workshop I Release 2 

Oracle Database 11g: Administration Workshop II Release 2

Rate this course:

Log in to submit

Comments