Home / server / Questions / 232503
In Process
Vimvq1987
Asked: 2011-02-08 21:38:48 +0800 CST

How to mount an Oracle database to new instance?

  • 772

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.

windows-server-2003 database oracle

2 Answers

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

    • 3

  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?

    • 1