Oracle Data Guard Part 1

Course Description

 

This Oracle online training course will describe the components of Oracles’ Data Guard tool. This training covers the differences between the physical and logical databases and the overall architecture of Data Guard. You will also learn how to use Oracle’s Data Guard with Grid Control. 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 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.

 

Once you have completed the Oracle Data Guard Part 1 the next course in this series is Oracle Data Guard Part 2. Oracle Data Guard Part 2 will continue to build your skills through learning how to backup an Oracle data guard environment, implementing a failover and switchover, and utilizing data guard with flashback database technology as well as RMAN commands. Click here to learn more about Oracle Data Guard Part 2.

 

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 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

 

Outline

 

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

 

Module 01: Data Guard Components

  • Identify what is Oracles' Data Guard
  • Describe the differences between a physical and logical standby
  • Quiz

 

Module 02: Data Guard Transport Method

  • Redo Transport Services
  • Apply Services
  • Role Management Services

 

Module 03: Differences between Failover and Switchover

  • Database Failover
  • Database Switchover

 

Module 04: Demo: Failover and Switchover

 

Module 05: Data Guard Framework

  • Data Guard Broker
  • Standby Database
  • Oracles Grid
  • Quiz

 

Module 06: Data Guard Broker Configuration

  • Using Data Guard Broker
  • Non Data Guard Broker

 

Module 07: Defining Gap Resolution

  • Resolving Gaps with Redo Apply
  • Resolving Gaps with Archive Apply

 

Module 08: Defining Protection Modes

  • Maximum Protection
  • Maximum Availability
  • Maximum Performance
  • Quiz

 

Module 09: Operating System Requirements

  • CPU Requirements
  • Memory Requirements
  • Operating System Binaries
  • Oracle Binaries

 

Module 10: Manually Creating a Physical Standby Database

  • Create a Physical Standby database
  • Modify initialization parameters
  • Verify the Standby database is receiving logs

 

Module 11: Physical Standby Database and Grid

  • Creating a Standby database with Grid
  • Verify the Standby Databases
  • View the configuration Status
  • Quiz

 

Module 12: Demo: Creating a Physical Standby with Grid

 

Module 13: Logical Standby Database

  • Manually Create a Logical Standby Database
  • Create the Standby Database using SQL/RMAN
  • Verify the Standby database is functional

 

Module 14: Using Grid to Create a Logical Database

  • Set up the Logical Standby database
  • Configure the Logical Standby Database
  • Create the Standby Database with Grid
  • Quiz

 

Module 15: Demo: Creating a Logical Standby with Grid