-
out of 4 datafiles d1,d2,d3,d4 , one corrupted (d1).
I want to recover d1.
I have a backup of last night only.
I restore from last night backup (not cuurent).
Three data files are current and d1 is from last night.
now I want to recover this data file to current , I have all redo logs.
I try follwoing
shutdown normal;
startup mount
recover datafile '/x/y/d1.dbf' (not working)
recover tablespce d1 ( not working)
recover database ( not working)
recover database until cancel (not working)
All the time it give me message
ORA-00283: recovery session canceled due to errors
ORA-01190: controlfile or data file 12 is from before the last RESETLOGS
ORA-01110: data file 12: '/x/y/d1.dbf'
-
Error: ORA 1190
Text: control file or datafile is from before the last RESETLOGS
-------------------------------------------------------------------------------
Cause: An attempt was made to perform media recovery when the redo log reset
information in a datafile does not match the control file.
Either the datafile or the control file must be a backup that was made
before the most recent ALTER DATABASE OPEN RESETLOGS.
Action: Restore the file from a more recent backup.
You can't apply the recovery from archived redo logs and SCNs are not compatible as the database opened with RESETLOGS option after backup taken.
-
This is an important rule:
ALWAYS AFTER DOING AN ALTER DATABASE OPEN RESETLOGS, TAKE A BACKUP OF YOUR DB.
Cheers
Angel
