Oracle DataGuard 11g

Home > Courses > Oracle DataGuard 11g

Course Duration: 30 Hours

Course Highlights:

  • Understand the concepts of Oracle Data Guard Architecture.
  • Create, Manage and monitor physical and Logical Standby database.
  • Perform role Transitions: Switchover and Failover.
  • Implement Oracle Active Data Guard.
  • Create and manage Snapshot Standby database.
  • Use RMAN in a Data Guard Environment.
  • Implement client failover in a Data Guard Configuration.
  • Implement and manage Data Guard Broker.
  • Implement Fast-start Failover.
  • Rolling Upgrade and Patching in Data Guard Environment.

Required Prerequisites:

  • Basic Knowledge of Unix Command.
  • Oracle Database: Introduction to SQL
  • Good knowledge of Oracle Database Administrator 11g

Target Audience:

  • Oracle DBA who want to learn Oracle Data Guard which ensure high availability, data protection and disaster recovery for enterprise data.

Download Oracle DataGuard 11g Brochure

Course Content

Section 1: Introduction to Oracle Data Guard

Software’s that we use

What Is Oracle Data Guard?

Types of Standby Databases

Types of Data Guard Services

Role Transitions: Switchover and Failover

Oracle Data Guard Broker Framework

Choosing an Interface for Administering a Data Guard Configuration

Oracle Data Guard: Architecture (Overview)

Primary Database Processes

Standby Database Processes

Physical Standby Database: Redo Apply Architecture

Logical Standby Database: SQL Apply Architecture

Automatic Gap Detection and Resolution

Data Protection Modes

Data Guard Operational Requirements: Hardware and Operating System

Data Guard Operational Requirements: Oracle Database Software

Benefits of Implementing Oracle Data Guard

Section 2: Physical Standby Dataguard Installation

Install OS and Oracle software only

Clone OS to Standby server and modify settings

Install database on Primary database server.

Prepare the primary database.

Set parameters on the physical standby database.

Configure Oracle Net Services.

Start the standby database instance.

Execute the DUPLICATE TARGET DATABASE FOR STANDBY RMAN command.

Start the transport and application of redo.

Physical Standby dataguard Health check

Section 3: Creating and Managing a Snapshot Standby Database

Snapshot Standby Databases: Overview

Snapshot Standby Database: Architecture

Converting a Physical Standby Database to a Snapshot Standby Database

Activating a Snapshot Standby Database:Issues and Cautions

Snapshot Standby Database: Target Restrictions

Viewing Snapshot Standby Database Information

Converting a Snapshot Standby Database to a Physical Standby Database

Section 4: Using Oracle Active Data Guard

Oracle Active Data Guard

Using Real-Time Query

Checking the Standby’s Open Mode

Setup active dataguard – REAL TIME APPLY

Understanding Lag in an Active Data Guard Configuration

Monitoring Apply Lag:
V$DATAGUARD_STATS

Monitoring Apply Lag: V$STANDBY_EVENT_HISTOGRAM

Configuring Zero Lag Between the Primary and Standby Databases

Setting STANDBY_MAX_DATA_DELAY by Using an AFTER LOGON Trigger

Enabling Block Change Tracking on a Physical Standby Database

Creating Fast Incremental Backups

Monitoring Block Change Tracking

Section 5: Configuring Data Protection Modes

Data Protection Modes and Redo
Transport Modes

Data Protection Modes

Maximum Protection Mode

Maximum Availability Mode

Maximum Performance Mode

Comparing Data Protection Modes

Changing Protection Modes

Section 6: Performing Role Transitions

Role Management Services

Role Transitions: Switchover and Failover

Switchover

Switchover: Before

Switchover: After

Preparing for a Switchover

Performing a Switchover

Situations That Prevent a Switchover

Failover

Types of Failovers

Failover Considerations

Performing a Manual Failover

Re-enabling Disabled Databases

Section 7: Backup and Recovery Considerations in an Oracle Data Guard Configuration

