Active Datagaurd in ORACLE 10g

In Oracle Database 10g and below you could open the physical standby database for read-only activities, but only after stopping the recovery process.

In Oracle 11g, you can query the physical standby database in real time while applying the archived logs. This means standby continue to be in sync with primary but can use the standby for reporting.

Let us see the steps now..

First, cancel the managed standby recovery:

SQL> alter database recover managed standby database cancel;

Database altered.

Then, open the database as read only:

SQL> alter database open read only;

Database altered.

While the standby database is open in read-only mode, you can resume the managed recovery process.

SQL> alter database recover managed standby database disconnect;

Database altered.