Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Can't open database
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
-- 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