You can use your old files if you set the incarnation back to what it was before the resetlogs. I can't remember the correct syntax but you can look it up in the documentation. Essentially, you will redo the original restore again.
HTH, Ruth
-- --Original Message-- -- From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]On Behalf Of J. Dex Sent: Monday, November 14, 2005 1:35 PM To: oracle-l@(protected) Subject: Restore problem
I have got a database that I cloned by copying a restore and then recreating the controlfile. It started up fine. After shutting it down, somebody mucked with one of the database files at the OS level. Now, when I try to start it up, it complains about that file so I shut it down and copied once again from the original backup the file that was messed with. Is there anyway to save this database? These are the errors I am getting now.
ORA-01190 (See ORA-01190.ora-code.com) controlfile or data file string is from before the last RESETLOGS Cause: An attempt was made to use a datafile when the log reset information in the file does not match the control file. Either the datafile or the control file is a backup that was made before the most recent ALTER DATABASE OPEN RESETLOGS. Action: Restore file from a more recent backup.
ORA-01111 (See ORA-01111.ora-code.com) name for data file string is unknown - rename to correct file Cause: The datafile was missing from a CREATE CONTROLFILE command or BACKUP CONTROLFILE RECOVERY was done with a control file that was saved before the file was created. Action: Rename the MISSING file to the name of the real file.
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ __ FREE pop-up blocking with the new MSN Toolbar ? get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
