This discussion is archived
12 Replies Latest reply: Nov 11, 2013 10:39 PM by petra-K RSS

I want to Open Standby DB for reporting,

petra-K Expert
Currently Being Moderated



I want to open our standby db for reporting, but I want to retain an backup of the standby to resume it afterwards. Is this possible?


Supposing my standby db is located at /u01/oradata/PROD.


I will shutdown the standby db, then copy PROD to PROD_bak.

Then alter open the standby. and run the reports.

Afterwards shutdown again and I will rename it back, and resume standby.


Is this process ok?




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