ORA-01189: file is from a different RESETLOGS than previous files

ORA-01189: file is from a different RESETLOGS than previous files
Cause: In a CREATE CONTROLFILE command either this file or all previous files were backups from before the last RESETLOGS. This may also occur if this is a file that is offline and has been offline since before the last RESETLOGS.
Action: If the file was taken offline normal before the last RESETLOGS, and is still offline, omit it from the CREATE CONTROLFILE command. Rename and online the file after the database is open. Otherwise find the version of the mentioned file consistent with the rest of the datafiles and resubmit the command.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-01189：文件来自与以前的文件不同的RESETLOGS,
.原因：在CREATE CONTROLFILE命令中，此文件或所有以前的文件都是上次RESETLOGS之前的备份。如果这是离线并且在最后一次RESETLOGS之前已经离线的文件，也可能发生这种情况。,
.操作：如果文件在最后一个RESETLOGS之前正常脱机，并且仍处于脱机状态，请从CREATE CONTROLFILE命令中将其忽略。在打开数据库后重命名并联机文件。否则找到所提及的文件的版本与其余的数据文件一致并重新提交命令。,
.

aiaiDBA

13718043309

010-86462881

ORA-01189: file is from a different RESETLOGS than previous files

1 个回答

相似问题