Oracle Data Guard Training

(3) 3 Ratings

Course Schedule

30

JUL

Mon - Sat

07:30 PM - 10:00 PM ( IST )

06

AUG

Mon - Fri

11:00 AM - 02:00 PM ( IST )

11

AUG

Sat - Sun

05:30 AM - 06:30 AM ( IST )


Total Learners

877 Learners


LMS Access

365 days

Course duration

30 days


Support

24/7 support

Can't find convenient schedule?

Our experts can help you find a batch that meets your needs

The Instructor for this course is from one of the Big5 Companies in the world.

Drop us a Query

I agree to the Training T&C

Modes of Training

Corporate Training

Live, Classroom Or Self Paced Training

Online Classroom

Attend our Instructor Led Online Virtual Classroom

Self Paced Training

Comprehensive Recorded Videos by Experts to learn at your own pace

Course Features

Live Instructor-led Classes

This isn't canned learning. Its dynamic, its interactive, its effective

Expert Educators

Only the best or they're out. We are constantly evaluating our trainers

24&7 Support

We never sleep. Need something answered at 3 am? No Problem

Flexible Schedule

You don't learn as per our calendar. We work according to yours

☰ Details

Course Curriculum

Introduction to Oracle Data Guard

  • 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)
  • Physical Standby Database: Redo Apply Architecture
  • Logical Standby Database: SQL Apply Architecture
  • Data Protection Modes
  • Data Guard Operational Requirements: Hardware and Operating System
  • Benefits of Implementing Oracle Data Guard.

Creating a Physical Standby Database by using SQL and RMAN Commands

  • Steps to Create a Physical Standby Database
  • Preparing the Primary Database
  • FORCE LOGGING Mode
  • Configuring Standby Redo Logs
  • Setting Initialization Parameters on the Primary Database
  • Creating an Initialization Parameter File for the Physical Standby Database
  • Creating the Physical Standby Database
  • Enabling Real-Time Apply.

Oracle Data Guard Broker: Overview

  • Oracle Data Guard Broker: Features
  • Data Guard Broker: Components
  • Data Guard Broker: Configurations
  • Data Guard Broker: Architecture
  • Data Guard Monitor: DMON Process
  • Benefits of Using the Data Guard Broker
  • Using the Command-Line Interface of the Data Guard Broker.

Creating a Data Guard Broker Configuration

  • Data Guard Broker: Requirements
  • Data Guard Monitor: Configuration File
  • Creating a Broker Configuration
  • Defining the Broker Configuration and the Primary Database Profile
  • Adding a Standby Database to the Configuration
  • Enabling the Configuration
  • Disabling Broker Management of the Configuration or Standby Database.

Creating a Logical Standby DataBase

  • Benefits of Implementing a Logical Standby Database
  • Logical Standby Database: SQL Apply Architecture
  • SQL Apply Process: Architecture
  • Creating a Logical Standby Database by Using SQL Commands
  • Adding a Logical Standby Database to a Data Guard Broker Configuration.

Creating and Managing a snapshot Standby Database

  • 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
  • Viewing Snapshot Standby Database Information
  • Using DGMGRL to View Snapshot Standby Database Information
  • Converting a Snapshot Standby Database to a Physical Standby Database.

Using Oracle Active Data Guard

  • Oracle Active Data Guard
  • Using Real-Time Query
  • Understanding Lag in an Active Data Guard Configuration
  • Enabling Block Change Tracking on a Physical Standby Database
  • Creating Fast Incremental Backups.

Configuring Data Protection Modes

  • Data Protection Modes and Redo Transport Modes
  • Data Protection Modes
  • Maximum Protection Mode
  • Maximum Availability Mode
  • Maximum Performance Mode
  • Setting the Data Protection Mode by Using DGMGRL.

Performing Role Transitions

  • Role Management Services
  • Role Transitions: Switchover and Failover
  • Preparing for a Switchover
  • Performing a Switchover by Using DGMGRL
  • Types of Failovers
  • Performing a Manual Failover by Using DGMGRL.

Course Description

What are the Course Objectives of this Training?

After attending this course, delegates will be able to:

  • Plan, implement, manage and troubleshoot Oracle Data Guard standby database configurations.

Who are the Target Audience for this Course?

  • The Oracle Database Data Guard course is designed for database administrators and technical support staff who are required to plan and implement Oracle Data Guard configurations. 
  • It is suitable for 11g and 12c users. 

What are the Pre-requisites for this Training Course?

  • A working knowledge of Oracle Database Administration is required. This course is run in a Linux environment and a working knowledge of the UNIX operating system is therefore highly recommended. These skills can be obtained by attending the pre-requisite courses.
  • Linux Introduction
  • Oracle Database 11g Release 2 DBA Part I and II
  • Oracle Database 12C Administration, Backup and Recovery with RMAN, and RAC and Grid Infrastructure Administration.

FAQ

Do you have self paced training?

Yes, we offer self paced training

How do you provide training?

We offer three different modes of training. Instructor Led Live Training, Self Paced Training and Corporate Training

Do you offer any discounts?

Yes we offer discounts for group of 3 plus people.

Can I choose timings that suits my schedule?

Yes we are the only company where we work with students and offer flexible timings which fits your schedule

Who are the Instructors?

All our instructors are from MNC companies who have real time experience of more than 10 years.

Can I attend a demo session before joining?

Yes we offer a free demo session with the instructors. The trainer will answer all your queries and share the course agenda.

Course Reviews

Siva

Had a great Experience in Learning with LTB. I have enrolled the Oracle Data Guard Course in LTB. Instructor has a Real-Time experience in the Industry. This Course helped me a lot in my Carrer. Thank you.

Sruthi

It is a great experience to learn online courses from Live Trainings Bangalore. The sessions are very professional. I had enrolled for Oracle Data Guard course. It helped me a lot professionally at my work place. I am very glad for choosing LTB as my learning partner. Thank you.

Mahathi

I completed my Data Guard certification in LTB. They teach us in friendly manner, and good environment to learn more. And now i have gained more confident to get placement in MNC companies. Thanks to my trainer and LTB also.