Oracle Database 19c: Data Guard Administration Workshop

Oracle Database 19c Data Guard Administration

This course introduces the main architectural concepts of Oracle Data Guard.

The delegate will learn how to use Oracle Data Guard to protect an Oracle Database against planned and unplanned downtime.

The Oracle Certified Professional, Oracle Database 19c: Data Guard Administrator is for Database Systems Administrators with responsibility for Disaster Recovery.

Course Overivew

  • This course teaches you how to use Oracle Data Guard.
  • Course will demonstrate how this solution protects your Oracle database against planned and unplanned downtimes.
  • The Oracle Certified Professional, Oracle Database 19c: Data Guard Administrator is for Database Systems Administrators with responsibility for Disaster Recovery.
  • Course gives you a thorough knowledge of Oracle Data Guard Administration.
  • You gain skills and knowledge on Oracle Data Guard concepts, configuration, management, optimization and monitoring, data protection, HA, and disaster recovery.
  • Create a High Availability or Disaster Recovery solution for an Oracle Database ecosystem and gain knowledge of Workload offload capabilities available in Data Guard.
Read More
Read Less
Course Benefits:

COURSE INTRODUCTION

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Module 1: DATA GUARD OVERVIEW

  • Overview of Data Guard
  • Requirements for Maintaining a Standby Database
  • Data Guard Terminology
  • Types of Standby Databases
  • Levels of Protection
  • Physical, Logical and Snapshot Standby Databases
  • Role Transition Management Services
  • Data Guard Interfaces
  • Standby Database Creation
  • Data Guard Installation
  • SYSDG Administrative Privilege for Data Guard Operations

Module 2: DATA GUARD ARCHITECTURE

  • Data Guard Architecture
  • Processes Active on the Primary Database
  • Processes Active on the Standby Database
  • Data Guard Architecture and Initialization Parameters
  • Data Guard usage with a Multitenant Database
  • PDB Creation and Cloning in a Multitenant Architecture Environment

Module 3: CREATE A PHYSICAL STANDBY DATABASE USING SQL COMMANDS

  • Prepare the Primary Database for Data Guard
  • Initialization Parameters for the Standby Database
  • Datafile and Controlfile Duplication
  • Create the Standby Instance
  • Network Files Configuration
  • Activate the Standby Database
  • Verify Primary and Standby Databases are Working
  • Archive Log Loss
  • Open the Standby Database
  • Shut Down and Start Up the Data Guard Environment
  • Put a Physical Standby Database in Managed Recovery Mode
  • Put a Physical Standby Database in Read Only Mode
  • Active Data Guard License
  • Far Sync Instance
  • Monitor the Primary and Standby Databases

Module 4: REDO TRANSPORT SERVICES

  • Overview of Redo Transport Services
  • How Data Guard Sends Redo Data with Synchronous and Asynchronous Transport
  • Control when Redo Data is Sent with the VALID_FOR Option
  • Handle Transmission Errors
  • Manage Archive Gaps
  • Automatic Outage Resolution with Data Guard in 19c
  • Levels of Protection
  • Fast-Sync Mode

Module 5: REDO APPLY SERVICES ON A PHYSICAL STANDBY DATABASE

  • Overview of Log Apply Services
  • Apply Redo Data Immediately
  • Delay Redo Data Application
  • Terminate Redo Apply Services
  • Other Redo Apply Features
  • Configure a Cascading Standby Database

Module 6: CHANGE MANAGEMENT

  • Change Management Overview
  • Add Datafiles or Tablespaces
  • Drop Tablespaces and Delete Datafiles
  • Transportable Tablespaces
  • Rename Datafiles Online
  • Add or Drop Redo Log Files
  • DML Operations on Active Data Guard
  • Recover Nonlogged Blocks
  • Automatic Correction of Non-Logged Blocks
  • Lost Write Detection
  • Shadow Lost Write Protection
  • Data Guard Database Compare

