Active Data Guard Hands-On Lab

Active 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 advanced Active Data Guard functions. The lab exercises include:

  • Enabling Active Data Guard
  • Reading real-time data from an Active Data Guard Standby Database
  • Automatically managing potential apply lag using Active Data Guard query SLAs
  • Writing data when using an Active Data Guard standby.
  • Using schema redirection with Active Data Guard
  • Using Active Data Guard automatic block repair to detect and repair corrupt blocks on either the primary or standby, transparent to applications and users
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 and a physical standby created with the name of NYC.  You can use any names you wish but the examples in the handout use SFO and NYC.   For complete instructions please refer to the "Setup and Configuration" section in the handout at the link above. 

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.