Re: The strange case of the missing archived log

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 21 Aug 2008 16:41:05 +0100
Message-ID: <7765c8970808210841q11c1a154vbe39dd2f9383ca9@mail.gmail.com>


except that I don't believe that RMAN should allow the removal of unapplied archive logs in a standby config

On Thu, Aug 21, 2008 at 4:22 PM, jason arneil <jason.arneil_at_gmail.com>wrote:

> 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:
>
>> 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
>>
>>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 21 2008 - 10:41:05 CDT

Original text of this message