Module 7: CREATE A STANDBY DATABASE WITH RECOVERY MANAGER AND THE DBCA

  • Overview of Standby Database Creation with RMAN
  • Create a Suitable Backup with RMAN
  • Standby Path and File Names
  • Build the Standby Instance
  • Create a Standby Database with RMAN
  • Create a Standby Database with RMAN from an Active Database
  • Create a Standby Database with the dbca in Silent Mode
  • Create a Standby Database for a Multitenant Container Database with the dbca in Silent Mode

Module 8: DATA GUARD BROKER OVERVIEW

  • Overview of Oracle Data Guard Broker
  • Oracle Enterprise Manager
  • The DGMGRL Command Line Interface
  • Data Guard Monitor
  • Install the Oracle Data Guard
  • Start up and use the Data Guard Broker
  • Configure Static Service Registration
  • Obtaining Data Guard Diagnostic Information

Module 9: BUILD A CONFIGURATION USING THE BROKER

  • Prepare for a Configuration Build
  • Configure the Primary Database
  • Configure the Standby Database
  • Rename a Configuration
  • The SHOW DATABASE Command
  • The VALIDATE Command
    • Validate a Database
    • Validate a Datafile
    • Validate Network Configuration
    • Validate Status Connect Identifier
  • Enable and Disable the Configuration
  • Execute DGMGRL Scripts

Module 10: BACKUP AND RECOVERY CONSIDERATIONS IN AN ORACLE DATA GUARD CONFIGURATION

  • Implement a Backup and Recovery Strategy
  • The Usage of RMAN in a Data Guard Configuration
  • Backup and Recovery of a Primary Database with a Physical Standby Database
  • Backup and Recovery of a Logical Standby Database
  • Use a RMAN Recovery Catalog in a Data Guard Configuration
  • Create the Recovery Catalog
  • Register a Database in the Catalog
  • Configure Daily Incremental Backups
  • Recover from the Loss of Datafiles and Control Files on Primary and Standby Databases
  • Recover from the Loss of Online Redo Logs
  • Restore and Recover Datafiles across the Network
  • Roll forward a Physical Standby Database using RECOVER A STANDBY DATABASE FROM SERVICE primary_db
  • One Command Refresh of the Standby Database
  • Enable Block Change Tracking for a Physical Standby Database

Module 11: USE FLASHBACK DATABASE IN A DATA GUARD CONFIGURATION

  • Overview of Flashback Database Usage in a Data Guard Configuration
  • Configure Flashback Database
  • Use Flashback Database Instead of Apply Data
  • Use Flashback Database and Real Time Apply
  • Flashback through Standby Database Role Transitions
  • Automatic Flashback Standby Database
  • Incomplete Recovery if Flashback Database Enabled

Module 12: MANAGE A CONFIGURATION USING THE BROKER

  • Display and Edit Database Properties
  • Set the Configuration Protection Mode
  • Validate a Database
  • Execute a Switchover
  • Execute a Failover
  • Preserve Connections using Role Transmission
  • Alter the state of a Database
  • Export the Broker File Configuration Files
  • Configure Fast Start Failover
  • Configure Multiple Failover Targets
  • Enable and Disable Fast Start Failover
  • Configure Fast Start Failover in Observer Mode
  • Export the Broker File
  • Monitor the Configuration
  • Configure Multiple Observers

Module 13: ROLE TRANSMISSION USING SQL COMMANDS

  • Role Transition Overview
  • Prepare the Primary Database
  • Prepare the Standby Database
  • Perform a Switchover
  • Perform a Failover
  • Reinstate the Failed Primary
  • Preserve Sessions During Switchover or Failover
  • Overview of Application Continuity in a Data Guard Environment

Module 14: CREATE AND MANAGE A SNAPSHOT STANDBY DATABASE

  • Snapshot Standby Database Overview
  • Convert a Physical Standby Database to a Snapshot Standby Database using SQL Commands
  • Convert a Physical Standby Database to a Snapshot Standby Database using the Data Guard Broker

Module 15: CREATE AND MANAGE A LOGICAL STANDBY

  • Overview of the Creation of a Logical Standby Database
  • Prepare the Primary Database
  • Prepare the Standby Database
  • Transition a Physical Standby to a Logical Standby
  • Start and Terminate Redo Apply Services
  • Real Time Apply
  • Delete Archives
  • Monitor the SQL Apply Progress

