Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: RMAN archivelog backup fails

Re: RMAN archivelog backup fails

From: Rudi <rschoebel_at_hotmail.com>
Date: 27 Jun 2003 20:50:25 -0700
Message-ID: <ab7018a4.0306271950.956e67b@posting.google.com>


I'll give that a try but I'm not sure whether it will be much different. Currently duplicates of the online redo logs and control files, database backups and database exports exist on the same physical drive with no apparant problems ie. the backups validate successfully, the export can be successfully imported to another database and there is no indication of problems with the online redo logs or control files. The drive is relitively new and scans return with no errors. I'm thinking its more a problem specific to the archivelogs.

Thanks for your reply and suggestion, any more ideas you may have on the matter would be appreciated.

skapitza_at_volcanomail.com (s.kapitza) wrote in message news:<26703915.0306270718.23415a2b_at_posting.google.com>...
> what about setting the arc destination to a more reliable subsystem ?
>
> regards
>
> s.kapitza
>
> rschoebel_at_hotmail.com (Rudi) wrote in message news:<ab7018a4.0306261456.51559ce_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.
> >
> > Any suggestions as to where to look or what to do would be much
> > appreciated.
Received on Fri Jun 27 2003 - 22:50:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US