Re: Archive Logs

When backup starts, I perform a log-switch, and copy all archive log-files to a 'yesterday' directory.
After the HOT-backup is completed, I perform another log-switch, and backup all archive-logs to tape as well.
Next day the 'yesterday' directory is cleaned, and the process starts again. The archive log-directory is on a seperate disk on a little-used controller. This way I'm independent of disk-storage from other applications. The database really stops on archive-disk full!

Eric Lansu

• Original Message ----- From: "bharanidharan" <t.bharanidharan_at_tatainfotech.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, 25 July 2000 07:58 Subject: Re: Archive Logs

> hi,
> These archive log files are useful to recover the data inbetween a cold
> or a hot backup. i.e. data lost inbetween backups and if it is not stored
> anywhere. also if u r regularly taking any one of these backup then
there
> is no need for the prevoius archive logs. Archvie logs file destination
> should not be full, b'cos ur entire database hangs since it cannot write
> into it.
> rgds
> bharanidharan
>
> Sajid Iqbal wrote:
>
> > Hello All
> >
> > Our 24x7 database is in archive log mode, we do online backups to tape
> > every other day..
> >
> > However the archive logs (which there are a lot of) we only back them up
> > when the destination dir is almost full.
> >
> > My question is how often should we backup these archive logs.. also how
> > long to keep these archive logs on tape.. before they are of no use ?
> >
> > Regards
> >
> > Saj Iqbal
> >
> > --
> > U-NET Ltd a VIA NET.WORKS Inc company
> > Sajid Iqbal | Mail : sajid_at_u-net.net
> > Database DBA/Developer | Ext : 4485
> > U-NET Ltd | ICQ : 43903417
> > Warrington, Cheshire, UK |
> >
> > --
> > Author: Sajid Iqbal
Received on Tue Jul 25 2000 - 02:08:33 CDT