facebook twitter youtube facebook facebook facebook

E-Mail : info@askmlabs.com

Phone : +1.215.353.8306

Latest Post

ORACLE 12C DATAGUARD ADMINISTRATION TRAINING

Written By askMLabs on Saturday, January 18, 2014 | 8:01 AM


In this course, you will learn how to use Oracle Data Guard to help protect your Oracle database against planned and unplanned downtimes. You'll also learn how Data Guard standby databases can be used to support production functions such as reporting, querying, and testing, while in a standby role.

Current Training Schedule : 
Training Format
Online Training
Fee
USD 300 /  INR 15,000/-
Duration
4 weeks ( Sat & Sun ) - 4 Hr Session
Date
DD-MON-YYYY
Time
HH:MI to HH:MI
Instructor
Srikrishna Murthy Annam

Services :
Training Format
Self Study Material with Lab practice examples
Fee
USD xxx /  INR x,xxx/-
Prepared By
Srikrishna Murthy Annam

Only Lab : 
Practice Lab
24/7 practice lab access from our data center
Fee
USD xxx /  INR x,xxx/-
Guided  By
Srikrishna Murthy Annam

Course Content : 
In this course, you will learn how to use Oracle Data Guard to help protect your Oracle database against planned and unplanned downtimes. You'll also learn how Data Guard standby databases can be used to support production functions such as reporting, querying, and testing, while in a standby role.

You will learn about Data Guard architecture, the configuration of physical and logical standby databases, role transitions, and Oracle Data Guard 11g features, including Oracle Active Data Guard and snapshot standby databases. You will also learn about managing a Data Guard configuration and troubleshooting.

  1. 1. Introduction to Oracle Data Guard
    1. Causes of Data Loss
    2. Oracle Data Guard Architecture
    3. Types of Standby Databases and Benefits of Each Type
    4. Using the Data Guard Broker
    5. Differentiating Standby Databases and Data Guard Broker Configuration
    6. Data Protection Modes
    7. Performing Role Transitions
  2. 2. Creating a Physical Standby Database by Using SQL and RMAN Commands
    1. Preparing the Primary Database
    2. Creating the Physical Standby Database
  1. 3. Oracle Data Guard Broker
    1. Oracle Data Guard Broker Features
    2. Oracle Data Guard Broker Configurations
    3. Data Guard Monitor Process
    4. Data Guard Monitor Configuration Files
    5. Benefits of Using the Data Guard Broker
    6. Comparing Configuration Management With and Without the Broker
    7. Using DGMGRL
  2. 4. Creating a Data Guard Broker Configuration
    1. Data Guard Configuration
    2. Setting up the Broker Configuration Files
    3. Setting the DG_BROKER_START Initialization Parameter to TRUE to Start the Data Guard Broker
    4. Creating the Broker Configuration
    5. Adding the Standby Database to the Configuration
  3. 5. Creating a Physical Standby Database by Using Enterprise Manager Grid Control
    1. Using Enterprise Manager Grid Control to Create a Physical Standby Database
    2. Using the Add Standby Database Wizard
    3. Verifying a Configuration
    4. Editing Standby Database Properties
    5. Viewing the Data Guard Configuration Status
  4. 6. Creating a Logical Standby Database
    1. Monitoring the Data Guard Configuration by Using Enterprise Manager Grid Control
    2. Verifying the Configuration
    3. Viewing Log File Details
    4. Using Enterprise Manager Data Guard Metrics
    5. Using the DGMGRL Show Configuration Command to Monitor the Configuration
    6. Viewing Standby Redo Log Information
    7. Monitoring Redo Apply
  5. 7. Creating and Managing a Snapshot Standby Database
    1. Snapshot Standby Database: Architecture
    2. Converting a Physical Standby Database to a Snapshot Standby Database
    3. Activating a Snapshot Standby Database: Issues and Cautions
    4. Viewing Snapshot Standby Database Information
    5. Converting a Snapshot Standby Database to a Physical Standby Database
  6. 8. Using Oracle Active Data Guard
    1. Using Real-Time Query
    2. Enabling and Disabling Real-Time Query
    3. Enabling Block Change Tracking on a Physical Standby Database
    4. Creating Fast Incremental Backups
    5. Monitoring Block Change Tracking
  7. 9. Configuring Data Protection Modes
    1. Preparing to Create a Logical Standby Database
    2. Checking for Unsupported Objects, Data Types, and Tables
    3. Ensuring Unique Row Identifiers
    4. Creating the Logical Standby Using SQL Commands and Grid Control
    5. Securing your Logical Standby Database
  8. 10. Performing Role Transitions
    1. Switchover vs. Failover
    2. Preparing for a Switchover
    3. Performing a Switchover using DGMGRL and Enterprise Manager
    4. Types of Failovers
    5. Re-enabling Disabled Databases
  9. 11. Using Flashback Database in a Data Guard Configuration
    1. Flashback Database
    2. Configuring Flashback Database
    3. Using Flashback Database Instead of Apply Delay
    4. Using Flashback Database and Real Time Apply
    5. Flashback Through Standby Database Role Transitions
    6. Using Flashback Database After Failover
  10. 12. Enabling Fast-Start Failover
    1. Installing the Observer Software
    2. Configuring Fast-Start Failover
    3. Configuring Automatic Reinstatement of the Primary Database
    4. Initiating Fast-Start Failover from an Application
    5. Disabling Fast-Start Failover
    6. Starting and Stopping the Observer
    7. Moving the Observer to a New Host
  11. 13. Managing Client Connectivity
    1. Client Connectivity in a Data Guard Configuration
    2. Preventing Clients from Connecting to the Wrong Database
    3. Creating Services for the Data Guard Configuration Databases
    4. Automating Client Failover in a Data Guard Configuration
    5. Automating Failover for OCI Clients
    6. Automating Failover for OLE DB Clients
    7. Configuring JDBC Clients for Failover
  12. 14. Performing Backup and Recovery Considerations in an Oracle Data Guard Configuration
    1. Backup and Recovery of a Logical Standby Database
    2. Using the RMAN Recovery Catalog in a Data Guard Configuration
    3. Creating the Recovery Catalog
    4. Registering a Database in the Recovery Catalog
    5. Configuring Daily Incremental Backups
    6. Using a Backup to Recover a Data File on the Primary Database
    7. Recovering a Data File on the Standby Database
  13. 15. Patching and Upgrading Databases in a Data Guard Configuration
    1. Upgrading an Oracle Data Guard Broker Configuration
    2. Using SQL Apply to Upgrade the Oracle Database
    3. Performing a Rolling Upgrade by Using SQL Apply
    4. Performing a Rolling Upgrade by Using an Existing Logical Standby Database
    5. Performing a Rolling Upgrade by Creating a New Logical Standby Database
    6. Performing a Rolling Upgrade by Using a Physical Standby Database
  14. 16. Monitoring a Data Guard Configuration
    1. Monitoring the Data Guard Configuration by Using Enterprise Manager Grid Control
    2. Verifying the Configuration
    3. Viewing Log File Details
    4. Using Enterprise Manager Data Guard Metrics
    5. Using the DGMGRL SHOW CONFIGURATION Command to Monitor the Configuration
    6. Viewing Standby Redo Log Information
    7. Monitoring Redo Apply
  15. 17. Optimizing a Data Guard Configuration
    1. Using Enterprise Manager Grid Control to Monitor Configuration Performance
    2. Setting the ReopenSecs and NetTimeout Database Properties
    3. Compressing Redo Data
    4. Delaying the Application of Redo Data
    5. Optimizing SQL Apply
    6. Adjusting the Number of APPLIER and PREPARER Processes

