ORA-01173: data dictionary indicates missing data file from system tablespace

ORA-01173: data dictionary indicates missing data file from system tablespace
Cause: Either the database has been recovered to a point in time in the future of the control file or a datafile from the system tablespace was omitted from the create control file command previously issued.
Action: For the former problem you need to recover the database from a more recent control file. For the latter problem, simply recreate the control file checking to be sure that you include all the datafiles in the system tablespace.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-01173：数据字典指示系统表空间中缺少数据文件,
.原因：数据库已恢复到控制文件未来的某个时间点，或者从先前发出的create control file命令中省略了系统表空间中的数据文件。,
.操作：对于前一个问题，您需要从更新的控制文件恢复数据库。对于后一个问题，只需重新创建控制文件检查，以确保将所有数据文件包含在系统表空间中。,
.

aiaiDBA

13718043309

010-86462881

ORA-01173: data dictionary indicates missing data file from system tablespace

1 个回答

相似问题