12 Replies Latest reply: Nov 12, 2013 12:39 AM by petra-K RSS

    I want to Open Standby DB for reporting,




      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?