Usually it should be "REBUILD STANDBY" as that would be more
simpler then what U are trying to achieve.

> Take Hot/Cold backup of Primary
> Create STANDBY control file on Primary
> Restore Backup on Standy host
> Copy standby control file at appr location as per init.ora on Standby
> Startup nomount.
> Mount Standby DB
> Start archiving on Primary
> Enable managed recovery on Standby
================================

HTHU

Ankur Shah
Oracle DBA
DHR-GA


----- Original Message -----
From: "medisa hodzic" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, October 30, 2003 10:08 AM
Subject: standby restore db


> we have to restore our stand by database as we have lost some of the
> archived redo log files;
>
> would the following steps work:
> 1. recover files from primary (.dbf and redo files)
> 2. connect to standby database and issue:
> alter system backup controlfile to trace;
> 3. shutdown standby
> 4. amend the cotrolfile so that it reads:
> startup nomount create controlfile reuse database "primary" noresetlogs
> archivelog
> 5. delete existing control file on standby
> 6. run the above .sql to startup standby
> 7. apply archve logs
>
> thank you in advance
>
> _________________________________________________________________
> Stay in touch with absent friends - get MSN Messenger
> http://www.msn.co.uk/messenger
>
>
> --------
> Get today's cartoon: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>
Oracle LazyDBA home page