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,