Login     Signup
   info@zetlantechnologies.com        +91-8680961847

  /   Oracle Technical Certification   /   19C Data Guard Administrator


Exam 1Z0-076: Oracle Database 19C Data Guard Administrator


Exam Code Delivery format Duration No of Questions Passing Score
1Z0-076 Proctored Online Multiple Choice 120 Minutes 74 61%

Exam Overview

The Oracle Certified Professional, Oracle Database 19c: Data Guard Administrator certification is for Database Systems Administrators with responsibility for Disaster Recovery. Ideal candidates have 4 to 5 years of Database Administration with 2 to 3 years of Data Guard.

Preparing for the required exam 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. By passing this exam, a certified individual shows you have the ability to create a High Availability or Disaster Recovery solution for an Oracle Database ecosystem and gain knowledge of Workload offload capabilities available in Data Guard.


Course Details

1. Oracle Data Guard Basics

  • Describe the Architecture of Oracle Data Guard
  • Explain the applicability between physical and logical standby and snapshot databases
  • Explain the benefits of implementing Oracle Data Guard
  • Explain Data Guard use with the Oracle Multi-tennant databases

  • Understand the basics of Oracle Net Services
  • Implement Data Guard best-practice solutions in the networking setup
  • Configure the primary database and Oracle Net Services to support the creation of the physical standby database and role transition
  • Create a physical standby database by using the DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE RMAN command
  • Describe the Database Nologging Enhancements
  • Demonstrate the usage of the PL/SQL procedure DBMS_DBCOMP.DBCOMP
  • Explain the creation of a standby database by using DBCA

  • Perform Real-Time query to access data on a physical standby database
  • Describe the supported workload in Active Data Guard (Read-Only) instances
  • Create a snapshot standby database to meet the requirement for a temporary, updatable snapshot of a physical standby database
  • Convert a snapshot standby database back to a physical standby database

  • Determine when to create a logical standby database
  • Create a logical standby database
  • Manage SQL Apply filtering

  • Describe the Data Guard broker architecture
  • Describe the Data Guard broker components
  • Explain the benefits of the Data Guard broker
  • Describe Data Guard broker configurations
  • Create a Data Guard broker configuration
  • Manage the Data Guard broker configuration
  • List the new Data Guard Broker commands

  • Use Enterprise Manager to manage your Data Guard configuration
  • Invoke DGMGRL to manage your Data Guard configuration
  • List the new Data Guard Broker VALIDATE commands
  • Describe the data protection modes
  • Change the data protection mode of your configuration

  • Explain the database roles
  • Perform a switchover
  • Perform a failover
  • Explain how to keep physical standby sessions during role transition

  • Configure Flashback Database
  • Explain the advantages of using Flashback Database in a Data Guard configuration
  • Explain the functionality of replicated restore points
  • Explain the functionality of automatic flashback

  • Configure fast-start failover
  • View information about the fast-start failover configuration
  • Manage the observer
  • Perform role changes in a fast-start failover configuration
  • Manually reinstate the primary database

  • Use Recovery Manager (RMAN) to back up and restore files in a Data Guard configuration
  • Offload backups to a physical standby database
  • Enable RMAN block change tracking for a physical standby database
  • Recover your primary database over the network
  • Synchronize Standby Database from Primary Database with one command
  • Using Automatic Block Media Recovery
  • Patch and upgrade databases using traditional patch methods
  • Perform rolling upgrades
  • Monitor configuration performance
  • Optimize redo transport for best performance
  • Optimize SQL Apply
  • Describe Tunable Automatic Outage Resolution
  • List Diagnostic Tools in Active Data Guard (Read-Only) environment

  • Describe the primary database changes that may or may not require manual intervention at a physical standby database.
  • Use Far Sync to extend zero data loss protection for intercontinental configurations
  • Describe how to create a far sync instance by using RMAN
  • Describe the Real-Time Cascading
  • Configure client connectivity in a Data Guard configuration
  • Implement failover procedures to automatically redirect clients to a new primary database
  • Using Application Continuity in a Data Guard Environment


Fees Structure : 15500 INR / 185 USD
Total No of Class : 63 Video Class
Class Duration : 52:30 Working Hours
Download Feature : Download Avalable
Technical Support : Call / Whatsapp : +91 8680961847
Working Hours : Monday to Firday 9 AM to 6 PM
Payment Mode : Credit Card / Debit Card / NetBanking / Wallet (Gpay/Phonepay/Paytm/WhatsApp Pay)

Brochure       Buy Now       Sample Demo

Fees Structure : 30000 INR / 355 USD
Class Duration : 60 Days
Class Recording : Live Class Recording available
Class Time : Monday to Firday 1.5 hours per day / Weekend 3 Hours per day
Technical Support : Call / Whatsapp : +91 8680961847
Working Hours : Monday to Firday 9 AM to 6 PM
Payment Mode : Credit Card / Debit Card / NetBanking / Wallet (Gpay/Phonepay/Paytm/WhatsApp Pay)

Download Brochure       Pay Online