This discussion is archived
2 Replies Latest reply: Mar 5, 2013 7:27 PM by Hemant K Chitale RSS

standby database issue

Meenakshy singh Newbie
Currently Being Moderated
Hi All,

My Oracle database version is Oracle9i Enterprise Edition Release in windows.

My client want to do some verfication on DR database. Users will connect to their application and they should be able to view the DR transaction.Generally our transaction logs come to Production to DR in moring. So they must view all the transaction comes in production to the DR.
phase 2 will be the user submitting the transaction.

overall procedure is :-

1. DBA set the DR in read only mode.
2. User config needs to be changed to point to DR Databse
3. User run the appln to view the transaction.

In this case,we are not going to shutdown the production database.

Now my question is how do I start and what steps do i need to follow? Do i need to disable dataguard from production and open the DR database in read only mode?

  • 1. Re: standby database issue
    Shivananda Rao Guru
    Currently Being Moderated

    If the users need to view the transaction reports on the standby database, then yes, it needs to be opened in Read Only mode.
    But, when you open your standby database in read only mode, there would not be any recovery in progress on the standby (no Active Dataguard option for the version you are using).
    1. Cancel the MRP on the standby database
    SQL>alter database recover managed standby database cancel;
    2. Open the standby database in read only mode
    SQL>alter database open read only;
    You can later ask the users to connect to the standby database by providing them its TNS entries. The standby database can be used only for reporting purpose (select operations) when you have opened it with read only option.

  • 2. Re: standby database issue
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    See 8.2.2 Opening a Standby Database for Read-Only Access at

    Hemant K Chitale


  • Correct Answers - 10 points
  • Helpful Answers - 5 points