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: Can't open database

RE: Can't open database

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Tue, 13 Jul 2004 10:55:17 -0400
Message-ID: <003001c468e9$694bcae0$8459699f@vttaxnet.tax.state.vt.us>


If you finally get the db open, make a complete backup and then export the data, rebuild the database, and import it into the newly created database. This will get you around any Oracle support problems you might run into by using the unsupported parameters.

Good luck!
Ruth

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Satheesh Babu.S Sent: Tuesday, July 13, 2004 10:35 AM
To: oracle-l_at_freelists.org
Subject: RE: Can't open database

He has already tried some hidden parameters. So i suggested him to try this also. Any way word of disclaimer would have been better.

Thanks and Regards,
Satheesh Babu.S
Bangalore.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jared Still Sent: Tuesday, July 13, 2004 8:02 PM
To: Oracle-L Freelists
Subject: RE: Can't open database

On Tue, 2004-07-13 at 03:27, Satheesh.Babu_at_iflexsolutions.com wrote:
> Have u used _allow_resetlogs_corruption?
> If not,
> Set _allow_resetlogs_corruption=3Dtrue in init.ora
> Startup mount;
> Recover database;
> Alter database open;
>

Of course, this advice should come with the disclaimer that this action should be performed under the supervision of Oracle Tech Support. That is, if you expect any support from them on the database.

Also, your data could very well be in an inconsistent state.

Jared



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
-----------------------------------------------------------------

----------------------------------------------------------------
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 Tue Jul 13 2004 - 09:52:51 CDT

Original text of this message

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