Oracle DataGuard 11g

Course Duration: 35 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

timeline_pre_loader

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

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

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

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

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

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

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

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

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

Data Guard Broker: Requirements

Data Guard Broker and the SPFILE

Data Guard Monitor: Configuration File

Data Guard Broker: Log Files

Creating a Broker Configuration

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

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

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)

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

Download Oracle DataGuard 11g Brochure

Signup today and get latest Videos and Upcoming Courses for free and be the first to get notified on new updates.

Subscribe to our mailing list