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: deleting archived redo logs after rman backup

Re: deleting archived redo logs after rman backup

From: Joel Garry <joel-garry_at_home.com>
Date: 17 Mar 2005 16:57:01 -0800
Message-ID: <1111107421.182884.187550@l41g2000cwc.googlegroups.com>


>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.

I agree, except to point out, how do you know it is valid? <rant> I have a dim view of modern hardware, as you might notice. I always thought that hardware would evolve to be as solid as the telephone - and now, not only has that not happened, but telephones have devolved (in reliability). Harumph. </rant>

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

I'd go beyond that, since I've seen RMAN be more than a little confused about how old stuff has to be. But then again, you use more modern stuff than I. Even so, I've still found practical value in having a fairly large lag time when deleting arcs, you just never know what will be thrown at you. Any time you move or copy something, there's risk - that's why so much PC software gets corrupted, copying stuff back and forth unnecessarily - and I've seen situations where a standby gets hosed, not having to get the arcs and maybe a backup off the tape which turns out to be also hosed, is a Good Thing (TM).

The real important point is that redundancy is not to be minimized!

jg

--
@home.com is bogus.
An egg, a colonel and a chicken walked into a bar:
http://asktom.oracle.com/pls/ask/f?p=4950:8:7967215895365162726::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:35336203098853
Received on Thu Mar 17 2005 - 18:57:01 CST

Original text of this message

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