Oracle Database 11g: Data Guard Administration Release 2 Training Logo

Oracle Database 11g: Data Guard Administration Release 2 Training

Live Online & Classroom Enterprise Certification Training

Powered By

Oracle Logo

This Database 11g Data Guard Administration training teaches you to use Oracle Data Guard to protect your Oracle database against planned and unplanned downtimes. Learn how it supports production functions like reporting, querying and testing.

ATP_Authorized Logo

Powered By

Oracle Logo

Looking for a private batch ?

REQUEST A CALLBACK

Need help finding the right training?

Your Message

  • Certified Trainer

  • Authorized Courseware

  • Completion Certificate from ATP

  • Enterprise Reporting

  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

What is Data Guard Administration Release 2 Certification Training about?

This Oracle Database 11g: Data Guard Administration Release 2 training helps you develop the skills to use Oracle Data Guard to help protect your Oracle database against planned and unplanned downtimes. Explore how Data Guard standby databases can be used to support production functions such as reporting, querying and testing, while in a standby role.

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

This course explores Data Guard architecture, the configuration of physical and logical standby databases and role transitions. Expert instructors will also help you explore Oracle Data Guard 11g features, including Oracle Active Data Guard and snapshot standby databases.

What are the objectives of Data Guard Administration Release 2 Certification Training ?

  • Create and manage physical and logical standby databases
  • Use Data Guard standby databases to support production functions such as reporting, querying, testing, and performing backups
  • Use Enterprise Manager Grid Control and the Data Guard command-line interface (DGMGRL) to maintain a Data Guard configuration
  • Use Data Guard to achieve a highly available Oracle database

Who is Data Guard Administration Release 2 Certification Training for?

  • Database Administrators
  • Support Engineer
  • Technical Consultant

What are the prerequisites for Data Guard Administration Release 2 Certification Training?

Required Prerequisite

  • Oracle Database 11g: Administration Workshop I Release 2
  • Oracle Database 11g: Administration Workshop II Release 2

Available Training Modes

Live Online Training

32 Hours

Classroom Training

4 Days

Course Outline Expand All

Expand All

  • Oracle Data Guard Architecture
  • Causes of Data Loss
  • Types of Standby Databases (benefits of each type)
  • Performing Role Transitions
  • Data Protection Modes
  • Differentiating Between Standby Databases and Data Guard Broker Configuration
  • Using the Data Guard Broker
  • Creating the Physical Standby Database
  • Preparing the Primary Database
  • Data Guard Monitor Process
  • Benefits of Using the Data Guard Broker
  • Using DGMGRL
  • Comparing Configuration Management With and Without the Broker
  • Data Guard Monitor Configuration Files
  • Oracle Data Guard Broker Configurations
  • Oracle Data Guard Broker Features
  • 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
  • Defining a Data Guard Configuration (overview)
  • Setting up the Broker Configuration Files
  • Viewing the Data Guard Configuration Status
  • Using the Add Standby Database Wizard
  • Editing Standby database properties
  • Using Enterprise Manager Grid Control to Create a Physical Standby Database
  • Verifying a Configuration
  • Using the DGMGRL SHOW CONFIGURATION Command to Monitor the Configuration
  • Using Enterprise Manager Data Guard Metrics
  • Monitoring the Data Guard Configuration by Using Enterprise Manager Grid ControlVerifying the ConfigurationViewing Log File Details
  • Viewing Standby Redo Log Information
  • Monitoring Redo Apply
  • Activating a Snapshot Standby Database: Issues and Cautions
  • Viewing Snapshot Standby Database Information
  • Snapshot Standby Database: Architecture
  • Converting a Physical Standby Database to a Snapshot Standby Database
  • Converting a Snapshot Standby Database to a Physical Standby Database
  • Monitoring Block Change Tracking
  • Creating Fast Incremental Backups
  • Enabling and Disabling Real-Time Query
  • Enabling Block Change Tracking on a Physical Standby Database
  • Using Real-Time Query
  • Ensuring Unique Row Identifiers
  • Preparing to Create a Logical Standby Database
  • Checking for Unsupported Objects , Data Types, and Tables
  • Creating the Logical Standby Using SQL Commands and Grid Control
  • Securing your Logical Standby Database
  • Re-enabling Disabled Databases
  • Performing a Switchover using DGMGRL and Enterprise Manager
  • Preparing for a Switchover
  • Contrast switchover vs. failover
  • Types of Failovers
  • Flashback Through Standby Database Role Transitions
  • Using Flashback Database After Failover
  • Overview of Flashback Database
  • Using Flashback Database Instead of Apply Delay
  • Using Flashback Database and Real Time Apply
  • Configuring Flashback Database
  • Disabling Fast-Start Failover
  • Starting and Stopping the Observer
  • Configuring Automatic Reinstatement of the Primary Database
  • Installing the Observer Software
  • Moving the Observer to a new Host
  • Configuring Fast-Start Failover
  • Initiating Fast-Start Failover from an Application
  • Preventing Clients from Connecting to the Wrong Database
  • Automating Failover for OCI Clients
  • Automating Client Failover in a Data Guard Configuration
  • Configuring JDBC Clients for Failover
  • Understanding Client Connectivity in a Data Guard Configuration
  • Creating Services for the Data Guard Configuration Databases
  • Automating Failover for OLE DB Clients
  • Configuring Daily Incremental Backups
  • Creating the Recovery Catalog
  • Using the RMAN Recovery Catalog in a Data Guard Configuration
  • Registering a Database in the Recovery Catalog
  • Backup and Recovery of a Logical Standby Database
  • Using a Backup to Recover a Data File on the Primary Database
  • Recovering a Data File on the Standby Database
  • Using SQL Apply to Upgrade the Oracle Database
  • Performing a Rolling Upgrade by Using an Existing Logical Standby Database
  • Performing a Rolling Upgrade by Creating a New Logical Standby Database
  • Performing a Rolling Upgrade by Using SQL Apply
  • Upgrading an Oracle Data Guard Broker Configuration
  • Performing a Rolling Upgrade by Using a Physical Standby Database
  • Using Enterprise Manager Data Guard Metrics
  • Viewing Standby Redo Log Information
  • Monitoring the Data Guard Configuration by Using Enterprise Manager Grid ControlVerifying the ConfigurationViewing Log File Details
  • Monitoring Redo Apply
  • Using the DGMGRL SHOW CONFIGURATION Command to Monitor the Configuration
  • Delaying the Application of Redo Data
  • Adjusting the Number of APPLIER and PREPARER processes
  • Compressing Redo Data
  • Optimizing SQL Apply
  • Using Enterprise Manager Grid Control to monitor configuration performance
  • Setting the ReopenSecs and NetTimeout database properties

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

Course Logo

Data Guard Administration Release 2 Certification Training - Certification & Exam

  • SpringPeople is the Authorized Training Partner of Oracle.
  • The training fees is exclusive of exam cost.
  • For any queries; feel free to reach us at oracle@springpeople.com

Reviews