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

ORA-01209: data file is from before the last RESETLOGS
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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-01209：数据文件来自最后一个RESETLOGS,
.原因：文件头中的重置日志数据与控制文件不匹配。如果数据库关闭或文件脱机，则备份是旧的，因为它是在最后一个ALTER DATABASE OPEN RESETLOGS命令之前执行的。如果打开已由另一个实例打开的数据库，或者另一个实例只是使此文件联机，则此实例访问的文件可能是不同的版本。否则，文件的备份可能在文件正在使用时已恢复。,
.操作：使正确的文件可用于数据库。然后，打开数据库，或执行ALTER SYSTEM CHECK DATAFILES。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题