Using Active Data Guard
Using Active Data Guard
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
- Begin making changes to the primary
- Verify that those changes arrive at the standby
Approximately 20 minutes
This tutorial covers the following topics:
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 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
Before you perform this tutorial, you should:
| 1. |
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. |
| 2. |
Creating a DG Broker Configuration OBE |
Back to Topic List
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
In this tutorial, you learned how to:
Back to Topic List
Place the cursor over this icon to hide all screenshots.
| 
Bookmark