Oracle Data Guard is the most effective solution available today to protect the core asset of any enterprise—its data and make it available on a 24×7 basis even in the face of disasters and other calamities. This course describes Oracle Data Guard technology and concepts and helps you configure and implement standby databases.


What will you learn?

This Oracle Database 19c: Data Guard Administration Ed 1 training teaches you how to use Oracle Data Guard. Expert Oracle University instructors will demonstrate how this solution protects your Oracle database against planned and unplanned downtimes. In this course, you will be introduced to Oracle Database Exadata Cloud Service.

Learn To:

  • Build highly available systems.
  • Offload business processing needs to another system.
  • Offload backup needs to another system.
  • Gain an understanding of Oracle Database Exadata Cloud Service.

Benefits to You

You’ll walk away from this course with an understanding of how Data Guard standby databases can be used to support various production functions. These functions include reporting, querying, and testing, while in a standby role.

Oracle Data Guard 19c

This course will also teach you about the new Oracle Data Guard 19c features and architecture. You’ll get a chance to explore topics like Oracle Active Data Guard, Far Sync, rolling upgrades, and snapshot standby databases. Furthermore, enrolling in this course will help you learn how to manage and troubleshoot a Data Guard configuration.

Who should go for this training?
The following professionals can go for this course:

  • Administrator
  • Architect
  • Database Administrator

What are the pre-requisites for this Course?

  • Oracle Database 11g: Administration Workshop I Ed 2
  • Oracle Database 11g: Administration Workshop II Ed 2
  • Database Administration
  • Linux operating system fundamentals

Course Content

  • Create a Data Guard broker configuration
  • Create a physical standby database
  • Verify a Data Guard configuration
  • Edit database properties related to Data Guard
  • Test a Data Guard configuration
  • 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
  • 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
  • The Data Guard broker architecture
  • Data Guard broker components
  • Benefits of the Data Guard broker
  • Data Guard broker configurations
  • How to use Enterprise Manager to manage your Data Guard configuration
  • How to invoke DGMGRL to manage your Data Guard configuration
  • Use Enterprise Manager Cloud Control to monitor the configuration
  • Use DGMGRL to monitor the configuration
  • Use SQL to monitor the configuration
  • Explain the database roles
  • Perform a switchover
  • Perform a failover
  • 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
  • Configure client connectivity in a Data Guard configuration
  • Implement failover procedures to automatically redirect clients to a new primary database
  • Monitor configuration performance
  • Optimize redo transport for best performance
  • Optimize SQL Apply
  • Describe the basic components of Oracle Data Guard
  • Explain the differences between physical and logical standby databases
  • Explain the benefits of implementing Oracle Data Guard
  • Understand the basics of Oracle Net Services
  • Configure client connectivity in a Data Guard configuration
  • Implement Data Guard best practice solutions in networking setup
  • Use real-time query to access data on a physical standby database
  • Enable RMAN block change tracking for a physical standby database
  • Use Far Sync to extend zero data loss protection for intercontinental configurations
  • Determine when to create a logical standby database
  • Create a logical standby database
  • Manage SQL Apply filtering
  • Create a Data Guard broker configuration
  • Manage the Data Guard broker configuration
  • Describe the data protection modes
  • Change the data protection mode of your configuration
    • Using Enterprise Manager Cloud Control
    • Using DGMGRL
    • Using SQL
  • Explain the advantages of using Flashback Database in a Data Guard configuration
  • Configure Flashback Database
  • Use Recovery Manager (RMAN) to back up and restore files in a Data Guard configuration
  • Offload backups to a physical standby database
  • Recover your primary database by using a file from the physical standby database
  • By using Standby-First Patch Apply technique
  • By using traditional upgrade methods
  • By performing rolling upgrades
  • By using the DBMS_ROLLING package with Active Data Guard
  • Describe the architecture and capabilities of Exadata Cloud Service
  • Compare and contrast between Exadata Cloud Service and an on-premise Exadata implementation

Modes of Training

Classroom Training

Live interactive sessions delivered in our classroom by our expert trainers with real-time scenarios.

Online Training

Learn from anywhere over the internet, joining the live sessions delivered by our expert trainers.

Self-Pace Training

Learn through pre-recorded video sessions delivered by experts at your own pace and timing.

Frequently Asked Questions

Our trainer is an OCP & OCM certified consultant and has a significant amount of experience in working with the technology, having 18yrs of experience.

Once you get registered, our back-end team will share you the details to join the session live over an online portal which can be accessed through a browser.

Each of our live sessions is recorded. In case if you miss any, you can request us to share the link to that particular session.

For practical execution, our trainer/technical team will provide server access details to the student

Yes. We do provide the step-by-step document which you can follow and if required our technical team will assist you.

Live-Online training is where you can have a live session with the trainer and clarify queries parallelly.

Pre-recorded sessions are the recorded videos that will be provided to you that you can see, listen, and learn anytime at ur feasible place. For doubts in the videos, you can mail the trainer regarding the same.

You can contact our support team, or just drop an email to help@sarinfotechindia.com with your queries.

The course material and recorded videos which are provided during the course period. You can download it anytime.

Visit our website regularly to check discounts offers from time to time. However, we provide a discount for single participants & special discounts for 2 or more participants.

* If the request for cancelation is made within 2 days of enrolment for class, 100% refunded.

* If the request made after 2 days, then Refund is made after deduction of the administration fee.

There are no reviews yet.

Be the first to review “19c Dataguard Admin”