ORA-01209: data file is from before the last RESETLOGS



ORA-01209: data file is from before the last RESETLOGS..

Answer / guest

Cause: The reset log data in the file header does not match
the control file. If the database is closed or the file is
offline, the backup is old because it was taken before the
last ALTER DATABASE OPEN RESETLOGS command. If opening a
database that is open already by another instance, or if
another instance just brought this file online, the file
accessed by this instance is probably a different version.
Otherwise, a backup of the file probably was restored while
the file was in use.

Action: Make the correct file available to the database.
Then, either open the database, or execute ALTER SYSTEM
CHECK DATAFILES.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31527: could not find source column string for CDC change table string.string

1 Answers  


ORA-12832: Could not allocate slaves on all specified instances

1 Answers  


LRM-00120: 'string' is not a legal Oracle number for 'string'

1 Answers  


ORA-01923: CASCADE aborted, objects locked by another user

1 Answers  


ORA-26685: cannot apply transactions from multiple sources

1 Answers  






TNS-04067: Number of connections: number.

1 Answers  


NNL-00248: General request processing is now disabled

1 Answers  


ORA-16061: Log file status has changed

1 Answers  


TNS-00294: Connection Manager: Security is enabled, you cannot STOP the Interchange

1 Answers  


ORA-15176: file 'string' already has an alias associated with it

1 Answers  


ORA-14059: partition "string": INITRANS value must be less than MAXTRANS value

1 Answers  


PLS-00423: ORDER BY item must be the number of a SELECT-list expression

1 Answers  


Categories