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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Online redolog corrupt

RE: Online redolog corrupt

From: VIVEK_SHARMA <vivek_sharma_at_inf.com>
Date: Mon, 17 Jul 2000 11:44:19 +0530
Message-Id: <10560.112146@fatcity.com>


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
Received on Mon Jul 17 2000 - 01:14:19 CDT

Original text of this message

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