Re: erasing Archive log

I couldn't agree more. Jerry, are you reading this?

Howard J. Rogers wrote in message <39c0a8fd$1_at_news.iprimus.com.au>...
>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
>> > >
>> >
>> >
>>
>>
>
>
Received on Fri Sep 15 2000 - 10:22:55 CDT