PT.
Mitra Integrasi Informatika - member of METRODATA
APL Tower 37th Fl. Suite 1-8, Jl. Letjend. S. Parman kav. 28, Jakarta 11470
Phone (62-21) 29345 777 | Fax (62-21) 29345 700 | Website [Link]
"World Class Business Technology Partner"
Oracle Training
D108630
Oracle Database 19c: Data Guard Administration Workshop
Audience : IT Professionals
This Revisio :A
Delivery Method : Online/Classroom
Length : 5 Days
Course Overview
Working within in a hands-on learning environment, guided by our expert team, attendees
will learn to:
Use Data Guard standby databases to support production functions such as reporting, querying,
testing, and performing backups
Create and manage physical and logical standby databases
Use Enterprise Manager Cloud Control and the Data Guard command-line interface (DGMGRL) to
maintain a Data Guard configuration
Use Data Guard to achieve a highly available Oracle database
Gain an understanding of Oracle Database Exadata Cloud Service
Audince
This hands on course is geared for experienced Database Administrators who possess
Basic understanding of Oracle Database principles
Linux operating system fundamentals
Basic understanding of PL/SQL and Triggers
At Course Completion
Working within in a hands-on learning environment, guided by our expert team, attendees
will learn to:
Use Data Guard standby databases to support production functions such as reporting, querying,
testing, and performing backups
Create and manage physical and logical standby databases
Use Enterprise Manager Cloud Control and the Data Guard command-line interface (DGMGRL) to
maintain a Data Guard configuration
Page 1
Metrodata Academy
PT. Mitra Integrasi Informatika - member of METRODATA
APL Tower 37th Fl. Suite 1-8, Jl. Letjend. S. Parman kav. 28, Jakarta 11470
Phone (62-21) 29345 777 | Fax (62-21) 29345 700 | Website [Link]
"World Class Business Technology Partner"
Use Data Guard to achieve a highly available Oracle database
Gain an understanding of Oracle Database Exadata Cloud Service
Course Outline
Introduction to Oracle Data Guard
Basic components of Oracle Data Guard
Physical and logical standby databases
Benefits of implementing Oracle Data Guard
Creating a Physical Standby Database by Using Enterprise Manager Cloud Control
Data Guard broker configuration
Physical standby database
Data Guard configuration
Database properties
Data Guard configuration
Oracle Net Services in a Data Guard Environment
Basics of Oracle Net Services
Client connectivity
Data Guard best practice solutions
Creating a Physical Standby Database by Using SQL and RMAN Commands
Primary database and Oracle Net Services
Physical standby database
Using Oracle Active Data Guard
Real-time query
RMAN block change tracking
Far Sync
Creating and Managing a Snapshot Standby Database
Page 2
Metrodata Academy
PT. Mitra Integrasi Informatika - member of METRODATA
APL Tower 37th Fl. Suite 1-8, Jl. Letjend. S. Parman kav. 28, Jakarta 11470
Phone (62-21) 29345 777 | Fax (62-21) 29345 700 | Website [Link]
"World Class Business Technology Partner"
Snapshot standby database
Converting a snapshot standby database
Creating a Logical Standby Database
Creating a logical standby database
SQL Apply filtering
Oracle Data Guard Broker: Overview
Data Guard broker architecture
Data Guard broker components
Benefits of the Data Guard broker
Data Guard broker configurations
Enterprise Manager
DGMGRL
Creating a Data Guard Broker Configuration
Monitoring a Data Guard Broker Configuration
Enterprise Manager Cloud Control
DGMGRL
SQL
Configuring Data Protection Modes
Describing the Data Protection Modes
Changing the Data Protection Modes
Performing Role Transitions
Database roles
Switchover
Failover
Using Flashback Database in a Data Guard Configuration
Page 3
Metrodata Academy
PT. Mitra Integrasi Informatika - member of METRODATA
APL Tower 37th Fl. Suite 1-8, Jl. Letjend. S. Parman kav. 28, Jakarta 11470
Phone (62-21) 29345 777 | Fax (62-21) 29345 700 | Website [Link]
"World Class Business Technology Partner"
Advantages of using Flashback Database
Configuring Flashback Database
Enabling Fast-Start Failover
Fast-start failover
Fast-start failover configuration
Observer
Role changes
Reinstating the primary database
Backup and Recovery Considerations in an Oracle Data Guard Configuration
Recovery Manager (RMAN)
Offload backups
Recovering primary database
Enhanced Client Connectivity in a Data Guard Environment
Client Connectivity in a Data Guard Environment
Failover procedures
Patching and Upgrading Databases in a Data Guard Configuration
Standby-First Patch Apply technique
Traditional upgrade methods
Rolling upgrades
DBMS_ROLLING
Optimizing a Data Guard Configuration
Monitoring configuration performance
Redo transport
SQL Apply
Oracle Database Exadata Cloud Service Overview
Page 4
Metrodata Academy
PT. Mitra Integrasi Informatika - member of METRODATA
APL Tower 37th Fl. Suite 1-8, Jl. Letjend. S. Parman kav. 28, Jakarta 11470
Phone (62-21) 29345 777 | Fax (62-21) 29345 700 | Website [Link]
"World Class Business Technology Partner"
Architecture and capabilities of Exadata Cloud Service
Exadata Cloud Service and an on-premise Exadata implementation
Page 5
Metrodata Academy
