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

    I want to Open Standby DB for reporting,

      Hi,

       

      11.2.0.1

       

      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?

       

      Thanks,