Re: RMAN archivelog backup fails

"Rudi" <rschoebel_at_hotmail.com> wrote in message news:ab7018a4.0306271922.309bf8b2_at_posting.google.com...
> I'm scheduling backups using RMAN 8.1.7 in nocatalog mode to backup a
> database and its associated archived logs. The database backup
> completes and then validates sucessfully, however the archive log
> backup fails with ORA-19599: block number xxx is corrupt in archived
> log yyy. Consequently my archived logs quickly fill up the disc and I
> have to manually intervene, a little to frequently for my liking.
>
> I can ignore datafile block corruption errors using the NOCHECKSUM
> option or "set maxcorrupt for datafile "xxx" to y" but can't find any
> references in the rman manual (or others) to ignoring corrupt blocks
> in archived logs. The NOCHECKSUM option is permitted in the backup
> script but fails to prevent the error and the backup still fails. And
> I can't fool RMAN into treating the archived logs like datafiles and
> using set maxcorrupt.
>
> My database has both LOG_BLOCK_CHECKSUM and DB_BLOCK_CHECKSUM set to
> their default false value. While I'd like to find out why the archive
> logs are corrupt (maybe one per day out of 1GB of logs) my more
> immediate concern is to get rman backups automatically clearing disc
> space nightly.
>

Of course there is no provision for ignoring corruption in archivelogs! They are what's needed to make a backup useable. If a datafile backup has corruption, you can always use the night before last's to do the restore. But if you've got corrupt redo, then no backup can be made useable.

As to the business about 'my more immediate concern is to ... clear the disk space nightly'... what an odd set of priorities you have!

If I were you, I"d be more than merely curious about why your archives are being corrupted once a day: I'd put a stop to it immediately. Without archives, you are lost. With corrupt archives, you are lost. Get it sorted!!! (And I suspect that means: buy some new hardware).

~QM

> Any suggestions as to where to look or what to do would be much
> appreciated.
Received on Fri Jun 27 2003 - 23:36:39 CDT