19c Dataguard Admin

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.

Course Overview

Course Objective

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 Learn

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

Administrator
Architect
Database Administrator

Prerequisite

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

1. Creating a Physical Standby Database by Using Enterprise Manager Cloud Control

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

3. Creating a Physical Standby Database by Using SQL and RMAN Commands

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

5. Creating and Managing a Snapshot Standby Database

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

7. Oracle Data Guard Broker: Overview

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

9. Monitoring a Data Guard Broker Configuration

Use Enterprise Manager Cloud Control to monitor the configuration
Use DGMGRL to monitor the configuration
Use SQL to monitor the configuration

11. Performing Role Transitions

Explain the database roles
Perform a switchover
Perform a failover

13. Enabling Fast-Start 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

15. Enhanced Client Connectivity in a Data Guard Environment

Configure client connectivity in a Data Guard configuration
Implement failover procedures to automatically redirect clients to a new primary database

17. Optimizing a Data Guard Configuration

Monitor configuration performance
Optimize redo transport for best performance
Optimize SQL Apply

19. Introduction to Oracle Data Guard

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

2. Oracle Net Services in a Data Guard Environment

Understand the basics of Oracle Net Services
Configure client connectivity in a Data Guard configuration
Implement Data Guard best practice solutions in networking setup

4. Using Oracle Active Data Guard

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

6. Creating a Logical Standby Database

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

8. Creating a Data Guard Broker Configuration

Create a Data Guard broker configuration
Manage the Data Guard broker configuration

10. Configuring Data Protection Modes

Describe the data protection modes
Change the data protection mode of your configuration
- Using Enterprise Manager Cloud Control
- Using DGMGRL
- Using SQL

12. Using Flashback Database in a Data Guard Configuration

Explain the advantages of using Flashback Database in a Data Guard configuration
Configure Flashback Database

14. Backup and Recovery Considerations in an Oracle Data Guard Configuration

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

16. Patching and Upgrading Databases in a Data Guard Configuration

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

18. Oracle Database Exadata Cloud Service Overview

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.