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

Managing Client Connectivity

Understanding Client Connectivity in a Data Guard Configuration
Understanding Client Connectivity: Using Local Naming
Preventing Clients from Connecting to the Wrong Database
Managing Services
Understanding Client Connectivity: Using a Database Service
Creating Services for the Data Guard Configuration Databases
Connecting Clients to the Correct Database
Creating the AFTER STARTUP Trigger
Configuring Service Names in the tnsnames.ora File
Automatic Failover of Applications to a New Primary Database
Automating Failover for OCI Clients
Perform a SWITCH OVER operation and verify the connectivity from CLIENT server

Oracle Data Guard Broker: Overview

Oracle Data Guard Broker: Features
Data Guard Broker: Components
Data Guard Broker: Configurations
Data Guard Broker: Management Model
Data Guard Broker: Architecture
Data Guard Monitor: DMON Process
Benefits of Using the Data Guard Broker
Comparing Configuration Management With and Without the Data Guard Broker
Data Guard Broker Interfaces
Using the Command-Line Interface of the Data Guard Broker

Creating a Data Guard Broker Configuration

Data Guard Broker: Requirements
Data Guard Broker and the SPFILE
Data Guard Monitor: Configuration File
Data Guard Broker: Log Files
Creating a Broker Configuration

Enabling Fast-Start Failover

When Does Fast-Start Failover Occur?
Installing the Observer Software
Fast-Start Failover Prerequisites
Configuring Fast-Start Failover
Viewing Fast-Start Failover Information
Determining the Reason for a Fast-Start Failover
Prohibited Operations After Enabling Fast-Start Failover
Disabling Fast-Start Failover
Disabling Fast-Start Failover Conditions
Using the FORCE Option and stopping observer

DG broker activities

LogXptmode
Enable / disable APPLY
Enable / disable TRANSPORT
Switch over
Failover
Re-instate after the failover
Change protection modes
Disable configuration
Drop standby database from configuration
Remove configuration

Patching and Upgrading Databases in a Physical DataGuard Configuration

Oracle Data Guard Broker Configuration
Applying PSU(11.2.0.3.13) patch
Normal Upgrade (11.2.0.3 to 11.2.0.4)
Rolling Upgrade for Physical Standby Dataguard (11.2.0.3 to 11.2.0.4) – Summary
Rolling Upgrade for Physical Standby Dataguard (11.2.0.3 to 11.2.0.4) – Part 1
Rolling Upgrade for Physical Standby Dataguard (11.2.0.3 to 11.2.0.4) – Part 2
Rolling Upgrade for Physical Standby Dataguard (11.2.0.3 to 11.2.0.4) – Part 3

Creating a Logical Standby Database

Benefits of Implementing a Logical Standby Database
Logical Standby Database: SQL Apply Architecture
SQL Apply Process: Architecture
Preparing to Create a Logical Standby Database
Unsupported Objects, Data types, PL/SQL objects and DDL’s
Ensuring Unique Row Identifiers
Creating a Logical Standby Database by Using SQL Commands – overview
Creating a Logical Standby Database by Using SQL Commands
Securing Your Logical Standby Database
Automatic Deletion of Redo Log Files by SQL Apply
Managing Remote Archived Log File Retention

Course Schedule

Start Date	Weekend/ Weekdays	Timing	Location	Action
	Weekdays, Weekends	11:00 - 3:00 PM	Brampton, ON	Enroll Now

Other Courses

Oracle Admin I

Level: Intermediate
Batch Availability: Weekdays, Weekends
Mode of Class: In-Classroom, Online
Duration: 39 hours

Oracle Admin II