Re: The strange case of the missing archived log

Your standby is not trashed.

If you have no way of accessing the missing log(s), take an incremental
backup of the primary using the SCN of where the standby is up to and apply
this backup to the standby:

http://jarneil.wordpress.com/2008/06/03/applying-an-incremental-backup-to-a-physical-standby/

Well if the archived redo logs were not removed using rm, they could have
been removed with rman.

jason.

--
http://jarneil.wordpress.com


On Thu, Aug 21, 2008 at 3:54 PM, Howard Latham <howard.latham@xxxxxxxxx>wrote:

> Typical - I go on holiday for day and somebody generates an abnormal load
> of archived logs.
> They filled up the disk, moved the wrong files then moved the right files -
> did a reboot and hey presto
> although the DB comes up fine I discover that an archived log is
> missing.Thats my standby trashed!
>  Assuming the non use the rm command anyone got an idea how it happened?
> OS Redhat Linux DB Version 10g
> --
> Howard A. Latham
> DBA
> RSMB TV Research
> London, England
>
>

Other related posts: