Re: erasing Archive log

Rubbish.

Consider a true story (and we won't mention the name of the DBA concerned. Blush).

Entire share/member register of a company wishing to de-mutualise goes awol as a result of a head crash on a hard disk.

No problems. Just restore from last night's backup. Except a touch of nerves has set in so plonker DBA retrieves all-important tape from tape cabinet, drops it, and sees it scatter in a thousand pieces across the Server Room floor. Oops.

No problem. The previous night's backup tapes are still in one piece. Grab one of those, install (carefully!) in tape machine and.... bloody hell! The backup that night didn't succeed for some obscure reason... and that will teach me -er, I mean, the DBA, er- to check the backup logs each morning!

So, try the three nights old tape.... whoa! success!!!

Moral: if you are too keen on deleting old archives, you will find yourself in deep doo-doo before very long. Make allowances for human clumsiness and human slackness, and all will be well.

I personally recommend keeping at least a week's-worth of archive on disk before archiving onto tape (and I have a tape rotation cycle that keeps stuff for at least 5 weeks). But then I do have shares in Seagate.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



"Frank an der Heiden" <fh_at_energotec.de> wrote in message
news:8pmdr5$rh1$1_at_oxygen.technet.net...


>

> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> schrieb im Newsbeitrag

> news:968599118.10796.1.pluto.d4ee154e_at_news.demon.nl...

> > You can erase your archive logs as soon as

> > - you have a backup of them

> > or

> > - they are older than your last consistent backup (the database should

 be


> > down for this).

> >

>

> The only situation, in which you need your archiv-logs, AFTER a

> successful online-backup is the situation, that you want to use an OLDER

> backup in order to recover your database to a point of time in the past,

> maybe because you dropped an important tabel and want to get these datas

> back.

>

> > Could you please avoid posting such typical .server questions to *all*

> > Oracle newsgroups in the future?

> >

> > Hth,

> >

> > Sybrand Bakker, Oracle DBA

> >

> > "Serge Nantel" <snantel_at_sympatico.ca> wrote in message

> > news:39BB8A70.5C5845F7_at_sympatico.ca...

> > > Hi,

> > >

> > > I want to erase archive log do I have to do some thing special before?

> > > or I can erase the archive log whiteout problem.

> > >

> > > Thank you kindly

> > > snantel_at_sympatico.ca

> > >

> >

> >

>

>