Data Guard Training

by Roicians Claim Listing

This course is designed to keep in mind how important it is to keep databases available for use. Data Guard is in need of an hour for any database management. You will get to work on live scenarios with real-time data.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Roicians Logo

img Duration

39 Hours

Course Details

This course is designed to keep in mind how important it is to keep databases available for use. Data Guard is in need of an hour for any database management. You will get to work on live scenarios with real-time data.

 

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 the database on the primary database server.

  • Prepare the primary database.

  • Set parameters in 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 or disable APPLY

  • Enable or 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 the 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:::::::: An 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

  • Brampton Branch

    20A-284 Orenda Road, Brampton

Check out more Data Science courses in Canada

IIBS Toronto Logo

Tableau

This is a knowledge-packed professional learning experience that includes a cutting-edge curriculum, real business projects and case studies, and tech-enabled education. Our training goes a long way towards helping you unlock lucrative career opportunities in the coveted fields of data analytics.

by IIBS Toronto [Claim Listing ]
Q Academy Logo

PowerBI

Power BI is revolutionizing the way organizations analyze data, make data-driven decisions, and communicate insights effectively. Whether you are a business analyst, data professional, or anyone interested in leveraging data for better decision-making.

by Q Academy [Claim Listing ]
Eccentrix Logo

Power BI Data Analyst Associate (PL300)

This Microsoft certified course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI.

by Eccentrix [Claim Listing ]
Knowledge Hut Logo

Data Visualization Using Tableau Training

KnowledgeHut’s Data Visualization with Tableau course will teach you how to use Tableau to build data visualizations, organize data, and design dashboards.

by Knowledge Hut [Claim Listing ]
University of Winnipeg Professional, Applied and Continuing Logo

Artificial Intelligence Diploma

In this program, graduates master the skills to create and use problem-solving algorithms to provide insights, predictions, and operationalization strategies needed to transform any organization into an innovative, efficient, and sustainable company of the future.

by University of Winnipeg Professional, Applied and Continuing [Claim Listing ]
  • Price
  • Start Date
  • Duration

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy