DATAGUARD

Oracle Data Guard: Overview

-- What Is Oracle Data Guard?

-- Types of Standby Databases

-- Data Guard Broker Framework

-- Types of Services

-- Benefits of Implementing Oracle Data Guard

Understanding the Oracle Data Guard Architecture

Oracle Data Guard Architecture

Data Guard Redo Apply Architecture

Data Guard SQL Apply Architecture

Specifying Role-based Destinations

Configuring Standby Redo Logs

Standby Database Modes

Using Oracle Data Guard Broker

Oracle Data Guard Broker Features

Data Guard Broker Configurations

Benefits of Using the Data Guard Broker

Data Guard Broker Interfaces

Creating a Physical Standby Database by Using SQL

Preparing the Primary Database

Setting Initialization Parameters on the Primary Database

Backing Up the Primary Database Using RMAN

Creating a Control File for the Standby Database

Setting Initialization Parameters on the Standby Database

Setting Up the Environment to Support the Standby Database

Starting the Physical Standby Database

Performing Additional Configuration Tasks

Configuring Data Protection Modes and Log Transport Services

Setting the Log Transport Mode

Setting the Data Protection Mode

Delaying the Application of Redo

Using Flashback Database as an Alternative to Apply Delay

Additional Attributes that Affect Log Transport Services

Creating a Logical Standby Database by Using SQL

Preparing to Create a Logical Standby Database

Creating a Physical Standby Database

Preparing the Primary Database

Transitioning to a Logical Standby Database

Opening the Logical Standby Database

Verifying the Logical Standby Database

Performing Additional Configuration Tasks

Performing Switchover and Failover

Choosing the Best Role Transition Operation

Performing a Switchover by Using Enterprise Manager

Performing a Switchover by Using SQL

Performing a Failover by Using Enterprise Manager

Performing a Failover by Using SQL

Restoring Databases After a Role Transition

Flashback Through Standby Database Role Transitions

Enabling Fast-Start Failover

When Will Fast-Start Failover Occur?

Configuring Fast-Start Failover

Prohibited Operations After Enabling Fast-Start Failover

Managing the Observer

Performing Role Changes

Using Enterprise Manager to Enable Fast-Start Failover

Untitled Document