RE: Archive Logs

You should keep the archive logs dating from the last backup that you want to be able to recover from. For instance, if you keep a month-end backup, and you would like to be able to recover from the month-end backup to a given point-in-time, you need the archive logs generated during and since that month-end backup.

I recommend keeping the archive logs from at least the second-to-last backup. This way, if there was something wrong with your most recent backup, you could at least try the previous backup as well.

Other recommendations: Mirror your archivelog destination, and backup your archive logs more often. If you lose a datafile disk and the archive log disk (for example, if a controller goes bad), you will not be able to recover until point of failure. If you have several hours' or days' worth of archive logs on that disk, you will have lost all that work. I also recommend backing up archive logs to at least two different tapes. Tape media is unreliable, and archive logs are critical.

HTH,
Sara Wasserman
> -----Original Message-----
> From: Sajid Iqbal [SMTP:sajid_at_u-net.net]
> Sent: Monday, July 24, 2000 8:16 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Archive Logs
>
> 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 Mon Jul 24 2000 - 16:16:29 CDT