Re: The strange case of the missing archived log

From: Howard Latham <howard.latham_at_gmail.com>
Date: Thu, 21 Aug 2008 16:36:43 +0100
Message-ID: <713d96d10808210836l53dc5351ne09710a86dd9e1d5@mail.gmail.com>


Thanks Mark thats the Answer!

On 21/08/2008, Mark W. Farnham <mwf_at_rsiz.com> wrote:
>
> Was the missing archived file one of the ones that was moved that
> shouldn't have been moved?
>
>
>
> Was it the one that was in the process of being archived when the archiver
> got stuck? Then the archiver still had it open, and the mv command moved the
> inode, but I don't think it will appear there until the archiver closes it.
> If the file is not in the place they moved the archive logs to, possibly
> archiver's close failed, so it still appears nowhere. Stopping and
> restarting the archiver process should make it appear in the mv
> destination file system I think.
>
>
>
> Lot's of suppositions in there, but stopping the archiver and restarting
> it shouldn't be too big a deal.
>
>
>
> Another diagnostic to look for a file not appearing in the ls results is to
> do a du and subtract that from the capacity.
>
>
>
> All this could be wrong, but none of it should hurt anything and it is
> cheap to try.
>
>
>
> Good luck,
>
>
>
> mwf
>
>
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Howard Latham
> *Sent:* Thursday, August 21, 2008 10:55 AM
> *To:* oracle-l
> *Subject:* The strange case of the missing archived log
>
>
>
> 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
>
>

-- 
Howard A. Latham

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

Original text of this message