Re: erasing Archive log

We keep 9 days worth of Archive Redo Logs. However due to a dodgy old tape device, am running out of tape during about 50% of backups (depending on how much redo is generated per day). It's not a huge problem as it is only the final directory being backed up which fails, and is an os (we're running Solaris 2.6) file rather than anything to do with Oracle.

However I have been zipping up to 7 days worth of redo prior to backing up which reduces space per log by up to 80% (5M to 1M).

Howard J. Rogers <howardjr_at_www.com> wrote in message news: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 Sun Sep 17 2000 - 02:58:20 CDT