Oracle DataGuard Administration

Oracle DataGuard Administration

Duration: 1 week
COURSE CONTENT
Introduction to Oracle Data Guard
 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)
 Physical Standby Database: Redo Apply Architecture
 Logical Standby Database: SQL Apply Architecture
 Data Protection Modes
 Data Guard Operational Requirements: Hardware and Operating System
 Benefits of Implementing Oracle Data Guard Creating a Physical Standby Database by Using SQL and

RMAN Commands
 Steps to Create a Physical Standby Database
 Preparing the Primary Database
 FORCE LOGGING Mode
 Configuring Standby Redo Logs
 Setting Initialization Parameters on the Primary Database
 Creating an Initialization Parameter File for the Physical Standby Database
 Creating the Physical Standby Database
 Enabling Real-Time Apply Oracle Data Guard Broker: Overview
 Oracle Data Guard Broker: Features
 Data Guard Broker: Components
 Data Guard Broker: Configurations
 Data Guard Broker: Architecture
 Data Guard Monitor: DMON Process
 Benefits of Using the Data Guard Broker
 Using the Command-Line Interface of the Data Guard Broker Creating a Data Guard Broker Configuration
 Data Guard Broker: Requirements
 Data Guard Monitor: Configuration File
 Creating a Broker Configuration
 Defining the Broker Configuration and the Primary Database Profile
 Adding a Standby Database to the Configuration
 Enabling the Configuration
 Disabling Broker Management of the Configuration or Standby Database Creating a Logical Standby Database
 Benefits of Implementing a Logical Standby Database
 Logical Standby Database: SQL Apply Architecture
 SQL Apply Process: Architecture
 Creating a Logical Standby Database by Using SQL Commands
 Adding a Logical Standby Database to a Data Guard Broker Configuration 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
 Viewing Snapshot Standby Database Information
 Using DGMGRL to View 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
 Understanding Lag in an Active Data Guard Configuration
 Enabling Block Change Tracking on a Physical Standby Database
 Creating Fast Incremental Backups Configuring Data Protection Modes
 Data Protection Modes and Redo Transport Modes
 Data Protection Modes
 Maximum Protection Mode
 Maximum Availability Mode
 Maximum Performance Mode
 Setting the Data Protection Mode by Using DGMGRL Performing Role Transitions
 Role Management Services
 Role Transitions: Switchover and Failover
 Preparing for a Switchover
 Performing a Switchover by Using DGMGRL
 Types of Failovers
 Performing a Manual Failover by Using DGMGRL Using Flashback Database in a Data Guard Configuration
 Using Flashback Database in a Data Guard Configuration
 Overview of Flashback Database
 Configuring Flashback Database

Enabling Fast-Start Failover
 Fast-Start Failover: Overview
 When Does Fast-Start Failover Occur
 Installing the Observer Software
 Fast-Start Failover Prerequisites
 Configuring Fast-Start Failover Monitoring a Data Guard Broker Configuration
 Monitoring the Data Guard Configuration
 Viewing the Data Guard Configuration Status
 Using the SHOW CONFIGURATION DGMGRL Command
 Monitoring Redo Apply by Querying V$MANAGED_STANDBY
 Evaluating Redo Data by Querying V$DATAGUARD_STATS
 Viewing Data Guard Status Information by Querying V$DATAGUARD_STATUS