Who Can Attend :
  1. Technical Consultant
  2. Database Administrators
  3. Support Engineer

Course Objective : 
  1. Create and manage physical and logical standby databases
  2. Use Data Guard standby databases to support production functions such as reporting, querying, testing, and performing backups
  3. Use Enterprise Manager Grid Control and the Data Guard command-line interface (DGMGRL) to maintain a Data Guard configuration
  4. Use Data Guard to achieve a highly available Oracle database
  5. Preparing a Primary Database for a Data Guard Configuration
  6. Creating a Snapshot Standby Database
  7. Monitoring a Standby Database Configuration
  8. Managing a Data Guard Configuration
  9. Troubleshooting Standby Database Configurations
  10. Tuning a Standby Database
  11. Backing up and Recovering a Data Guard Configuration
  12. Using Flashback in a Data Guard Configuration
  13. Using the Data Guard Broker
Why To Choose Us : 
  1. Free Plug & Play virtual Machine 11g Data Guard
  2. Handouts for each topics
  3. Lab facility from anywhere* ( From our cloud servers )
  4. Guidance from expert trainers
  5. Help to setup database in local machines
  6. 100% Student Satisfaction
  7. Direct Interaction with Faculty at office
  8. Guidance for Interview Preparation
  9. Guidance for certification
Fee Details : 
  1. Single payment 10% discount
  2. Two installments ( 50% before starting and 50% after 2 weeks )  -- 5% discount on second payment
  3. Three installments (20% before starting + 50% before 3rd week + 30% before 4th week)
  4. Refer a friend and get 20% discount on course fee
  5. Good negotiable price for group of people as a batch
 
Support :
Copyright © 2013. askMLabs - All Rights Reserved
Proudly powered by Blogger