Re: Using backup files with new DB

[snip]
> Wolf, when you say you have all files, do you have some called init*,
> spfile*, orapw*, system*, undo* and control* files? What exact version
> of Oracle are these files? What platform are you on? Do you have
> archived logs? Can you give more background of your situation? Do you
> know where the files were last used, are they proper backup copies or
> from a cleanly shutdown system? Do you have Oracle support? Have you
> worked with Oracle before?
>

The OS is Linux, kernel 2.4.33, with Oracle9i, Rel-9.2.01. The device (/dev/hda), with oracle SW, root etc., crashed. The oracle datafiles were placed on other devices.

The following files were rescued:

control0[1-3].ctl
drsys01.dbf
example01.dbf
indx01.dbf
system01.dbf
temp01.dbf
tools01.dbf
undotbs01.dbf
users01.dbf

The datafile users01.dbf contains the data i'd like to recover.

Unfortunately, all oracle config and setup files line were placed on the crashed device, so thy are not available anymore. The datafile users01.dbf was placed in one of /disk[1-3]/oradata/SID. The othere I just can guess.

No archived logs were saved and no oracle support. Using oracle's OCI C-Interface since ora6.

Wolf Received on Wed Nov 15 2006 - 06:28:47 CST