Re: deleting archived redo logs after rman backup

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. Received on Mon Mar 14 2005 - 19:59:45 CST