I assume that since the "data is not important," you do not have a backup of the database. But you are now attempting to restore that data, so it must be important to you, otherwise, you would just start from scratch. If our next steps work, then you should implement a solid backup and recovery routine to protect your data. You can always reinstall and reconfigure software, but in most cases, it is impossible to get your data back without good backups.
If you have access to the old disk drive(s) of the Windows server, you may be able to get your data back, but there is a risk this procedure will fail, in which case you are out of luck.
On the disk drive, look for the database datafiles, the control files and the online redo logs. Typically, these files are in a default location. Look for a file similarly called "system01.dbf" (the SYSTEM tablespace), "control01.ctl" (one of the control files) and "redo01.log" (one of the online redo logs). You will find other files in this directory too. Copy these files somewhere safe as this is the only copy of your database.
On your rebuilt Windows server, create an empty database. Give the database the same name that your old database was called. Use the same exact directory structure you previously used. Once the database has been created, shut it down. Overwrite the new database with your old database files. Windows will now think that this is the database that you just created. Start up the database. When your server crashed, the files were left in an inconsistent state. When you start the database, Oracle will recognize this and automatically use the information in the online redo logs to restore the database to the last good consistent state before the crash. This is called crash recovery. If this all works, and you can open your database for business, shut it down immediately and take a good backup!!! Your data appears to be more important than initially presumed, so a good backup and recovery strategy is vital.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.