- Causes of Data Loss
- Oracle Data Guard Architecture
- Types of Standby Databases (benefits of each type)
- Using the Data Guard Broker
- Differentiating Between Standby Databases and Data Guard Broker Configuration
- Data Protection Modes
- Performing Role Transitions
Quick Facts
particular | details | ||||
---|---|---|---|---|---|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Frequency of Classes
Weekdays, Weekends
|
Course and certificate fees
certificate availability
Yes
certificate providing authority
Mindmajix Technologies
The syllabus
Introduction to Oracle Data Guard
Creating a Physical Standby Database by Using SQL and RMAN Commands
- Preparing the Primary Database
- Creating the Physical Standby Database
Oracle Data Guard Broker: Overview
- Oracle Data Guard Broker Features
- Oracle Data Guard Broker Configurations
- Data Guard Monitor Process
- Data Guard Monitor Configuration Files
- Benefits of Using the Data Guard Broker
- Comparing Configuration Management With and Without the Broker
- Using DGMGRL
Creating a Data Guard Broker Configuration
- Defining a Data Guard Configuration (overview)
- Setting up the Broker Configuration Files
- Setting the DG_BROKER_START Initialization Parameter to TRUE to start the Data Guard Broker
- Creating the Broker Configuration
- Adding the Standby Database to the Configuration
Creating a Logical Standby Database
- Using Enterprise Manager Data Guard Metrics
- Using the DGMGRL SHOW CONFIGURATION Command to Monitor the Configuration
- Viewing Standby Redo Log Information
- Monitoring Redo Apply
Creating and Managing a Snapshot Standby Database
- Snapshot Standby Database: Architecture
- Converting a Physical Standby Database to a Snapshot Standby Database
- Activating a Snapshot Standby Database: Issues and Cautions
- Viewing Snapshot Standby Database Information
- Converting a Snapshot Standby Database to a Physical Standby Database
Using Oracle Active Data Guard
- Using Real-Time Query
- Enabling and Disabling Real-Time Query
- Enabling Block Change Tracking on a Physical Standby Database
- Creating Fast Incremental Backups
- Monitoring Block Change Tracking
Configuring Data Protection Modes
- Preparing to Create a Logical Standby Database
- Checking for Unsupported Objects, Data Types, and Tables
- Ensuring Unique Row Identifiers
- Creating the Logical Standby Using SQL Commands and Grid Control
- Securing your Logical Standby Database
Performing Role Transitions
- Contrast switchover vs. failover
- Preparing for a Switchover
- Performing a Switchover using DGMGRL and Enterprise Manager
- Types of Failovers
- Re-enabling Disabled Databases
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
- Flashback Through Standby Database Role Transitions
- Using Flashback Database After Failover
Enabling Fast-Start Failover
- Installing the Observer Software
- Configuring Fast-Start Failover
- Configuring Automatic Reinstatement of the Primary Database
- Initiating Fast-Start Failover from an Application
- Disabling Fast-Start Failover
- Starting and Stopping the Observer
- Moving the Observer to a new Host
Performing Backup and Recovery Considerations in an Oracle Data Guard Configuration
- 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
- Configuring Daily Incremental Backups
- Using a Backup to Recover a Data File on the Primary Database
- Recovering a Data File on the Standby Database
Monitoring a Data Guard Configuration
- Using Enterprise Manager Data Guard Metrics
- Using the DGMGRL SHOW CONFIGURATION Command to Monitor the Configuration
- Viewing Standby Redo Log Information
- Monitoring Redo Apply
Articles
Popular Articles
prev
next