I have an instance running on 9.2, of which the UNDO tablespace has been lost when a drive crashed. I have been able to recover the rest of the database files and have copied them over the top of the "default database" files set up on installation, hoping to allow them to be used with a new installation of 9.2. Having also copied the SPFILE and the PWD files over the top of the default ones, all is fine when starting (START and MOUNT are OK) until I get errors showing that the UNDOTBS01 file is (correctly) not part of the database:
ORA-01122: database file failed verification check
ORA-01110: data file 2 D:\Data\Oracle\JohnG\UNDOTBS1.DBF
ORA-1206: file is not part of this database - wrong database ID
and the database is not OPENed.
Is there any way in which I can work around this for long enough to start the instance? Obviously until I can, I can't create a new UNDO tablespace, or anything... Failing that, is there any way that I can extract any information from the "old" Oracle database at a command-line level, to allow me to import it into the "new" one (given that I have all of the files apart from the UNDOTBS01)?