Re: deleting archived redo logs after rman backup

Verbs Under My Gel wrote:
> DA Morgan wrote:
> > Verbs Under My Gel wrote:
> >
> > > I currently have Oracle 9i (9.2.0.1.0) primary and
physical-standby
> > > databases. I do a full backup plus archived logs on the primary
> server
> > > nightly, and would like to know how to determine if it's safe to
> delete
> > > the backed-up archived logs.
> > >
> > > In other words, how can I easily make sure FAL_CLIENT isn't going
> to
> > > request a log that I've deleted?
> > >
> > > Also, I'd like to start backing up the physical standby database
as
> > > well. How do I delete only the archived logs on the standby
server
> > > that have been applied and backed-up?
> > >
> > > Thanks so much!
> >
> > When from time-to-time you test your backup on another machine and
> you
> > have, from that experience, confidence that they are usable.
> > --
> > Daniel A. Morgan
> > University of Washington
> > damorgan_at_x.washington.edu
> > (replace 'x' with 'u' to respond)
>
> Thanks for your reply, but my question was not about the validity of
my
> backups, but about how you determine which archived logs are safe to
> delete. I guess I need to query the v$archived_log view on the
standby
> to see what logs have been applied, unless there's a way to do it
from
> the primary.

You should not delete the archiveds just because they have been applied, but at least wait until you know they have been applied correctly. Opening the standby is a fairly good indicator. I've heard tell of places (that have been burned by no indication of things potentially not working) opening their standby every hour.

jg

--
@home.com is bogus.
http://www.tomsnetworking.com/Sections-article106.php