Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I have an instance of Oracle 10g R2 installed on Windows Server 2003. This instance was running a database which does not have any backup. Now the OS went down, could not be repaired, and all I got is the running files of the old instance.

How can I restore the database from these files to new instance?

A step-by-step guide will be much appreciated because I'm new with Oracle.

share|improve this question

2 Answers 2

It depends...

Do you have the online redo logs from the time of the OS crash? Was the database running in ARCHIVELOG mode, and if so, do you have the archived redo logs?

share|improve this answer
    
I don't think you need any archived log files in this situation, where the OS went belly up on a running instance. All you need are the database files including, as you rightly ask, the online redo logs. Hopefully the OS crash didn't corrupt any of the database files. –  DCookie Feb 8 '11 at 17:17
    
And, as the OP states, there is no backup, and therefore archived log files will be of no value. –  DCookie Feb 8 '11 at 17:49

Basically, you will have to do the following:

  1. Install Oracle (same version if possible or newer) on a new server.
  2. Create the Windows services using oradim.exe (uses the sames SID than before)
  3. Copy all the files from the old instance on the new server to the exact same locations (or recreate control files using "CREATE CONTROLFILE" and specify new locations)
  4. Cross your fingers and start the new instance.
  5. Backup your database and schedule recurring backups.

Some changes may occurs according to the configuration of the old instance (use of the archive log mode, ...)

share|improve this answer
1  
Note on step 3: Preferably, copy all database files to the same locations. If you cannot, you'll have to use the CREATE CONTROLFILE command to let the instance know where your files are. –  DCookie Feb 8 '11 at 16:02
    
@DCookie thanks for your input, I edit my answer according to your comment. –  Benoit Feb 8 '11 at 16:21
    
No problem. I did edit to clarify that you need to put the files in the same locations or else you must recreate the control file. –  DCookie Feb 8 '11 at 17:15

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.