Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> URGENT! Need help recovering old datafile into new database after disastrous crash

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

From: Eric A. Litman <elitman+oracle_at_viaduct.com>
Date: 1998/08/30
Message-ID: <6scij0$doc$1@news.dn.net>#1/1

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 Sun Aug 30 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US