Re: Recovering a deleted archive log for standby

Scott Hussey wrote:
>
> I have two Oracle 8.1.7 databases. One is the production system running
> in ARCHIVELOG mode. The other is a standby database. We move the archive
> logs from the production to the standby database and apply them as
> usual. However, we had a mishap when trying to develop some automated
> archive log gap recovery scripts and one of the archive logs on the
> production machine got deleted BEFORE it was moved to the standby
> database and applied (also before it got backed up). We are now curious
> what is the best way to recover from this? The production system is
> currently okay, so we have a current system to make cold backups from.
> Is there a way to recover the deleted archive log from the production
> database or is it possible (and a good idea) to rebuild the standby
> database from the current production image and then restart the archive
> log thread. Thanks.

You'll need to rebuild the standby - you don't need to stop production - just do a hotbackup of the files and send them over to the standby and recover

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."