Re: Recovery Manager and Archive Log Files

Thanks for the replies.

I am currently doing an "archivelog all delete input" when backing up the archives. The problem is that it falls over when it finds the first archive missing. Looking through the docs, I guess I could just do a "archivelog from time .. delete input" to correspond to the archives I still have on disk. Then in future backups just do a "archivelog all delete input". Does this sound feasible? I guess I could just try it and see what happens.

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:<3BE6D4C4.979_at_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
Received on Tue Nov 06 2001 - 03:42:46 CST