Oracle Database Discussions

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!

Manual Standby Recovery

821674Dec 19 2010 — edited Dec 20 2010

Hi Friendz,

Oracle Db 9i

I have configured a manual standby database(I am not using Dataguard or "create standby database" command ) I only copy the cold backup to the target recovery server. I have been applying archive logs to it for a week now. I use the "recover automatic database using backup controlfile" command.

My problem is, when I try to "alter database open resetlogs" so I can test if I can open it, It is asking for the next archive log and message "that the system01.dbf needs recovery". How can I open my standby database and force it to stop recovery?

Thanks a lot

Ms Inday

This post has been answered by CKPT on Dec 20 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 17 2011

Added on Dec 19 2010

#general-database-discussions

48 comments

1,070 views