Restore DB After NT/Oracle Reinstall
Date: 11 Jun 2001 11:14:28 -0700
Message-ID: <3d64ad76.0106111014.62f174c8_at_posting.google.com>
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.
--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.
\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