Duration
Oracle Database 19c: Data Guard Administration Workshop
5 days
Overview
This Oracle 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.
Through a blend of hands-on labs and interactive lectures you will also learn how to create and manage physical, logical and snapshot standby databases and how to use standby databases for reporting, querying and testing purposes.
Skills Covered
The delegate will learn and acquire skills as follows:
- Preparing a Primary Database for a Data Guard Configuration
- Creating a Physical Standby Database
- Creating a Logical Standby Database
- Creating a Snapshot Standby Database
- Monitoring a Standby Database Configuration
- Managing a Data Guard Configuration
- Troubleshooting Standby Database Configurations
- Tuning a Standby Database
- Backing up and Recovering a Data Guard Configuration
- Using Flashback in a Data Guard Configuration
Prerequisites
Knowledge of Oracle Database Administration is required.
Outline
- Data Guard Components
- Data Guard Transport Method
- Differences between Failover and Switchover
- Data Guard Framework
- Data Guard Broker Configuration
- Defining Gap Resolution
- Defining Protection Modes
- Operating System Requirements
- Manually Creating a Physical Standby Database
- Physical Standby Database and Cloud Control
- Logical Standby Database
- Using Cloud Control to Create a Logical Database
- Backup Methods and Data Guard
- Flashback Database and Data Guard
- Backing up in a Data Guard Environment
- Data Guard and Failover
- Cloud Control and Failover
- Data Guard and Switch Over
- Cloud and Switch Over
- Define Fast Start Failover
- Failover Client
- Define a Snapshot Standby Database
- Oracle Active Data Guard
- Managing Data Guard Components
- Upgrading databases with Data Guard
Programme scope, delivery arrangements and suitability are confirmed during enquiry.