Oracle DataGuard 11g

Oracle Database 11g: Data Guard Administration Release 2

 

This Oracle Database 11g: Data Guard Administration Release 2 training helps you develop the skills to use Oracle Data Guard to help protect your Oracle database against planned and unplanned downtimes. Explore how Data Guard standby databases can be used to support production functions such as reporting, querying and testing, while in a standby role.

Learn To:

• Offload business processing needs to another system
• Offload backup needs to another system
• Build highly available systems
• Offload business processing needs to another system

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

Data Guard Architecture

This course explores Data Guard architecture, the configuration of physical standby databases and role transitions.

Required Prerequisite

• Oracle Database 11g: Administration Workshop I Release 2
• Oracle Database 11g: Administration Workshop II Release 2

Audience

• Database Administrators
• Support Engineer
• Technical Consultant

Course Objectives:

• Create and manage physical standby databases
• Use Data Guard standby databases to support production functions such as reporting, querying, testing, and performing backups
• Data Guard configuration with SQL
• Use Data Guard to achieve a highly available Oracle database

Course Topics

Introduction to Oracle Data Guard

• Oracle Data Guard Architecture
• Causes of Data Loss
• Types of Standby Databases (benefits of each type)
• Performing Role Transitions
• Data Protection Modes

Creating a Physical Standby Database by Using SQL and RMAN Commands

• Creating the Physical Standby Database
• Preparing the Primary Database

Creating and Managing a Snapshot Standby Database

• Activating a Snapshot Standby Database: Issues and Cautions
• Viewing Snapshot Standby Database Information
• Snapshot Standby Database: Architecture
• Converting a Physical Standby Database to a Snapshot Standby Database
• Converting a Snapshot Standby Database to a Physical Standby Database

×