Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Recover standby database !!

598389Oct 15 2008 — edited Oct 16 2008

Hello,

I heared that to save CPU cycles and resources it is recommended to backup standby database instead of Prime database. i have AIX 5.3 running over HACMP Oracle 9i RAC. I have a physical standby.

What i am looking for to backup this standby database and recover in standlone machine. I have tried several things but i am not sure i am doing right or wrong..

1) i took backup of controlfile from Primary and backup of standby database. - Didnt work
2) taken binary control file from standby box and tried to recover database - Didnt work
3) As controlfile is standby controlfile so i cant use recover database using backup controlfile..

If any body has any experiance on this . please share.. What could be process to recover a standby database.

Many thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 13 2008

Added on Oct 15 2008

#performance-availability, #recovery-manager-rman

6 comments

509 views