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
> INET: sajid_at_u-net.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jul 25 2000 - 00:06:13 CDT