Oracle DBA, How To, Error, Cause and Action

ORA-01190: control file or data file string is from before the lastRESETLOGS

ORA-01190: control file or data file string is from before the last RESETLOGS




Cause: Attempting to use a data file when the log reset information in the file does not match the control file. Either the data file 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.