Data Guard Training

This course is designed to keep in mind how important it is to keep databases available for use. Data Guard is in need of an hour for any database management. You will get to work on live scenarios with real-time data.

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

Physical Standby Dataguard Installation

• Install OS and Oracle software only

• Clone OS to Standby server and modify settings

• Install the database on the primary database server.

• Prepare the primary database.

• Set parameters in 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

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

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

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

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

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

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

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

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

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

DG Broker Activities

• LogXptmode

• Enable or disable APPLY

• Enable or disable TRANSPORT

• Switch over

• Failover

• Re-instate after the failover

• Change protection modes

• Disable configuration

• Drop standby database from configuration

• Remove configuration

Patching and Upgrading Databases in a Physical DataGuard Configuration

• Oracle Data Guard Broker Configuration

• Applying the 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), Part 1

• Rolling Upgrade for Physical Standby Dataguard (11.2.0.3 to 11.2.0.4), Part 2

• Rolling Upgrade for Physical Standby Dataguard (11.2.0.3 to 11.2.0.4), Part 3

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