[thim-heading title=”Oracle Database 12c: Dataguard Administration” line=””]

Upon Completion Of this Course you will have good understanding on:

  • Understand the important components of Business continuity
  • Setting up Physical Standby in Dataguard
  • Setting up Logical Standby in Dataguard
  • Minimal Downtime upgrade
  • Dataguard Broker
  • Offloading Backups and Reporting to less loaded database

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)
  • Primary Database Processes

Networking for Oracle Data Guard

  • Networking Overview
  • ora Configuration
  • Statics vs. Dynamic Registration
  • Static Entries for Database Duplication and SQL Maintenence
  • Static Entries for Broker Operations
  • Oracle Network Configuration Tuning
  • ora Configuration

Creating a Physical Standby Database by Using SQL and RMAN Commands

  • Steps to Create a Physical Standby Database
  • Preparing the Primary Database
  • Configuring Standby Redo Logs
  • Creating Standby Redo Logs
  • Using SQL to Create Standby Redo Logs
  • Viewing Standby Redo Log Information
  • Setting Initialization Parameters on the Primary Database to Control Redo Transport

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


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
  • Defining the Broker Configuration and the Primary Database Profile
  • Adding a Standby Database to the Configuration
  • Enabling the Configuration

Creating a Physical Standby Database by Using Enterprise Manager Cloud Control

  • Using Oracle Enterprise Manager to Create a Broker Configuration
  • Creating a Configuration
  • Creating a New Configuration
  • Adding a Standby Database to an Existing Configuration
  • Using the Add Standby Database Wizard
  • Standby Database Creation: Processing
  • Standby Database Creation: Progress
  • Verifying a Data Guard Configuration

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
  • Unsupported Data Types
  • Checking for Unsupported Tables
  • Checking for Tables with Unsupported Data Types

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
  • 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
  • Checking the Standby’s Open Mode
  • Understanding Lag in an Active Data Guard Configuration
  • Monitoring Apply Lag: V$DATAGUARD_STATS
  • Monitoring Apply Lag: V$STANDBY_EVENT_HISTOGRAM
  • Setting a Predetermined Service Level for Currency of Standby Queries
  • Configuring Zero Lag Between the Primary and Standby Databases

Configuring Data Protection Modes

  • Data Protection Modes and Redo Transport Modes
  • Maximum Protection Mode
  • Maximum Availability Mode
  • Maximum Performance Mode
  • Comparing Data Protection Modes
  • Setting the Data Protection Mode by Using DGMGRL
  • Setting the Data Protection Mode

Performing Role Transitions

  • Role Management Services
  • Role Transitions: Switchover and Failover
  • Switchover
  • Preparing for a Switchover
  • Performing a Switchover by Using DGMGRL
  • Performing a Switchover by Using Enterprise Manager
  • Considerations When Performing a Switchover to a Logical Standby Database
  • Situations That Prevent a Switchover

Using Flashback Database in a Data Guard Configuration

  • Using Flashback Database in a Data Guard Configuration
  • Overview of Flashback Database
  • Configuring Flashback Database
  • Configuring Flashback Database by Using Enterprise Manager
  • Using Flashback Database Instead of Apply Delay
  • Using Flashback Database and Real-Time Apply
  • Using Flashback Database After RESETLOGS
  • Flashback Through Standby Database Role Transitions


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
  • Setting the Lag-Time Limit
  • Configuring the Primary Database to Shut Down Automatically
  • Automatic Reinstatement After Fast-Start Failover

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
  • Configuring Role-Based Services
  • Adding Standby Databases to Oracle Restart Configuration

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
  • Backup and Recovery of a Logical Standby Database
  • Using the RMAN Recovery Catalog in a Data Guard Configuration
  • Creating the Recovery Catalog
  • Registering a Database in the Recovery Catalog
  • Setting Persistent Configuration Settings

Patching and Upgrading Databases in a Data Guard Configuration

  • Upgrading an Oracle Data Guard Broker Configuration
  • Upgrading Oracle Database in a Data Guard Configuration with a Physical Standby Database
  • Upgrading Oracle Database in a Data Guard Configuration with a Logical Standby Database
  • Using DBMS_ROLLING to Upgrade the Oracle Database
  • Requirements for Using DBMS_ROLLING to Perform a Rolling Upgrade
  • Leading Group Databases and Leading Group Master
  • Trailing Group Databases and Trailing Group Master
  • Performing a Rolling Upgrade by Using DBMS_ROLLING

Monitoring a Data Guard Broker Configuration

  • Monitoring the Data Guard Configuration by Using Enterprise Manager Cloud Control
  • Viewing the Data Guard Configuration Status
  • Monitoring Data Guard Performance
  • Viewing Log File Details
  • Enterprise Manager Metrics and Alerts
  • Data Guard Metrics
  • Managing Data Guard Metrics
  • Viewing Metric Value History

Optimizing a Data Guard Configuration

  • Monitoring Configuration Performance by Using Enterprise Manager Cloud Control
  • Optimizing Redo Transport Services
  • Setting the ReopenSecs Database Property
  • Setting the NetTimeout Database Property
  • Optimizing Redo Transmission by Setting MaxConnections
  • Setting the MaxConnections Database Property
  • Compressing Redo Data by Setting the RedoCompression Property
  • Delaying the Application of Redo

Duration of the course : 40 hrs

Please note :

  • This is the approximate duration .We love more discussion with students and  depending on the interaction , the duration may increase
  • This is the time for the class delivery . Please reserve more  time for your practice

Course Prerequisite

  • Good Understanding Oracle Database Architecture
  • Good Understanding on Oracle Backup & Recovery
  • Good Understanding on Linux OS and Commands

Recommended Prerequisite Courses

  • Oracle 12c Database Administration
  • Oracle 12c RMAN
  • Linux Operating System For DBAs

This Training is an instructor led training . Along with training we will give the following study materials ,which are provided via our elearning portal

  •  Video Tutorials
  • Student guide
  • PowerPoint Presentations
  • We provide individual lab servers for our students .
  • They students can access the lab for 2 months even after completion of the class
  • We also help students in setting up their laptop / desktop for study purpose
[thim-list-events layout=”layout-2″ text_link=”View All Events”]