Module 16: TUNE A STANDBY DATABASE

Module 17: OVERVIEW OF PATCHING AND UPGRADING
Module 18: DATA GUARD QUICK SETUP GUIDE

  • Data Guard Physical Standby Setup using the Data Guard Broker
  • Primary Server Setup
  • Configure Initialization Parameters
  • Service Setup
  • Standby Server Setup
  • Create a Standby Database using DUPLICATE
  • Enable the Broker
  • Database Switchover
  • Database Failover
  • Read-Only Standby and Active Data Guard
  • Create a Snapshot standby
  • 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)
  • The course is designed for database administrators and technical support staff who are required to plan and implement Oracle Data Guard configurations.
  • 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.
Download
Course
Brochure

Prerequisites

This course is available at :

Classroom Training

Cairo
Giza
Onsite

Online Training

Virtual Interactive Instructor LED
Self-Paced Training

WHY CHOOSE CLS

Experience

We have been in the market since 1995, and we kept accumulating experience in the training business, and providing training for more than 100,000 trainees ever since, in Egypt, and the MENA region.

Premium Facilities

CLS facilities are well-equipped with strong hardware and software technologies that aid both students and trainers lead very effective smooth training programs.

Customer Support

We provide our clients with the best solutions, customized to their specific needs and goals. Our team is highly qualified to answer whatever questions you have.

Global Accredited

CLS is an authorized and accredited partner by technology leaders. This means that our training programs are of the highest quality source materials.

Up To Date

We keep tabs on every change in the market and the technology field, so our training programs will always be updated up to the World-class latest standards, and adapted to the global shape-shifting job market.

Certified Instructors

We select the best instructors, who are certified from trustworthy international vendors. They share their professional experience with the Trainees, so they can have a clear hands-on experience.

Over 200,000 Gradutes From CLS

Play Video
Amr Mostafa
An employee of the Security Department at the Ministry of Electricity

I`m attending now CEH Training with Eng Mohamed Hamdy ,CISSP Training with Eng Mohamed Gohar, I really learned a lot from him , everything here in CLS  is very satisfying including facilities .

Play Video
Lamiaa Medhat
CIO

We took a series of courses as the digital Transformation Unit of the ministry . we just finished CRISC Certification Training with DR Adel Abdel Meneim . Thank you CLS for all your efforts, we really appreciate it

Play Video
Ahmed Salah
Senior Cyber Security Engineer

Me and my colleagues are working in a government Organization, We took a no. of cyber security trainings with CLS starting with CEH and CISSP. we liked every thing the instructors, the stuff and whole environment

Play Video
Ferras Hassan
Head of the Programming Department at Bashayer Energy Company

I`m attending ASP.NET Core with MVC Training with Eng Mohamed Hesham , I really learned a lot from him , everything here in CLS  is very satisfying including facilities .Thanks you all team.

Play Video
Mohamed Ahmed Ali
Systems management specialist

Qualifying the cadres of digital transformation units in government agencies moving to the administrative capital .Thanks CLS

Play Video
Zeinab Salah
Software Developer at Bashayer Energy Company

I`m attending ASP.NET Core with MVC Training with Eng Mohamed Hesham , I really learned a lot from him , everything here in CLS  is very satisfying including facilities .Thanks you all team.

Play Video
Ibrahim Khalaf
IT Infrastructure and Security Manger

I`m attending now CRISC Training with DR Adel Abdel Meneim , I really learned a lot from him , everything here in CLS  is very satisfying including facilities , locations and the team.

Play Video
Samar Shams ElDin
Programmer at Bashayer Energy Company

I`m attending ASP.NET Core with MVC Training with Eng Mohamed Hesham , I really learned a lot from him , everything here in CLS  is very satisfying including facilities .Thanks you all team.

Student Application For

Oracle Database 19c Data Guard Administration
Full Name *
Email *
Phone *
Full Phone
Training Location *
Additional Request

Business Application For

Oracle Database 19c Data Guard Administration
Full Name *
Company Name *
Job Title *
Number of Employees
Email *
Phone *
Full Phone
Training Location *
Additional Request