Oracle Database 19c: Data Guard Administration Workshop

Prerequisites

• Understanding of relational database concepts and a good knowledge of the operating system.
• Database Administration
• Linux operating system fundamentals

Audience

• This course is designed for Oracle Database Administrators who would like to use Oracle Data Guard
• Those DBAs who already have experience on Oracle Data Guard, this course is NOT for them.

Course Outline

• Oracle Net Services in a Data Guard Environment
• Creating a Physical Standby Database by Using SQL and RMAN Commands
• Managing Physical Standby Files After Structural Changes on the Primary Database
• Using Oracle Active Data Guard: Supported Workloads in Read-Only Standby
• Using Oracle Active Data Guard: Far Sync and Real-Time Cascading
• Creating and Managing a Snapshot Standby Database
• Creating a Logical Standby Database
• Creating and Monitoring a Data Guard Broker Configuration
• Configuring Data Protection Modes
• Optimizing and Tuning a Data Guard Configuration
• Performing Role Transitions
• Using Flashback Database in a Data Guard Configuration
• Enabling Fast-Start Failover
• Backup and Recovery Considerations in an Oracle Data Guard Configuration
• Enhanced Client Connectivity in a Data Guard Environment
• Patching and Upgrading Databases in a Data Guard Configuration