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

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,

Legend

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