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

RMAN-06453: RECOVERABLE may only be used with datafile objects

1 Answers  


ORA-31068: updateXML expected data format [string] instead of [string]

1 Answers  


ORA-02474: Fixed hash area extents used (string) exceeds maximum allowed (string)

1 Answers  


ORA-29522: authorization error for referenced name string.string

1 Answers  


ORA-19335: Invalid format type object

1 Answers  






ORA-26506: null global context

1 Answers  


ORA-26064: Invalid SCN specified - Wrap: string Base: string.

1 Answers  


ORA-27203: skgfpqb: sbtpcquerybackup returned error

1 Answers  


ORA-02354: error in exporting/importing data string

1 Answers  


NZE-29135: Seed generation for Random Number Generator failed.

1 Answers  


ORA-31042: Too many properties in type 'string'

1 Answers  


ORA-15035: no disks belong to diskgroup "string"

1 Answers  


Categories