REPOST: Re: Deleting Archived Redo Logs

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 1 Jan 2002 07:44:46 +1100
Message-ID: <0$--$$-$-%_$$_$--$@news.noc.cabal.int>

Judging by your sig, you can answer your own question.

There's no *technical* reason for retaining archives from prior to a successful backup. But paranoia (and plain commonsense) suggests that the unexpected can happen -in one case of my own experience, what should have been a simple restore job from the previous night's backup turned into a nightmare of having to restore from *three* backups ago -which couldn't have worked if I'd been too eager to delete archives.

Regards
HJR "dsmcd" <dsmcd_at_uswestmail.net> wrote in message news:Py%X7.9$EE.121608_at_news.uswest.net...
> Hello...
>
> Is there *ANY* reason for keeping archived redo logs older than the last
good
> cold backup?
>
> Actually, I'm thinking of a script to delete logs older than two weeks,
even
> though we cold backup nightly.
>
> Thx,
> D. (the paranoid) McD.
>
>
>

WAS CANCELLED BY =======: Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!fr.clara.net!heighliner.fr.clara.net!newsgate.cistron.nl!news2.euro.net!uunet!sac.uu.net!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r From: "Howard J. Rogers" <dba_at_hjrdba.com> Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.server Subject: cmsg cancel <3c30cd84$0$5405$afc38c87_at_news.optusnet.com.au> Control: cancel <3c30cd84$0$5405$afc38c87_at_news.optusnet.com.au> Date: Wed, 2 Jan 2002 02:41:34 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.3c30cd84$0$5405$afc38c87_at_news.optusnet.com.au> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009944338 21023 166.102.15.34 (2 Jan 2002 04:05:38 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 2 Jan 2002 04:05:38 GMT X-No-Archive: yes Comment: Dude, where's my NewsAgent? Xref: news.uni-stuttgart.de control:40278054

autocancel Received on Mon Dec 31 2001 - 14:44:46 CST