Using Active Data Guard

Purpose

This tutorial shows you how to perform a simple read of data from the standby database:

When the standby is caught up, stop the Apply on the physical standby
Open the Physical standby read only
Restart the apply
Being making changes to the primary
Verify that those changes arrive at the standby

Time to Complete

Approximately 20 minutes

Topics

This tutorial covers the following topics:

	Overview
	Prerequisites
	Perform a simple read of data from a standby database
	Summary

Viewing Screenshots

Place the cursor over this icon to load and view all the screenshots for this tutorial. (Caution: This action loads all screenshots simultaneously, so response time may be slow depending on your Internet connection.)

Note: Alternatively, you can place the cursor over an individual icon in the following steps to load and view only the screenshot associated with that step. You can hide an individual screenshot by clicking it.

Overview

What Is a Active Data Guard?

In Oracle Database 11g, you can now use a physical standby database for queries while redo is applied to the physical standby database.

In earlier versions, when you opened the physical standby database in read-only mode, the redo application stopped.

Active Data Guard enables you to use a physical standby database for disaster recovery and to offload work from the primary database during normal operation.

Back to Topic List

Prerequisites

Before you perform this tutorial, you should:

1.	Oracle Database 11g installation (software and db installed) for a single server environment OR Oracle Database 11g installation (software and db installed) on 1 server and Oracle Database 11g software only on 2nd server for a dual server environment.
2.	Creating a DG Broker Configuration OBE

Back to Topic List

Perform a simple read of data from a standby database

This task performs a simple read of data in Active Data Guard mode. Perform the following steps:

1.	In your standby database window, invoke DGMGRL and connect as sys/oracle. Disable the MRP process
2.	In your standby database window, invoke SQL*Plus and connect as SYSDBA. Open the physical standby database in read-only mode.
3.	In your standby database window, invoke DGMGRL and connect as sys/oracle. Restart the MRP process.
4.	In your standby database window, invoke SQL*Plus and connect as SYSDBA. Query the HR.REGIONS table.
5.	In your primary database window, invoke SQL*Plus and connect as SYSDBA. Insert a row into the HR.REGIONS table.
6.	Return to your standby database window and query the HR.REGIONS table again. You should see the new row that you inserted into the HR.REGIONS table on your primary database now in your standby database. If you do not immediately see the row, retry the query.

Back to Topic List

Back to Topic

Summary

In this tutorial, you learned how to:

Perform a simple read of data from the standby database

Back to Topic List