Restore DB After NT/Oracle Reinstall

I've seen several articles on comp.databases.oracle that talk vaguely about how to recover a database after a reinstall of NT 4.0, but none were very detailed and I'm relatively new with Oracle DBA tasks.

Here's the situation:

--NT 4.0 w/ SP 6a
--Oracle 8i v. 8.1.6 Standard Edition

The c: partition on my server died, but luckily the data was on the d: drive (as well as backed up to tape). So I had to recreate the c: partition and reinstall NT. Once the server was back up, the d: drive (the data partition) was accessible without any problems so my data files, log files, control files, and init files were intact.

I then reinstalled Oracle, but was unable to get back into my db. I read on comp.databases.oracle several messages that say you can create a fresh database and just overwrite the above mentioned files with the backups, but I wasn't sure exactly which files to move. I assume they're talking about the following:

\oracle\oradata\<db name>\control01.ctl
\oracle\oradata\<db name>\control02.ctl
\oracle\oradata\<db name>\control03.ctl
\oracle\oradata\<db name>\redo01.log
\oracle\oradata\<db name>\redo02.log
\oracle\oradata\<db name>\redo03.log
\oracle\oradata\<db name>\system01.dbf
\oracle\admin\cfs\pfile\init.ora

What about the other .ora files?:

\oracle\ora81\network\admin\listener.ora
\oracle\ora81\network\admin\sqlnet.ora
\oracle\ora81\network\admin\tnsnames.ora

Is that all I have to do? Copy over these files to the newly built database? Or is there more to it? Or am I way off base?

Thanks,

Danny Received on Mon Jun 11 2001 - 20:14:28 CEST