Contact Premier Online Trainings Today
Premier Online Trainings

Oracle Data Guard

  • Home
  • Oracle Data Guard
Courses Overview
Premier Online Trainings Institute provides best Oracle Data Guard training in Hyderabad, Banglore by our Highly Professional certified trainers.

Premier Online training is the best institute to expand your knowledge and skills in Oracle Data Guard. Data Guard Administration training helps you develop the skills to use Oracle Data Guard to help protect your Oracle database against planned and unplanned downtime. Explore how Data Guard standby databases can be used to support production functions such as reporting, querying and testing, while in a standby role.

* We also provide Online Training for Normal Track, Fast Track and Weekend Batches
Course Curriculum
  • 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 Overview
  • Listener.ora Configuration
  • Statics vs. Dynamic Registration
  • Static Entries for Database Duplication and SQL Maintenence
  • Static Entries for Broker Operations
  • Oracle Network Configuration Tuning
  • Tnsnames.ora Configuration
  • Steps to Create a Physical Standby Database
  • Preparing the Primary Database
  • FORCE LOGGING Mode
  • 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: 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: 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
  • 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
  • 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
  • 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
  • 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
  • Role Management Services
  • Role Transitions: Switchover and Failover
  • Switchover
  • Preparing for a Switchover
  • Performing a Switchover by Using DGMGRL
  • Considerations When Performing a Switchover to a Logical Standby Database
  • Situations That Prevent a Switchover
  • Using Flashback Database in a Data Guard Configuration
  • Overview of Flashback Database
  • Configuring Flashback Database
  • 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
  • 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
  • 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
  • Viewing the Data Guard Configuration Status
  • Monitoring Data Guard Performance
  • Viewing Log File Details
  • Data Guard Metrics
  • Managing Data Guard Metrics
  • Viewing Metric Value History
  • Oracle Data guard Patching