Re: The strange case of the missing archived log

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: jason.arneil@xxxxxxxxx
  • Date: Thu, 21 Aug 2008 16:41:05 +0100

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@xxxxxxxxx>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@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
>>
>>
>
>


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

Other related posts: