Problem solve Get help with specific problems with your technologies, process and projects.

Reinstalled NT but lost Oracle 8

I have an Oracle 8 database installed on an NT 4 machine. Oracle setup was not at all proper--some tables were lying in system table space and some were in another table space with different datafiles.

One fine day my NT server was crashed, so I installed NT again but found that Oracle is not working, giving me the error of SGA.

I tried to install Oracle on a different computer and copied the datafiles to that computer, but that also failed.

Now I have all of my datafiles with me. Can I create a new database with the existing datafiles? Please let me know.

Since you had to reinstall your operating system, you'll likely have to reinstall the Oracle software. This is especially true of Windows OS platforms where Oracle stores a bunch of information in the Registry. This was likely wiped out when you reinstalled the OS. The only way to put the registry keys back in there for Oracle is reinstall the database (or recover from a backup).

Before you proceed, back up those datafiles!!!

After you've reinstalled the Oracle RDBMS software, you should be able to reuse your old datafiles for your database. Use the ORADIM utility to recreate the services you'll need for the database, copy the datafiles back to their original location, then startup the Oracle Services. This should restore your database.

Now after you've gone through all this mess, please be certain to implement and test a sound backup and recovery procedure so that you don't have to jump through these hoops in the future! And part of a sound backup and recovery procedure takes into account the OS as well as the database.

For More Information

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.