Upgrading Oracle DBA skills with DataGuard is vital to manage database environments where High Availability and Disaster Recovery is a major requirement. We will make it easy for you to learn, implement and achieve High Availability, Disaster Recovery, Reporting environment, Performance improvement in your environment with this course.

Get hands-on real time activities experience on standalone Oracle Database environment now.

  • Covers concepts and Real-Time activities
  • Install and Implement yourself.
  • Simple and easy to understand.
  • Align with industry standards.

System requirements:

  • Laptop/Desktop with at least 6GB RAM.
  • Minimum of Dual Core processor + Hyper threading.
  • 80 GB of disk space.

Training details:

  • 21 Sessions.
  • Trainer: Pawan Kumar Yaddanapudi.
  • Includes supporting documents, software’s and Log files.
  • Anytime assistance.

 

Pick your mode of learning:

Video tutorials:

  • Learn at your own pace.
  • Saves 50% of your money.
  • Revise any number of times for 6 months.
  • Assured quality and content as classroom/online training.

Online training:

  • One scheduled session per day.
  • Good internet connectivity required.
  • Batch of minimum 5 students.

Click Here for Online Training Schedule

Course Content

  1. Introduction to Oracle Data Guard
  • Software’s that we use
  • 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)
  • Primary Database Processes
  • Standby Database Processes
  • Physical Standby Database: Redo Apply Architecture
  • Logical Standby Database: SQL Apply Architecture
  • Automatic Gap Detection and Resolution
  • Data Protection Modes
  • Data Guard Operational Requirements: Hardware and Operating System
  • Data Guard Operational Requirements: Oracle Database Software
  • Benefits of Implementing Oracle Data Guard
  1. Physical Standby Dataguard Installation
  • Install OS and Oracle software only
  • Clone OS to Standby server and modify settings
  • Install database on Primary database server.
  • Prepare the primary database.
  • Set parameters on the physical standby database.
  • Configure Oracle Net Services.
  • Start the standby database instance.
  • Execute the DUPLICATE TARGET DATABASE FOR STANDBY RMAN command.
  • Start the transport and application of redo.
  • Physical Standby dataguard Health check
  1. 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
  • Snapshot Standby Database: Target Restrictions
  • Viewing Snapshot Standby Database Information
  • Converting a Snapshot Standby Database to a Physical Standby Database
  1. Using Oracle Active Data Guard
  • Oracle Active Data Guard
  • Using Real-Time Query
  • Checking the Standby’s Open Mode
  • Setup active dataguard – REAL TIME APPLY
  • Understanding Lag in an Active Data Guard Configuration
  • Monitoring Apply Lag: V$DATAGUARD_STATS
  • Monitoring Apply Lag: V$STANDBY_EVENT_HISTOGRAM
  • Configuring Zero Lag Between the Primary and Standby Databases
  • Setting STANDBY_MAX_DATA_DELAY by Using an AFTER LOGON Trigger
  • Enabling Block Change Tracking on a Physical Standby Database
  • Creating Fast Incremental Backups
  • Monitoring Block Change Tracking
  1. Configuring Data Protection Modes
  • Data Protection Modes and Redo Transport Modes
  • Data Protection Modes
  • Maximum Protection Mode
  • Maximum Availability Mode
  • Maximum Performance Mode
  • Comparing Data Protection Modes
  • Changing Protection Modes
  1. Performing Role Transitions
  • Role Management Services
  • Role Transitions: Switchover and Failover
  • Switchover
  • Switchover: Before
  • Switchover: After
  • Preparing for a Switchover
  • Performing a Switchover
  • Situations That Prevent a Switchover
  • Failover
  • Types of Failovers
  • Failover Considerations
  • Performing a Manual Failover
  • Re-enabling Disabled Databases
  1. Backup and Recovery Considerations in an Oracle Data Guard Configuration
  • Using RMAN to Back Up and Restore Files in a Data Guard Configuration
  • Offloading Backups to a Physical Standby
  • Restrictions and Usage Notes
  • Using the RMAN Recovery Catalog in a Data Guard Configuration
  • Setting Persistent Configuration Settings
  • Setting RMAN Persistent Configuration Parameters on the Primary Database
  • Setting RMAN Persistent Configuration Parameters on the Physical Standby Database
  • Configuring Daily Incremental Backups
  • Recovering from Loss of a Data File on the Primary Database
  • Using a Backup to Recover a Data File on the Primary Database
  • Using a Physical Standby Database Data File to Recover a Data File on the Primary Database
  • Recovering a Data File on the Standby Database
  • Enhancements to Block Media Recovery
  • Executing the RECOVER BLOCK Command
  • Excluding the Standby Database
  1. Managing Client Connectivity
  • Understanding Client Connectivity in a Data Guard Configuration
  • Understanding Client Connectivity: Using Local Naming
  • Preventing Clients from Connecting to the Wrong Database
  • Managing Services
  • Understanding Client Connectivity: Using a Database Service
  • Creating Services for the Data Guard Configuration Databases
  • Connecting Clients to the Correct Database
  • Creating the AFTER STARTUP Trigger
  • Configuring Service Names in the tnsnames.ora File
  • Automatic Failover of Applications to a New Primary Database
  • Automating Failover for OCI Clients
  • Perform a SWITCH OVER operation and verify the connectivity from CLIENT server
  1. Oracle Data Guard Broker: Overview
  • Oracle Data Guard Broker: Features
  • Data Guard Broker: Components
  • Data Guard Broker: Configurations
  • Data Guard Broker: Management Model
  • Data Guard Broker: Architecture
  • Data Guard Monitor: DMON Process
  • Benefits of Using the Data Guard Broker
  • Comparing Configuration Management With and Without the Data Guard Broker
  • Data Guard Broker Interfaces
  • Using the Command-Line Interface of the Data Guard Broker
  1. Creating a Data Guard Broker Configuration
  • Data Guard Broker: Requirements
  • Data Guard Broker and the SPFILE
  • Data Guard Monitor: Configuration File
  • Data Guard Broker: Log Files
  • Creating a Broker Configuration
  1. Enabling Fast-Start Failover
  • When Does Fast-Start Failover Occur?
  • Installing the Observer Software
  • Fast-Start Failover Prerequisites
  • Configuring Fast-Start Failover
  • Viewing Fast-Start Failover Information
  • Determining the Reason for a Fast-Start Failover
  • Prohibited Operations After Enabling Fast-Start Failover
  • Disabling Fast-Start Failover
  • Disabling Fast-Start Failover Conditions
  • Using the FORCE Option and stopping observer
  1. DG broker activities
  • LogXptmode
  • Enable / disable APPLY
  • Enable / disable TRANSPORT
  • Switch over
  • Failover
  • Re-instate after the failover
  • Change protection modes
  • Disable configuration
  • Drop standby database from configuration
  • Remove configuration
  1. Patching and Upgrading Databases in a Physical DataGuard Configuration
  • Oracle Data Guard Broker Configuration
  • Applying PSU(11.2.0.3.13) patch
  • Normal Upgrade (11.2.0.3 to 11.2.0.4)
  • Rolling Upgrade for Physical Standby Dataguard (11.2.0.3 to 11.2.0.4) – Summary
  • Rolling Upgrade for Physical Standby Dataguard (11.2.0.3 to 11.2.0.4) – Part 1
  • Rolling Upgrade for Physical Standby Dataguard (11.2.0.3 to 11.2.0.4) – Part 2
  • Rolling Upgrade for Physical Standby Dataguard (11.2.0.3 to 11.2.0.4) – Part 3
  1. Creating a Logical Standby Database
  • Benefits of Implementing a Logical Standby Database
  • Logical Standby Database: SQL Apply Architecture
  • SQL Apply Process: Architecture
  • Preparing to Create a Logical Standby Database
  • Unsupported Objects, Data types, PL/SQL objects and DDL’s
  • Ensuring Unique Row Identifiers
  • Creating a Logical Standby Database by Using SQL Commands – overview
  • Creating a Logical Standby Database by Using SQL Commands
  • Securing Your Logical Standby Database
  • Automatic Deletion of Redo Log Files by SQL Apply
  • Managing Remote Archived Log File Retention