| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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 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 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.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 14 2005 - 12:37:41 CST
 |
 |