Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to manually delete a corrupted database instance

833255Feb 2 2011 — edited Feb 2 2011
I have a corrupted instance in my database which prevents me from starting up the other instances.
This is a followup from another post, in which the goal was to fix all the instances. Now I would like to at least save my working databases and get rid of the bad one.

The corrupted instance doesn't have spfile, window service, I cannot login as sysdba. When I try to start up the databas I get an error message about spfile not existing for the corrupted instance. I tried to follow hints to fix that, but it didn't work so far. Maybe I can remove everything related to the broken instance, including directories, registry entries, and whatever else is making Oracle care about this instance?

This is on Windows 7, Oracle 10g.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2011
Added on Feb 2 2011
4 comments
1,578 views