Sir, 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
- What do you think about this answer? E-mail us at editor@searchDatabase.com with your feedback.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle tip to offer your fellow DBA's and developers? The best tips submitted will receive a cool prize--submit your tip today!
- Ask your technical Oracle questions--or help out your peers by answering them--in our live discussion forums.
- Ask the Experts yourself: Our Oracle guru is waiting to answer your toughest questions.
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.