Oracle Data Guard training institute Bangalore| Active Dataguard admin training


11g Data Guard Administration

Oracle Database 11g Release 2: Data Guard Administration  - Premium Course

Oracle Dataguard Training Bangalore

Click here to download the Syllabus 

 

PREMIUM COURSE BENEFITS

 

1.Oracle Certified Expert trainers with 10+ years experience
2.Corporate training quality at affordable cost
3. Premium assistance and support for Training & Certification
4. High end Servers available for Lab practice or Access Lab Online
5. Take home a Software Setup along with you after the course 
6. 100% satisfaction guaranteed
 

What is DataGuard?

Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Data Guard maintains these standby databases as transactionally consistent copies of the production database.

Then, if the production database becomes unavailable because of a planned or an unplanned outage, Data Guard can switch any standby database to the production role, minimizing the downtime associated with the outage. Data Guard can be used with traditional backup, restoration, and cluster techniques to provide a high level of data protection and data availability.

Oracle Dataguard training in Bangalore

What you will learn in this course?

In this course, students learn how to use Oracle Data Guard to help protect their Oracle database against planned and unplanned downtimes. They 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.

The course includes Data Guard architecture, the configuration of physical and logical standby databases, and role transitions. Oracle Data Guard 11g features, including Oracle Active Data Guard and snapshot standby databases are outlined. In addition, management of a Data Guard configuration and troubleshooting are discussed.

Learn to:

Offload business processing needs to another system
Offload backup needs to another system
Build highly available systems

Audience

Database Administrators
Support Engineers 
Technical Consultants

Prerequisites

Oracle Enterprise Manager 10g Grid Control
Oracle Database 11g: Administration Workshop II DBA Release 2
Oracle Database 11g: Administration Workshop I DBA Release 2

Duration : 6 days (18 hours)

Course Objectives

Use Data Guard standby databases to support production functions such as reporting, querying, and testing.
Create and manage physical standby databases.
Use Data Guard to achieve a highly available Oracle database.

Course Topics

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: Architecture (Overview)
Primary Database Processes
Standby Database Processes
Data Protection Modes
Data Guard Operational Requirements: Hardware and Operating System
Benefits of Implementing Oracle Data Guard.

Creating a Physical Standby

Steps to Create a Physical Standby Database
Preparing the Primary Database
FORCE LOGGING Mode
Configuring Standby Redo Logs
Creating Standby Redo Logs
Using SQL to Create Standby Redo Logs
Viewing Standby Redo Log Information
Setting Initialization Parameters on the Primary and standby Database
Redo Transport
Creating the Physical Standby Database
Enabling Real-Time Apply
Starting Redo Apply
Managing standby database. 

Creating a Snapshot Standby Database

Snapshot Standby Database: Architecture
Converting a Physical Standby Database to a Snapshot Standby Database
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

Configuring Data Protection Modes

Data Protection Modes and Redo Transport Modes
Data Protection Modes
Maximum Protection Mode
Maximum Availability Mode
Maximum Performance Mode
Comparing Data Protection Modes
Setting the Data Protection Mode

Performing Role Transitions

Role Management Services
Role Transitions: Switchover and Failover
Switchover
Performing a Switchover
Performing a Failover to a Physical Standby Database

 

Click here to download the Syllabus