Re: deleting archived redo logs after rman backup

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 17 Mar 2005 10:04:04 -0800
Message-ID: <1111082440.277349@yasure>

Joel Garry wrote:

> 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

The point I was trying to make is that "if" you know what you have on tape or backup disk is valid ... deleting the ones on the server can be done at any point.

If you don't have confidence you can recover, not matter what your situation, deleting them has risks.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Thu Mar 17 2005 - 12:04:04 CST