Oracle Data Guard Online Training

Oracle Data Guard Online Training

Enroll for Online Oracle Data Guard Training by Experts, Learn Oracle Data Guard Certification Training with Course Material | Tutorial Videos | Attend Demo for free & you will find Spiritsofts is the best institute within reasonable fee.

Spiritsofts is the best Training Institutes to expand your skills and knowledge. We Provides the best learning Environment. Obtain all the training by our expert professionals which is having working experience from Top IT companies.

The Training in is every thing we explained based on real time scenarios, it works which we do in companies.

Experts Training sessions will absolutely help you to get in-depth knowledge on the subject.

Key FeaturesCourse Content FAQs
  • 30 hours of Instructor Training Classes
  •  Lifetime Access to Recorded Sessions
  • Real World use cases and Scenarios
  • 24/7 Support  Lifetime
  • Practical Approach
  • Expert & Certified Trainers

Introduction to Oracle Data Guard

  • 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

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 Physical Standby Database by Using Enterprise Manager Grid Control

  • Using Enterprise Manager Grid Control to Create a Physical Standby Database
  • Using the Add Standby Database Wizard
  • Verifying a Configuration
  • Editing Standby database properties
  • Viewing the Data Guard Configuration Status

Creating a Logical Standby Database

  • Monitoring the Data Guard Configuration by Using Enterprise Manager Grid ControlVerifying the ConfigurationViewing Log File Details
  • 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

Oracle Business Process Management (BPM)

  • 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

Managing Client Connectivity

  • Understanding Client Connectivity in a Data Guard Configuration
  • Preventing Clients from Connecting to the Wrong Database
  • Creating Services for the Data Guard Configuration Databases
  • Automating Client Failover in a Data Guard Configuration
  • Automating Failover for OCI Clients
  • Automating Failover for OLE DB Clients
  • Configuring JDBC Clients for Failover

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

Patching and Upgrading Databases in a Data Guard Configuration

  • Upgrading an Oracle Data Guard Broker Configuration
  • Using SQL Apply to Upgrade the Oracle Database
  • Performing a Rolling Upgrade by Using SQL Apply
  • 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 a Physical Standby Database

Monitoring a Data Guard Configuration

  • Monitoring the Data Guard Configuration by Using Enterprise Manager Grid ControlVerifying the ConfigurationViewing Log File Details
  • Using Enterprise Manager Data Guard Metrics
  • Using the DGMGRL SHOW CONFIGURATION Command to Monitor the Configuration
  • Viewing Standby Redo Log Information
  • Monitoring Redo Apply

Optimizing a Data Guard Configuration

  • Using Enterprise Manager Grid Control to monitor configuration performance
  • Setting the ReopenSecs and NetTimeout database properties
  • Compressing Redo Data
  • Delaying the Application of Redo Data
  • Optimizing SQL Apply
  • Adjusting the Number of APPLIER and PREPARER processes
Who Are The Trainers?

Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Spiritsofts verifies their technical background and expertise.

What If I Miss A Class?

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

How Will I Execute The Practical?

Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

If I Cancel My Enrollment, Will I Get The Refund?

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

Will I Be Working On A Project?

The Training itself is Real-time Project Oriented.

Are These Classes Conducted Via Live Online Streaming?

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

Is There Any Offer / Discount I Can Avail?

There are some Group discounts available if the participants are more than 2.

Who Are Our Customers?

As we are one of the leading providers of Live Instructor LED training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, Sydney, France, Finland, Sweden, Spain, Russia Moscow, Denmark, London, England, South Africa, Switzerland, Kenya, Philippines, Japan, Indonesia, Pakistan, Saudi Arabia,  Qatar, Kuwait, Germany, Frankfurt Berlin Munich, Poland, Belarus, Belgium Brussels Netherlands Amsterdam, India and other parts of the world.

We are located in USA. Offering Online Training in Cities like New York, New jersey, Dallas, Seattle, Baltimore, Tempe, Chandler, Scottsdale, Peoria, Honolulu, Columbus, Raleigh, Nashville, Plano, Toronto, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Houston, Minneapolis, Los Angeles, San Francisco, San Jose, San Diego, Washington DC, Chicago, Philadelphia, St. Louis, Edison, Jacksonville, Towson, Salt Lake City, Davidson, Murfreesboro, Atlanta, Alexandria, Sunnyvale, Santa Clara, Carlsbad, San Marcos, Franklin, Tacoma, California, Bellevue, Austin, Charlotte, Garland, Raleigh-Cary, Boston, Orlando, Fort Lauderdale, Miami, Gilbert.

Hyderabad (Ameerpet), Kukatpally, Vizag, Nellore, Lucknow, Coimbatore, Marathahalli, Electronic city , Silk board, Kakinada, Goa, Vijayawada, Bangalore, Noida, Chennai, Kolkata, Pune, Whitefield, Mumbai, Delhi NCR, Dubai, Doha, Melbourne, Brisbane, Perth, Wellington, Leeds, Manchester, Liverpool, Ireland Dublin, Oxford, Cambridge, Brighton, Cardiff, Bristol, Lithuania,  Latvia, Italy, San Marion, China Beijing, Auckland etc…







Ready to Begin?

Find subjects you're passionate about by browsing our online course categories.Start learning with top courses Built With Industry Experts