Database – How to mount an Oracle database to new instance

databaseoraclewindows-server-2003

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.

Best Answer

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, ...)

Related Topic