Re: URGENT! Need help recovering old datafile into new database after disastrous crash

IF your database failed due to a media failure. You CANNOT simply recover the failed disk and try to recover the database to the point of failure and upgrade your database at the same time!!! If you have not upgrade your database, I believe there is still way to recover your database to the point of failure. But if you have already upgraded your database. I believe you have to recover your database to the last cold backup that you have. Move all the datafiles, controlfiles and redo log files from the last cold backup to it's orginal location. (you can change the location of the controlfiles)

Use the oracle installer under $ORACLE_HOME/bin to update the database object to the correct version. Run the installer under your new 7.3.3 version and then choose the upgrade existing database object option.

I believe you can use back the datafiles, controlfiles and the redo log files. Only remember to put the init.ora file to the $ORACLE_HOME/dbs directory and edit it accordingly so that it is point to a new controlfile and online redo log file. Then update your database object.

ALso, if you don't want to use the installer, you can run three scripts: CAT7303.SQL, CATALOG.SQL and CATPROC.SQL to update the system dictionary and objects.

Eric A. Litman wrote in message <6scij0$doc$1_at_news.dn.net>...
>
>Greetings,
>
>I had a media failure on a disk holding both binaries and datafiles for an
>Oracle 7.3.2 database. I brought the drive to Ontrack for recovery (1GB
>drive recovered on a Saturday=$4,500) and once again have the database and
>control files for the database. Unfortunately, I no longer posess the media
>for Oracle 7.3.2, and have instead installed 7.3.3.
>
>My questions are as follows:
>
>1. I have all the dbf, ctl, and log files from the earlier installation.
>What do I need to do to get my data out of these? Should I be able to do
>this?
>
>2. I tried rm'ing all of the ctl,dbf, and log files for the newly installed
>database, and put in their place all of the files from the previous
>database. When I tried to open the database, I saw a version
 incompatibility
>issue which did not relate to the version numbers I am dealing with (7.3.2
>and 7.3.3):
>
> ORA-00402: database changes by release 7.1.0.0.0 cannot be used by
>release 7.0.12.0.0
> ORA-00405: compatibility type "Undo contents"
>
>Obviously, I'm missing something (my guess is that this is not the correct
>procedure).
>
>Thanks for any help you can offer.
>
>Eric Litman
>
>
Received on Mon Aug 31 1998 - 00:00:00 CDT