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

PCC-00012: Not in a declare section at line number in file string

1 Answers  


ORA-30373: object data types are not supported in this context

1 Answers  


TNS-01019: set rawmode ON | OFF: set output mode for services and status commands

1 Answers  


NZE-29036: This feature is not supported

1 Answers  


ORA-12084: must use ALTER MATERIALIZED VIEW to alter "string"."string"

1 Answers  






ORA-10644: SYSTEM tablespace cannot be default temporary tablespace

1 Answers  


ORA-23350: maximum number of recursive calls exceeded

1 Answers  


LSX-00205: element "~1S" value "~2S" is wrong (must be "~3S")

1 Answers  


ORA-13032: Invalid NULL SDO_GEOMETRY object

1 Answers  


QSM-02181: a SPREADSHEET clause is present

1 Answers  


ORA-13704: Invalid value "string" specified for parameter "string".

1 Answers  


ORA-29390: some resource plans are not part of any top-plan

1 Answers  


Categories