Data Guard Training

ROICIANS

Course Information

Level	Advance
Batch Availability	Weekdays, Weekend
Mode of Class	Classroom, Online
Duration	30 hours

Key Features

Hands-on Learning Program

Get trained from working professional

Get trained as per market Trend

work on live projects

Training on all latest tools and skill

Continuous Interview preparation

Complete job assistance (Canada only)

Mock interview session from working QA professionals

Course Overview

This Course is designed by keeping in mind that how important it is to keep database available for use. Data Guard is need of an hour for any database management. You will get to work on Live scenarios with real time data.

Candidate must have working knowledge of all modules of Oracle i.e SQL, ADMIN I and ADMIN II
One must be working or has worked as Database Administrator

Anyone who wants to enhance their oracle knowledge
Anyone who wants to work and manage complex and multiple databases.
Anyone who wants to manages multiple clones of databases
Anyone who wants to upgrade themselves

To keep data available this is must
This is need of an hour , almost all DBA jobs asks for it
Almost all jobs asks for data guard
High salary and job scope

Learn on various Operating Systems: We understand that company might work on different platforms , so we make sure we train students on all different Operating system i.e Windows and Linux

Learn by Implementing: One can learn more when they implement the scenarios practically, so our professionals will make sure that all the practical implementation is done by you

Work on latest version of Databases: We train our students on database version which is not obsolete or may be which is not in production.

Interview Preparation from Experts: If you are looking to crack any interview, then we can hear you. Our experts prepare you for latest interview trends and will conduct immense number of interview till the time you are not ready for market

COURSE CURRICULUM

Introduction to Oracle Data Guard

Software’s that we use
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)
Primary Database Processes
Standby Database Processes
Physical Standby Database: Redo Apply Architecture
Logical Standby Database: SQL Apply Architecture
Automatic Gap Detection and Resolution
Data Protection Modes
Data Guard Operational Requirements: Hardware and Operating System
Data Guard Operational Requirements: Oracle Database Software
Benefits of Implementing Oracle Data Guard

Physical Standby Dataguard Installation

Install OS and Oracle software only
Clone OS to Standby server and modify settings
Install database on Primary database server.
Prepare the primary database.
Set parameters on the physical standby database.
Configure Oracle Net Services.
Start the standby database instance.
Execute the DUPLICATE TARGET DATABASE FOR STANDBY RMAN command.
Start the transport and application of redo.
Physical Standby dataguard Health check

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
Snapshot Standby Database: Target Restrictions
Viewing 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
Checking the Standby’s Open Mode
Setup active dataguard – REAL TIME APPLY
Understanding Lag in an Active Data Guard Configuration
Monitoring Apply Lag: V$DATAGUARD_STATS
Monitoring Apply Lag: V$STANDBY_EVENT_HISTOGRAM
Configuring Zero Lag Between the Primary and Standby Databases
Setting STANDBY_MAX_DATA_DELAY by Using an AFTER LOGON Trigger
Enabling Block Change Tracking on a Physical Standby Database
Creating Fast Incremental Backups
Monitoring Block Change Tracking

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
Changing Protection Modes

Performing Role Transitions

Role Management Services
Role Transitions: Switchover and Failover
Switchover
Switchover: Before
Switchover: After
Preparing for a Switchover
Performing a Switchover
Situations That Prevent a Switchover
Failover
Types of Failovers
Failover Considerations
Performing a Manual Failover
Re-enabling Disabled Databases

Backup and Recovery Considerations in an Oracle Data Guard Configuration

Using RMAN to Back Up and Restore Files in a Data Guard Configuration
Offloading Backups to a Physical Standby
Restrictions and Usage Notes
Using the RMAN Recovery Catalog in a Data Guard Configuration
Setting Persistent Configuration Settings
Setting RMAN Persistent Configuration Parameters on the Primary Database
Setting RMAN Persistent Configuration Parameters on the Physical Standby Database
Configuring Daily Incremental Backups
Recovering from Loss of a Data File on the Primary Database
Using a Backup to Recover a Data File on the Primary Database
Using a Physical Standby Database Data File to Recover a Data File on the Primary Database
Recovering a Data File on the Standby Database
Enhancements to Block Media Recovery
Executing the RECOVER BLOCK Command
Excluding the Standby Database