Oracle Database 19c Data Guard

Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: DATA GUARD OVERVIEW

• Overview of Data Guard
• Requirements for Maintaining a Standby Database
• Data Guard Terminology
• Types of Standby Databases
• Levels of Protection
• Physical, Logical and Snapshot Standby Databases
• Role Transition Management Services
• Data Guard Interfaces
• Standby Database Creation
• Data Guard Installation
• SYSDG Administrative Privilege for Data Guard Operations

Session 2: DATA GUARD ARCHITECTURE

• Data Guard Architecture
• Processes Active on the Primary Database
• Processes Active on the Standby Database
• Data Guard Architecture and Initialization Parameters
• Data Guard usage with a Multitenant Database
• PDB Creation and Cloning in a Multitenant Architecture Environment

Session 3: CREATE A PHYSICAL STANDBY DATABASE USING SQL COMMANDS

• Prepare the Primary Database for Data Guard
• Initialization Parameters for the Standby Database
• Datafile and Controlfile Duplication
• Create the Standby Instance
• Network Files Configuration
• Activate the Standby Database
• Verify Primary and Standby Databases are Working
• Archive Log Loss
• Open the Standby Database
• Shut Down and Start Up the Data Guard Environment
• Put a Physical Standby Database in Managed Recovery Mode
• Put a Physical Standby Database in Read Only Mode
• Active Data Guard License
• Far Sync Instance
• Monitor the Primary and Standby Databases

Session 4: REDO TRANSPORT SERVICES

• Overview of Redo Transport Services
• How Data Guard Sends Redo Data with Synchronous and Asynchronous Transport
• Control when Redo Data is Sent with the VALID_FOR Option
• Handle Transmission Errors
• Manage Archive Gaps
• Automatic Outage Resolution with Data Guard in 19c
• Levels of Protection
• Fast-Sync Mode

Session 5: REDO APPLY SERVICES ON A PHYSICAL STANDBY DATABASE

• Overview of Log Apply Services
• Apply Redo Data Immediately
• Delay Redo Data Application
• Terminate Redo Apply Services
• Other Redo Apply Features
• Configure a Cascading Standby Database

Session 6: CHANGE MANAGEMENT

• Change Management Overview
• Add Datafiles or Tablespaces
• Drop Tablespaces and Delete Datafiles
• Transportable Tablespaces
• Rename Datafiles Online
• Add or Drop Redo Log Files
• DML Operations on Active Data Guard
• Recover Nonlogged Blocks
• Automatic Correction of Non-Logged Blocks
• Lost Write Detection
• Shadow Lost Write Protection
• Data Guard Database Compare

Session 7: CREATE A STANDBY DATABASE WITH RECOVERY MANAGER AND THE DBCA

• Overview of Standby Database Creation with RMAN
• Create a Suitable Backup with RMAN
• Standby Path and File Names
• Build the Standby Instance
• Create a Standby Database with RMAN
• Create a Standby Database with RMAN from an Active Database
• Create a Standby Database with the dbca in Silent Mode
• Create a Standby Database for a Multitenant Container Database with the dbca in Silent Mode

Session 8: DATA GUARD BROKER OVERVIEW

• Overview of Oracle Data Guard Broker
• Oracle Enterprise Manager
• The DGMGRL Command Line Interface
• Data Guard Monitor
• Install the Oracle Data Guard
• Start up and use the Data Guard Broker
• Configure Static Service Registration
• Obtaining Data Guard Diagnostic Information
• The v$DATAGUARD_PROCESS View

Session 9: BUILD A CONFIGURATION USING THE BROKER

• Prepare for a Configuration Build
• Configure the Primary Database
• Configure the Standby Database
• Rename a Configuration
• The SHOW DATABASE Command
• The VALIDATE Command
  • Validate a Database
  • Validate a Datafile
  • Validate the spfile
  • Validate Network Configuration
  • Validate Status Connect Identifier
• Enable and Disable the Configuration
• Execute DGMGRL Scripts

Session 10: BACKUP AND RECOVERY CONSIDERATIONS IN AN ORACLE DATA GUARD CONFIGURATION

