Data Guard Hands-On Lab

Data Guard Hands-On Lab Instructions and Documentation

This lab uses a number of exercises that run on a live Oracle Database to introduce the user to basic Data Guard functions.  Exercises include:

  • Creating a Physical Standby Database
  • Verifying that Redo Transport has been configured correctly.
  • Configuring the Data Guard Broker
  • Changing the Transport mode using Broker Properties
  • Changing the Protection mode to Maximum Availability
  • Performing a switchover from the Primary to the Standby
  • Enabling Flashback database
  • Performing a Manual Failover from the Primary to the standby
  • Enabling and using Fast-Start Failover
The Hands-On Lab requires that you have a system with the version of the Oracle Database (11.2 or 12.1) installed on a system and that you have created a database called SFO from the seed databases.  You can use any name you wish but the examples in the handout use SFO as the Primary database name.

The Hands-On Lab is provided as-is. We believe the documentation is sufficient for DBA's to be successful following this lab. We ask that you read the documentation carefully in order to avoid problems. However, if you have difficulties accessing the Hands-On Lab, or if you believe there is an error in the documentation that makes it impossible to complete the lab successfully, please send email to and Larry will do his best to assist you.