Dataguard Training | Real time Dataguard Training

1.  Introduction to Oracle Data Guard

• Introduction to Oracle Data Guard
• Oracle Data Guard: Architecture (Overview)

2.  Oracle Net Services in a Data Guard Environment

• Oracle Net Services in a Data Guard Environment
• Configuring the tnsnames.ora file
• Configuring the listener.ora file

3.  Creating a Physical Standby Database by Using SQL and RMAN Commands

• Creating a Physical Standby Database by Using SQL and RMAN Commands
• Combinations for VALID_FOR
• Example: Setting Initialization Parameters on the Primary Database
• Creating a Physical Standby Database by Using Enterprise Manager
• Prepare the Primary Database to Support Data Guard
• Prepare Host and Create Physical Database
• Start Redo Transport and Verify Operation

4. Managing Physical Standby Files After Structural Changes on the Primary Database

• Managing Physical Standby Files After Structural Changes on the Primary Database
• Resetting the TDE Master Encryption Key
• Refreshing the Password File
• Controlling PDB Replication
• Automating Instantiation of a PDB

5.  Using Oracle Active Data Guard: Supported Workloads in Read-Only Standby

• Using Oracle Active Data Guard: Supported Workloads in Read-Only Standby
• Creating an AFTER LOGON Trigger for Synchronization
• DDL on Global Temporary Tables
• DML Operations on Active Data Guard Standby Databases
• Enable Active Data Guard Real-Time Query
• Performing DDL/DML on Global Temporary Table
• Managing Private Temporary Table for DDL/DML
• Configuring Automatic Redirection of DML operations

6.  Using Oracle Active Data Guard: Far Sync and Real-Time Cascading

• Using Oracle Active Data Guard: Far Sync and Real-Time Cascading
• Far Sync: Alternate Design
• Add Far Sync to the Data Guard Environment
• Add 2nd Far Sync to the Data Guard Environment

7.  Creating and Managing a Snapshot Standby Database

• Creating and Managing a Snapshot Standby Database
• Convert Physical Standby to a Snapshot Standby
• Convert Snapshot Standby Back to Physical Standby
• Creating and Managing a Snapshot Standby Database

8.  Creating a Logical Standby Database

• Creating a Logical Standby Database
• Creating a Logical Standby Database by Using SQL Commands
• Identify Unsupported Objects for Logical Standbys
• Create a Logical Standby (Temporarily a Physical)
• Start Redo Transport and Verify Operation
• Convert Physical Standby to Logical Standby

9.  Oracle Data Guard Broker: Overview

• Oracle Data Guard Broker: Overview

10. Creating a Data Guard Broker Configuration

• Creating a Data Guard Broker Configuration
• Changing Database Properties and States
• Establishing Local and Remote Connections with DGMGRL
• Create and Enable a Data Guard Broker Configuration
• Verify and Examine the Data Guard Environment
• Creating a Data Guard Broker Configuration

11. Monitoring a Data Guard Broker Configuration

• Monitoring a Data Guard Broker Configuration
• Viewing Data Guard Diagnostic Information
• Monitoring the Physical Standby Database
• Examining Data Guard Log and Trace Files
• Using the VALIDATE commands

12. Configuring Data Protection Modes

• Configuring Data Protection Modes
• Maximum Availability Mode
• Examining the Maximum Availability Protection Mode
• Examining the Maximum Protection Mode
• Configuring Data Protection Modes

13. Optimizing and Tuning a Data Guard Configuration

• Optimizing and Tuning a Data Guard Configuration
• Tuning Automatic Outage Resolution
• Configuring Network Compression of Redo Data
• Generating AWR Report for an Active Data Guard Instance
• Using ADDM for an Active Data Guard Instance
• Using SQL Tuning Advisor for an Active Data Guard Instance

• Optimizing and Tuning a Data Guard Configuration

14. Performing Role Transitions

• Performing Role Transitions
• Validating Databases for Switchover by Using DGMGRL
• Performing Switchover
• Keeping Physical Standby Session Connected During Role Transition
• Performing Role Transitions

15. Using Flashback Database in a Data Guard Configuration

• Using Flashback Database in a Data Guard Configuration
• Configuring Flashback Database on the Primary Database
• Configuring Flashback Database on the Physical Standby Database
• Configuring Flashback Database on the Logical Standby Database
• Testing Automatic Flashback of Standby Database
• Performing Flashback of the Logical Standby Database
• Using Flashback Database in a Data Guard Configuration

16. Enabling Fast-Start Failover

• Enabling Fast-Start Failover
• Configuring Automatic Reinstatement of the Primary Database
• Using Enterprise Manager to Enable Fast-Start Failover
• Configuring Fast-Start Failover in Observer-Only Mode
• Enabling Fast-Start Failover
• Testing Fast-Start Failover
• Switchover to Reinstated Database
• Enabling Fast-Start Failover

17. Backup and Recovery Considerations in an Oracle Data Guard Configuration

• Backup and Recovery Considerations in an Oracle Data Guard Configuration
• Backup and Recovery of a Logical Standby Database
• Recovering from the Loss of a Data File on the Primary Database
• Enable Change Tracking on the Physical Standby Database
• Creating a Recovery Manager Catalog

• Registering Your Database in the Recovery Catalog
• Configuring RMAN Parameters
• Recovering a Data File on Your Primary Database Over the Network
• Rolling Forward a Standby Database with One Command

18. Enhanced Client Connectivity in a Data Guard Environment

• Enhanced Client Connectivity in a Data Guard Environment
• Data Guard Broker and Fast Application Notification (FAN)
• Creating and Testing Primary Database Services
• Modifying the Primary Database Service for Application Continuity
• Enhanced Client Connectivity in a Data Guard Environment

19. Patching and Upgrading Databases in a Data Guard Configuration

• Patching and Upgrading Databases in a Data Guard Configuration
• Performing a Rolling Upgrade by Using a Physical Standby Database
• Rolling Upgrades Using DBMS_ROLLING and Active Data Guard