RE: Online redolog corrupt

Hi

If u enable redo_block_checksum, oracle computes a checksum for each log block written to the current log & it is written in the header of the block. Checksum is used to detect the corruption in the redo block. It verifies the log block when it writes to the archive & when the block is read from an archived log during recovery.

If oracle found any corruption in a log block while archiving, it will use the other member of the group. If the entire group is corrupted, then the archiving will be stopped & the system will halt.

Gokul Prasad
email: gokul.prasad_at_almarai.com

> -----Original Message-----
> From: VIVEK_SHARMA [SMTP:vivek_sharma_at_inf.com]
> Sent: Monday, July 17, 2000 10:24 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Online redolog corrupt
>
>
> LOG_BLOCK_CHECKSUM = TRUE
> More Detail on this please , funtionality , advantages , performance
> overhead ?
>
>
> > -----Original Message-----
> > From: Oak, Sameer [SMTP:soak_at_ziptone.com]
> > Sent: Thursday, July 13, 2000 1:26 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Online redolog corrupt
> >
> > I agree to David.
> >
> > But if you do not want cancel based recovery (Do not wish to loose any
> > data)
> > then I think having a LOG_BLOCK_CHECKSUM = TRUE will be helpful.
> > I don't exactly remember what error u might get in Alert Log.
> > But after all online log's are full database will halt. U can manually
> > clear
> > online log which is corrupt & take backup .
> >
> > Any way best way to have is LOG_BLOCK_CHECKSUM = TRUE & mirrored LOG
> > files.
> >
> > Gurus pl correct me if I am wrong.
> >
> > $ameer
> >
> >
> > -----Original Message-----
> > Sent: Wednesday, July 12, 2000 6:54 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi all,
> > I am asking this ques. only for my info.
> > Suppose my online redolog corrupt then ,what will be
> > the message given by database and what action should
> > be taken at this condition.
> >
> > My Oracle version is oracle 8i..
> > Database is running in archivelog mode.....
> > I doesn't have any mirror of redolog files.......
> >
> > Thanks and Regards
> > -- Vijay Patidar
> >
> >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Get Yahoo! Mail - Free email you can access from anywhere!
> > http://mail.yahoo.com/
> > --
> > Author: Vijay Patidar
> > INET: vpatidar_2000_at_yahoo.com
> >
> > 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).
> > --
> > Author: Oak, Sameer
> > INET: soak_at_ziptone.com
> >
> > 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).
> --
> Author: VIVEK_SHARMA
> INET: vivek_sharma_at_inf.com
>
> 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
Received on Mon Jul 17 2000 - 02:36:00 CDT