Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN error - archived log not found

Re: RMAN error - archived log not found

From: Steve Bourgeois <sb299_at_netzero.net>
Date: Wed, 17 Oct 2001 17:37:33 GMT
Message-ID: <xljz7.129571$vq.28384701@typhoon.ne.mediaone.net>

DJ,

You've got the right idea. The "change archivelog all validate" command will cause rman to validate all archived redo logs found on disk.

I use the code snippet below for the same purpose:

run {

    # Update catalog to current state
    resync catalog;

    # Validate archived redo log files on disk     change archivelog all validate;
}

Steve

"DJ" <dj18_at_alive95.net> wrote in message news:14f5bc45.0110170754.8ba08e1_at_posting.google.com...
> We run RMAN with a nocatalog option, Oracle version 8.0.6. We
> inadvertantly deleted some archive logs. Now my backup script won't
> run. The script backs up the archive logs and then executes
> archivelog all delete input. Since the logs got deleted, the backup
> of our logs is erroring out, so none are getting deleted. My
> filesystem will fill up tomorrow. I am very new to Oracle and am
> unsure as to what to do. I have researched and found this command:
>
> change archivelog all validate;
>
> Will this fix it or make it worse? Can anyone tell me what this would
> do? Or tell me how I can get it to "forget about" the missing archive
> logs.
>
> Thanks in advance,
> DJ
Received on Wed Oct 17 2001 - 12:37:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US