This content has been marked as final. Show 2 replies
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).
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.
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;
See 8.2.2 Opening a Standby Database for Read-Only Access at
Hemant K Chitale