• Implement a Backup and Recovery Strategy
• The Usage of RMAN in a Data Guard Configuration
• Backup and Recovery of a Primary Database with a Physical Standby Database
• Backup and Recovery of a Logical Standby Database
• Use a RMAN Recovery Catalog in a Data Guard Configuration
• Create the Recovery Catalog
• Register a Database in the Catalog
• Configure Daily Incremental Backups
• Recover from the Loss of Datafiles and Control Files on Primary and Standby Databases
• Recover from the Loss of Online Redo Logs
• Restore and Recover Datafiles across the Network
• Roll forward a Physical Standby Database using RECOVER A STANDBY DATABASE FROM SERVICE primary_db
• One Command Refresh of the Standby Database
• Enable Block Change Tracking for a Physical Standby Database

Session 11: USE FLASHBACK DATABASE IN A DATA GUARD CONFIGURATION

• Overview of Flashback Database Usage in a Data Guard Configuration
• Configure Flashback Database
• Use Flashback Database Instead of Apply Data
• Use Flashback Database and Real Time Apply
• Flashback through Standby Database Role Transitions
• Automatic Flashback Standby Database
• Incomplete Recovery if Flashback Database Enabled

Session 12: MANAGE A CONFIGURATION USING THE BROKER

• Display and Edit Database Properties
• Set the Configuration Protection Mode
• Validate a Database
• Execute a Switchover
• Execute a Failover
• Preserve Connections using Role Transmission
• Alter the state of a Database
• Export the Broker File Configuration Files
• Configure Fast Start Failover
• Configure Multiple Failover Targets
• Enable and Disable Fast Start Failover
• Configure Fast Start Failover in Observer Mode
• Export the Broker File
• Monitor the Configuration
• Configure Multiple Observers

Session 13: ROLE TRANSMISSION USING SQL COMMANDS

• Role Transition Overview
• Prepare the Primary Database
• Prepare the Standby Database
• Perform a Switchover
• Perform a Failover
• Reinstate the Failed Primary
• Preserve Sessions During Switchover or Failover
• Overview of Application Continuity in a Data Guard Environment

Session 14: CREATE AND MANAGE A SNAPSHOT STANDBY DATABASE

• Snapshot Standby Database Overview
• Convert a Physical Standby Database to a Snapshot Standby Database using SQL Commands
• Convert a Physical Standby Database to a Snapshot Standby Database using the Data Guard Broker

Session 15: CREATE AND MANAGE A LOGICAL STANDBY

• Overview of the Creation of a Logical Standby Database
• Prepare the Primary Database
• Prepare the Standby Database
• Transition a Physical Standby to a Logical Standby
• Start and Terminate Redo Apply Services
• Real Time Apply
• Delete Archives
• Monitor the SQL Apply Progress

Session 16: TUNE A STANDBY DATABASE

• Overview of Tuning a Physical Standby Database
• Temporary Undo, Global and Session Variables
• Optimize SQL Apply by Setting the ReopenSecs and NetTimeout Database Properties
• Optimize Redo Transmission
• Compress Redo Data
• Support for the Diagnostic Pack with Active Data Guard
• Support for the SQL Tuning Advisor
• Logical Standby Database Tuning
• The Significance of Tables without Primary Keys
• Statistics on the Logical Standby
• Transaction Consistency
• Optimize SQL Apply by Adjusting the Number of Applier Processes
• Optimize SQL Apply by Adjusting the Number of Preparer Processes
• Tune the Memory for the LCR Cache
• Set the ReopenSecs and NetTimeout Database Properties

Session 17: OVERVIEW OF PATCHING AND UPGRADING

• Upgrade the Oracle Data Guard Broker Configuration
• Rolling Upgrade Prerequisites
• Rolling Upgrade with a Logical Standby Database
• Rolling Upgrade with a Physical Standby Database
• Perform a Rolling Upgrade with the physru Script
• Use DBMS_ROLLING to Upgrade a Database
• Leading Group Databases and Leading Group Master
• Trailing Group Databases and Trailing Group Master

Session 18: DATA GUARD QUICK SETUP GUIDE

• Data Guard Physical Standby Setup using the Data Guard Broker
• Primary Server Setup
• Configure Initialization Parameters
• Service Setup
• Standby Server Setup
• Create a Standby Database using DUPLICATE
• Enable the Broker
• Database Switchover
• Database Failover
• Read-Only Standby and Active Data Guard
• Create a Snapshot standby