Re: The strange case of the missing archived log
From: jason arneil <jason.arneil_at_gmail.com>
Date: Thu, 21 Aug 2008 16:22:38 +0100
Message-ID: <fda4898f0808210822v24840406n5f16bd6f3eb65f@mail.gmail.com>
Date: Thu, 21 Aug 2008 16:22:38 +0100
Message-ID: <fda4898f0808210822v24840406n5f16bd6f3eb65f@mail.gmail.com>
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_at_gmail.com>wrote:Received on Thu Aug 21 2008 - 10:22:38 CDT
> 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
>
>
-- http://www.freelists.org/webpage/oracle-l