This tutorial shows you how to perform a simple read of data from the standby database:
Time to Complete
Approximately 20 minutes
This tutorial covers the following topics:
|Perform a simple read of data from a standby database|
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.
What Is a Active Data Guard?
In Oracle Database 11 g, 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.
Before you perform this tutorial, you should:
Perform an 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.
This task performs a simple read of data in Active Data Guard mode. Perform the following steps:
In your standby database window, invoke DGMGRL and connect as sys/oracle. Disable the MRP process
In your standby database window, invoke SQL*Plus and connect as SYSDBA. Open the physical standby database in read-only mode.
In your standby database window, invoke DGMGRL and connect as sys/oracle. Restart the MRP process.
In your standby database window, invoke SQL*Plus and connect as SYSDBA. Query the HR.REGIONS table.
In your primary database window, invoke SQL*Plus and connect as SYSDBA. Insert a row into the HR.REGIONS table.
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.
In this tutorial, you learned how to:
|Perform a simple read of data from the standby database|