Kevin,
You can do 2 things to find out the locations of the database files.
1) open one of the control files using vi and search for "log", "ctl"
and "dbf" and note down the file names.
2) start a dummy instance and mount the controlfile on to it.
then you can get the names of all datafiles (V$DATAFILE), logfiles
(V$LOGFILE) and their locations.
But even if you restore them, you will be able to recover the database
only if the backup was done properly (i.e. backed up after placing the
tablespaces in backup mode).
regards
Srivenu
Received on Tue Mar 30 2004 - 23:50:52 CST
