Oracle Data Guard Part 2

Course Description

This Oracle online training course will explain how to backup an Oracle Data Guard environment. This training also discusses how to implement failover and switchover. Additionally, we will utilize data guard with flashback database technology as well as RMAN commands. This course uses Enterprise Manager 1g Grid Control (10.2.0.x) and Grid Release 10.2.0.2.1.

In order to take this course you need to have taken Oracle Data Guard Part 1, Oracle 10g/11g Database Administration I Part 1 and Part 2 and Oracle 10g/11g Database Administration II Part 1 and Part 2 and have six months database administrator experience.

In This Course You Will Learn How To:

• Implement Oracle Data Guard

• Create a Physical and Logical Standby Database

• Create Data Guard with Oracle Grid Control

• Describe the Data Guard components

Prerequisites

You need to have six months database administrator experience and have taken Oracle Data Guard Part 1 or have taken the following courses:

• Oracle 10g/11g Database Administration I Part 1

• Oracle 10g/11g Database Administration I Part 2

• Oracle 10g/11g Database Administration II Part 1

• Oracle 10g/11g Database Administration II Part 2

• Oracle Data Guard Part 1

Outline

Module 00: Oracle Data Guard Part 2 Online Training - Course Introduction

Module 01: Backup Methods and Data Guard

• Flashback database and Data Guard

• RMAN commands and Data Guard

• SQL Commands and Data Guard

• Quiz

Module 02: Flashback Database and Data Guard

• Using Flashback database instead of Apply Delay

• Recover the database from a prior point in time

• Use Real-time Apply

• Quiz

Module 03: Demo: Implementing Flashback Database

Module 04: Backing up in a Data Guard Environment

• Oracle Managed Backups

• User Managed Backups

• Recovery in a Data Guard Environment

• Quiz

Module 05: Demo: Backing up a Data Guard Database

Module 06: Data Guard and Failover

• Define Failover

• Define Failover versus Switchover

• Perform a manual Failover

Module 07: Grid and Failover

• Identify Failover needs

• Perform a Failover using Grid

Module 08: Data Guard and Switch Over

• Define Switchover

• Define Switchover versus Failover

• Perform a manual Switchover

Module 09: Grid and Switch Over

• Identify Switchover requirements

• Perform a Switchover using Grid

Module 10: Define Fast Start Failover

• Configure Fast Start Failover

• Monitor Fast Start Failover

• Re-instating the database

• Quiz

Module 11: Failover Client

• Configure automatic failover for OCI Clients

• Configure automatic failover for JDBC clients

• Design database mirroring

• Quiz

Module 12: Define a Snapshot Standby Database

• Convert a physical Standby Database to a Snapshot DB

• Using a Snapshot Database

• Monitoring the Snapshot Database

Module 13: Oracle Active Data Guard

• Define Oracle Active Data Guard

• Implement Active Data Guard

Module 14: Managing Data Guard Components

• Data Guard Monitoring Tools

• Using Grid and Data Guard

• View Dynamic performance views

Module 15: Demo: Monitoring Data Guard Components

Module 16: Upgrading databases with Data Guard

• Use SQL apply to upgrade

• Use Physical Standby for rolling upgrades