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: Recovery Manager and Archive Log Files

Re: Recovery Manager and Archive Log Files

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 05 Nov 2001 18:04:52 +0000
Message-ID: <3BE6D4C4.979@yahoo.com>


Howard J. Rogers wrote:
>
> Yes. You can ask RMAN to backup the archives "delete input all" -at which
> point*it* deletes the archives, not you... and if it does the deleting, it
> won't expect them to be there the next time.
> HJR
> --
>
> Oracle Resources : http://www.hjrdba.com
> =============================
>
> "Colin" <colinwinning_at_yahoo.com> wrote in message
> news:8181cd1e.0111050851.510f45f6_at_posting.google.com...
> > Hi All,
> >
> > I am currently in the process of implementing a backup startegy using
> rman.
> > Oracle version is 8.1.5 and I am using a recovery catalog.
> >
> > I can get the datafiles and control files backed up successfully doing a
> full
> > database backup but I run into problems when backing up the archived log
> files.
> >
> > The archived log files (from the previous months) have been backed up on
> to tape
> > using Backup Exec and then deleted, so I only have the last couple of
> weeks
> > archived log files on disk. Recovery manager obviously knows about all of
> the
> > archived log files and falls over when trying to back them up because they
> no
> > longer exist on disk. Is it possible to stop rman from trying to back up
> these
> > archived log files and only backup those that still exist? And if so, what
> are
> > the implications for restoring at a later date?
> >
> > Thanks in advance
> > Colin

Colin,

There is a command (differs across rman versions) which makes rman re-sync what archives *it* thinks you have, and what you have ("validate" or "crosscheck" - can't remember off hand)

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
Received on Mon Nov 05 2001 - 12:04:52 CST

Original text of this message

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