Using RMAN to Back Up and Restore Files in a Data Guard Configuration

Offloading Backups to a Physical Standby

Restrictions and Usage Notes

Using the RMAN Recovery Catalog in a Data Guard Configuration

Setting Persistent Configuration Settings

Setting RMAN Persistent Configuration Parameters on the Primary Database

Setting RMAN Persistent Configuration Parameters on the Physical Standby Database

Configuring Daily Incremental Backups

Recovering from Loss of a Data File on the Primary Database

Using a Backup to Recover a Data File on the Primary Database

Using a Physical Standby Database Data File to Recover a Data File on the Primary Database

Recovering a Data File on the Standby Database

Enhancements to Block Media Recovery

Executing the RECOVER BLOCK Command

Excluding the Standby Database

Section 8: Managing Client Connectivity

Understanding Client Connectivity in a Data Guard Configuration

Understanding Client Connectivity: Using Local Naming

Preventing Clients from Connecting to the Wrong Database

Managing Services

Understanding Client Connectivity: Using a Database Service

Creating Services for the Data Guard Configuration Databases

Connecting Clients to the Correct Database

Creating the AFTER STARTUP Trigger

Configuring Service Names in the tnsnames.ora File

Automatic Failover of Applications to a New Primary Database

Automating Failover for OCI Clients

Perform a SWITCH OVER operation and verify the connectivity from CLIENT server

Section 9: Oracle Data Guard Broker: Overview

Oracle Data Guard Broker: Features

Data Guard Broker: Components

Data Guard Broker: Configurations

Data Guard Broker: Management Model

Data Guard Broker: Architecture

Data Guard Monitor: DMON Process

Benefits of Using the Data Guard Broker

Comparing Configuration Management With and Without the Data Guard Broker

Data Guard Broker Interfaces

Using the Command-Line Interface of the Data Guard Broker

Section 10: Creating a Data Guard Broker Configuration

Data Guard Broker: Requirements

Data Guard Broker and the SPFILE

Data Guard Monitor: Configuration File

Data Guard Broker: Log Files

Creating a Broker Configuration

Section 11: Enabling Fast-Start Failover

When Does Fast-Start Failover Occur?

Installing the Observer Software

Fast-Start Failover Prerequisites

Configuring Fast-Start Failover

Viewing Fast-Start Failover Information

Determining the Reason for a Fast-Start Failover

Prohibited Operations After Enabling Fast-Start Failover

Disabling Fast-Start Failover

Disabling Fast-Start Failover Conditions

Using the FORCE Option and stopping observer

Section 12:DG broker activities

LogXptmode

Enable / disable APPLY

Enable / disable TRANSPORT

Switch over

Failover

Re-instate after the failover

Change protection modes

Disable configuration

Drop standby database from

configuration

Remove configuration

Section 13: Patching and Upgrading Databases in a Physical DataGuard Configuration

Oracle Data Guard Broker
Configuration

Applying PSU (11.2.0.3.13) patch

Normal Upgrade (11.2.0.3 to 11.2.0.4)

Rolling Upgrade for Physical Standby Dataguard (11.2.0.3 to 11.2.0.4) – Summary

Rolling Upgrade for Physical Standby Dataguard (11.2.0.3 to 11.2.0.4)

Section 14: Creating a Logical Standby Database

Benefits of Implementing a Logical Standby Database

Logical Standby Database: SQL Apply Architecture

SQL Apply Process: Architecture

Preparing to Create a Logical Standby Database

Unsupported Objects, Data types, PL/SQL objects and DDL’s

Ensuring Unique Row Identifiers

Creating a Logical Standby Database by Using SQL Commands – overview

Creating a Logical Standby Database by Using SQL Commands

Securing Your Logical Standby Database

Automatic Deletion of Redo Log Files by SQL Apply

Managing Remote Archived Log File Retention

Signup today and be the first to get notify on latest videos and upcoming batches.

Subscribe to our mailing list