1. ORA-01173 错误的含义 ORA-01173 错误表明:“数据字典检测到系统表空间中缺少数据文件”。这通常意味着在尝试打开数据库时,Oracle 无法找到系统表空间(system tablespace)中预期的数据文件。 2. 可能导致 ORA-01173 错误的原因 控制文件不一致:在创建或恢复控制文件时,可能未包含所有系统表空间的数据文件。 数据...
// 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.该ORA-01173错误也可能与UNDO损坏相关，需要专家手动Patch undo来修复。如果自己搞不定可以找诗檀软件专业O...
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: ‘D:\APP\LUOPING\ORADATA\ORCL\SYSTEM01.DBF’ ORA-01112: media recovery not started www.htz.pw > alter database open resetlogs up...
数据库异常关闭,使用resetlogs方式重建控制文件,不包含undo表空间相关数据库,然后尝试resetlogs打开数据库,非常容易出现ORA-01173: data dictionary indicates missing data file from system tablespace之类的错误,本文通过模拟该错误,并简单提供解决方法 模拟ORA-01173错误 SQL> select * from v$version; BANNER --- Orac...
数据库异常关闭,使用resetlogs方式重建控制文件,不包含undo表空间相关数据库,然后尝试resetlogs打开数据库,非常容易出现ORA-01173: data dictionary indicates missing data file from system tablespace之类的错误,本文通过模拟该错误,并简单提供解决方法 模拟ORA-01173错误 ...
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. ...
ORA-01173: data dictionary indicates missing data file from system tablespace Process ID: 57305 原因 Bug 19218445 – RAC TARGETLESS DUPLICATE WITH TABLESPACE CLAUSE RESTORES ONLY ONE UNDO TABLESPACE tablespace选项的使用应会导致RMAN仅还原该表空间金额所需的Oracle表空间。有了一个RAC目标,两个undo表空间都...
ORA-01173: data dictionary indicates missing data file from system tablespace.. Answer / guest Cause: Either the database has been recovered to a point in time in the future of the controlfile or a datafile from the system tablespace was omitted from the create controlfil...
ORA-01173: data dictionary indicates missing data file from system tablespace Process ID: 57305 原因 Bug 19218445 – RAC TARGETLESS DUPLICATE WITH TABLESPACE CLAUSE RESTORES ONLY ONE UNDO TABLESPACE tablespace选项的使用应会导致RMAN仅还原该表空间金额所需的Oracle表空间。有了一个RAC目标,两个undo表空间都...