Database Recovery Question

System Details: Windows XP Professional, 2 GB RAM, Oracle 10.2.0.1

1. Had to do a Recovery of my laptop. It moved the entire contents of my disk to a backup directory but when it restored Windows XP it DIDN'T restore applications I had installed.

So, even though my backup directory has all the Oracle executables as well as all my Oracle database data, control, redo and sp files my actual "live" laptop didn't have Oracle until I reinstalled it.

 Need to get the new Oracle instance (DES) to be able to access the old Oracle instance's (DES) database files.

2. Under the "c:\My Backup -- 03-08-07 0541" directory in the following subdirectories I have:

 c:\oracle\product\10.2.0\admin\des\pfile\init.ora.562007203121

 c:\oracle\product\10.2.0\db_1\dbs\spfiledes

 control files in:

  c:\oradata\admin\control\des\ctl01\control01.ctl
  c:\oradata\admin\control\des\ctl02\control02.ctl
  c:\oradata\admin\control\des\ctl03\control03.ctl

 redo log files in:
  c:\oradata\admin\redo\des\redo01\redo01_01.log

\redo02_01.log
\redo03_01.log

  c:\oradata\admin\redo\des\redo02\redo01_02.log

\redo02_02.log
\redo02_03.log

  c:\oradata\admin\redo\des\redo03\redo01_03.log

\redo02_03.log
\redo03_03.log

 system database files in:
  c:\oradata\db\des

 application database files in:
  c:\oradata\db\des\data
  c:\oradata\db\des\index

3. On my C: drive in the "recovered" laptop I created another database with the DES name with the following directories:

 c:\oracle\product\10.2.0\admin\des\pfile\init.ora.74200716939

 c:\oracle\product\10.2.0\db_1\dbs\spfiledes

 control files in:

  c:\oradata\admin\control\des\ctl01\control01.ctl
  c:\oradata\admin\control\des\ctl02\control02.ctl
  c:\oradata\admin\control\des\ctl03\control03.ctl

 redo log files in:
  c:\oradata\admin\redo\des\redo01\redo01_01.log

\redo02_01.log
\redo03_01.log

  c:\oradata\admin\redo\des\redo02\redo01_02.log

\redo02_02.log
\redo02_03.log

  c:\oradata\admin\redo\des\redo03\redo01_03.log

\redo02_03.log
\redo03_03.log

 system database files in:
  c:\oradata\db\des

 application database files in:
  c:\oradata\db\des\data
  c:\oradata\db\des\index

4. Will it be possible for me to shutdown the current DES instance, copy the database files, control and redo log files along with the init.ora and spfile and then restart the new DES instance and have it recognize the "new" datafiles? Will just copying the ora.init file suffice or would I have to rename my old one to the new one's name?

I've been using this to practice with Oracle and have no real desire to start from scratch if I don't have to. If this IS possible it would also be a good exercise for me. But before I start something that can't be done I just thought I'd post here to see if it can be done and if there is anything I'm missing.

Thanks. Received on Sat Aug 04 2007 - 17:56:22 CDT