Restoring an Oracle database from files
First off, you would want to install a new instance somewhere—possibly on the same host.

Then you would need to mount the control file (the path to the control file can be specified by setting the control_files parameter value in pfile).

Once you've mounted the control file with alter database mount, you can use RMAN to identify the data (temp, undo) files' location with report schema command.

You would also need to identify the undo files' location. Use V$LOGFILE view.

If you want to move the files around before opening the database, use RENAME FILE .. TO .. clause of the ALTER DATABASE statement.

When you're done with all these tasks, you can try to open the database.

SQL&gt; alter database open;


See also.


Redo Log Data Dictionary Views
Renaming and Relocating Datafiles
Relocating and Renaming Redo Log Members