• Understand Oracle Data Guard architecture and protection modes.
• Configure physical, logical, and snapshot standby databases.
• Configure redo transport and redo apply services.
• Create standby databases using SQL, RMAN, and DBCA.
• Configure and manage Data Guard Broker.
• Perform switchover, failover, and database reinstate operations.
• Configure Fast-Start Failover and observer environments.
• Implement backup, recovery, and Flashback strategies.
• Tune standby databases and redo transport.
• Perform Data Guard rolling upgrades.

Module 1: Data Guard Overview

• Overview of Oracle 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

Module 2: Data Guard Architecture

• Data Guard architecture
• Processes active on the primary database
• Processes active on the standby database
• Data Guard initialization parameters
• Data Guard with multitenant databases
• PDB creation and cloning in a multitenant environment

Module 3: Create a Physical Standby Database Using SQL Commands

• Prepare the primary database
• Configure initialization parameters
• Datafile and controlfile duplication
• Create the standby instance
• Configure network files
• Activate the standby database
• Verify primary and standby databases
• Handle archive log loss
• Open a standby database
• Start and shut down the Data Guard environment
• Configure managed recovery
• Open a physical standby in read-only mode
• Active Data Guard considerations
• Far Sync instance
• Monitor primary and standby databases

Module 4: Redo Transport Services

• Overview of redo transport
• Synchronous and asynchronous redo transport
• VALID_FOR attribute
• Transmission error handling
• Archive gap management
• Automatic outage resolution
• Protection modes
• Fast-Sync mode

Module 5: Redo Apply Services on a Physical Standby

• Log Apply Services
• Immediate redo application
• Delayed redo application
• Terminating redo apply
• Redo Apply features
• Cascading standby databases

Module 6: Change Management

• Adding datafiles and tablespaces
• Dropping tablespaces and datafiles
• Transportable tablespaces
• Renaming datafiles online
• Adding and dropping redo log files
• DML operations on Active Data Guard
• Recovering nonlogged blocks
• Automatic correction of nonlogged blocks
• Lost Write Detection
• Shadow Lost Write Protection
• Data Guard Database Compare

Module 7: Create a Standby Database with RMAN and DBCA

• Standby database creation with RMAN
• Creating suitable RMAN backups
• Standby paths and file names
• Building the standby instance
• Creating a standby database with RMAN
• Creating a standby from an active database
• Creating a standby database with DBCA in silent mode
• Creating a standby CDB with DBCA in silent mode

Module 8: Data Guard Broker Overview

• Oracle Data Guard Broker
• Oracle Enterprise Manager
• DGMGRL command-line interface
• Data Guard Monitor
• Starting and using Data Guard Broker
• Static service registration
• Obtaining diagnostic information
• Monitoring Data Guard processes

Module 9: Build a Configuration Using the Broker

• Prepare the Data Guard configuration
• Configure the primary database
• Configure the standby database
• Rename configurations
• SHOW DATABASE command
• VALIDATE command
• Validate databases and datafiles
• Validate SPFILE
• Validate network configuration
• Validate status connect identifier
• Enable and disable configurations
• Execute DGMGRL scripts

Module 10: Backup and Recovery in a Data Guard Configuration

• Implement a backup and recovery strategy
• RMAN in Data Guard environments
• Backup and recovery of primary databases
• Backup and recovery of physical standby databases
• Backup and recovery of logical standby databases
• RMAN Recovery Catalog
• Create and register a Recovery Catalog
• Configure incremental backups
• Recover lost datafiles and control files
• Recover lost online redo logs
• Restore and recover datafiles across the network
• Roll forward a physical standby using a service
• One-command standby refresh
• Block Change Tracking

Module 11: Flashback Database in a Data Guard Configuration

• Flashback Database overview
• Configure Flashback Database
• Use Flashback instead of applying redo
• Flashback with real-time apply
• Flashback through standby role transitions
• Automatic Flashback standby database
• Incomplete recovery with Flashback enabled

Module 12: Manage a Configuration Using the Broker

• Display and edit database properties
• Configure protection modes
• Validate databases
• Perform switchover
• Perform failover
• Preserve connections during role transitions
• Alter database state
• Export Broker configuration files
• Configure Fast-Start Failover
• Configure multiple failover targets
• Enable and disable Fast-Start Failover
• Configure observer mode
• Monitor the configuration
• Configure multiple observers

Module 13: Role Transition Using SQL Commands

• Role transition overview
• Prepare primary and standby databases
• Perform switchover
• Perform failover
• Reinstate a failed primary
• Preserve sessions during role transitions
• Application Continuity in Data Guard environments

Module 14: Create and Manage a Snapshot Standby Database

• Snapshot standby overview
• Convert physical standby to snapshot standby using SQL
• Convert physical standby to snapshot standby using Broker
• Convert snapshot standby back to physical standby

Module 15: Create and Manage a Logical Standby

• Logical standby overview
• Prepare the primary database
• Prepare the standby database
• Transition physical standby to logical standby
• Start and terminate SQL Apply
• Real-time apply
• Delete archives
• Monitor SQL Apply progress

Module 16: Tune a Standby Database

• Physical standby tuning
• Temporary undo
• Global and session variables
• Optimize SQL Apply
• Optimize redo transmission
• Redo compression
• Diagnostic Pack with Active Data Guard
• SQL Tuning Advisor
• Logical standby tuning
• Tables without primary keys
• Logical standby statistics
• Transaction consistency
• Adjust applier and preparer processes
• Tune LCR cache memory
• Configure ReopenSecs and NetTimeout

Module 17: Patching and Upgrading

• Upgrade Data Guard Broker configurations
• Rolling upgrade prerequisites
• Rolling upgrade with logical standby
• Rolling upgrade with physical standby
• Use the physru script
• Use DBMS_ROLLING
• Leading and trailing groups

Module 18: Data Guard Quick Setup Guide

• Physical standby setup using Data Guard Broker
• Primary server setup
• Initialization parameters
• Service setup
• Standby server setup
• Create standby using DUPLICATE
• Enable Broker
• Database switchover
• Database failover
• Read-only standby and Active Data Guard
• Create a snapshot standby

4 Days

• Discover the Data Guard practice environment.
• Configure Oracle Net Services for Data Guard.
• Prepare a primary database for Data Guard.
• Create a physical standby database.
• Configure redo transport and verify operation.
• Configure and manage redo apply.
• Perform structural changes on the primary database.
• Convert a physical standby to a snapshot standby.
• Convert a snapshot standby back to a physical standby.
• Create a logical standby database.
• Configure and use Data Guard Broker.
• Build and validate a Broker configuration.
• Perform switchover and failover operations.
• Reinstate a failed primary database.
• Configure Fast-Start Failover and observers.
• Implement Data Guard backup and recovery strategies.
• Use RMAN with Data Guard.
• Configure Flashback Database.
• Tune redo transport and SQL Apply.
• Perform Data Guard rolling upgrade activities.

Course Completion Certificate by Network Binary

• Oracle Database Administrators
• Database Engineers
• Database Architects
• Technical Support Professionals
• IT professionals responsible for database high availability
• Professionals responsible for Oracle disaster recovery and standby environments

• Working knowledge of Oracle Database Administration.
• Knowledge of Oracle Database Backup and Recovery with RMAN is recommended.
• Good working knowledge of Linux/UNIX is required.
• Equivalent Oracle 12c or 18c administration experience may be applicable.