2 Replies Latest reply: Mar 5, 2013 9:27 PM by Hemant K Chitale RSS

    standby database issue

    Meenakshy singh
      Hi All,

      My Oracle database version is Oracle9i Enterprise Edition Release 9.2.0.8.1 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?

      Thanks,
      Meena
        • 1. Re: standby database issue
          Shivananda Rao
          Hello,

          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.


          Regards,
          Shivananda
          • 2. Re: standby database issue
            Hemant K Chitale
            See 8.2.2 Opening a Standby Database for Read-Only Access at

            http://docs.oracle.com/cd/B10501_01/server.920/a96653/manage_ps.htm#1014483


            Hemant K Chitale