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: bug 2322620

Re: bug 2322620

From: <Rhojel_Echano_at_sgs.com>
Date: Thu, 27 May 2004 14:40:48 +0800
Message-ID: <OF861EC0C3.436F3C05-ON48256EA1.0024A1A0-48256EA1.002499BA@sgs.com>


Thanks a lot Mr. Lewis.
Best regards,
Rhojel Echano

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> Sent by: oracle-l-bounce_at_freelists.org
05/27/2004 02:02 PM
Please respond to oracle-l  

        To:     <oracle-l_at_freelists.org>
        cc: 
        Subject:        Re: bug 2322620



I haven't any information about the parameter and its use, but here's the name and description of the one that looks the most obvious:

_corrupt_blocks_on_stuck_recovery

        number of times to corrupt a block when media recovery stuck

There's a script on the website or FAQ below for listing the hidden parameters.

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated May 1st

Hi everyone,
Anybody encountered bug 2322620? It manifests as a "Stuck Recovery" situation and according to Oracle support, the only workaround is to allow Oracle to corrupt a block on recovery. In my case, an LOB segment is causing this.
When the archived logs are being applied to Standby DB and changes on an LOB segment are present in the log, the recovery session halts with Ora600.

Here's an excerpt of the bug's text from Metalink:

"For Oracle 8 and Oracle 8i, there is also a hidden init.ora parameter that one can set to tell Oracle to corrupt the block and continue. Contact Oracle Support if you need to use this method. "

If anyone can tell me this parameter, then I'll be very glad to be relieved
from the burden of waiting for Oracle support response.

TIA,
Rhojel Echano



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Thu May 27 2004 - 01:38:11 CDT

Original text of this message

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