Mississauga College of Technology

Tel: 905.232.8628 Fax: 905.232.1672

Address: 240-33 City Centre Dr. Mississauga, ON. L5B 2N5

E-mail: info@mississaugacollege.com

Oracle Data Guard   <ODAG131>


Automate to create and maintain a synchronized copy of the production database which will be called a standby database, that can be used for maintenance or if the Database is damaged.


Prepare to manage, monitor, and protect database using Data Guard


  • Introducing Data Guard
  • Using SQL and RMAN to create Physical Standby Database
  • Creating Data Guard Broker
  • Configuring Data Guard Broker
  • Creating physical Standby Database by using Enterprise Manager Grid Control
  • Creating Logical Standby Database
  • Configuring Data Protection Modes
  • Monitoring Data Guard Configuration
  • Optimizing Data Guard Configuration
  • Using Flashback Database in Data Guard Configuration
  • Performing Role Transitions
  • Enabling Fail-Start Failover
  • Creating and Managing a snapshot Standby Database
  • Using Oracle Active Data Guard
  • Performing Backup and Recovery in an Oracle Data Guard Configuration
  • Managing Client Connectivity
  • Patching and upgrading in a Data Guard Configuration


Instructor lead classes and hand-on experience the student shall be able to appear not only for exam, but to gain more in depth knowledge to protect database server.


Oracle DBA121, DBA122


Database Administrator, Project Manager, Technical Manager

Duration:32 hours


Copyright © 2012 Mississauga College of Technolog All Rights Reserved
Call Today: 905-232-8628
EmailEmail: info@mississaugacollege.com
AddressAddress: 240-33 City Centre Dr. Mississauga, ON. L5B 2N5
Developed by Jimvisual