如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com

  
ORA-01173
oerr ora 1173
01173, 00000, "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.
    适用于: Oracle Database - Enterprise Edition – 版本11.2.0.3 及以上 本文信息适用于任何平台。 症状 RMAN duplicate of RAC target using tablespace option fails with error: RMAN-03002: failure of Duplicate Db command at 07/15/2014 10:25:29 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script RMAN-06136: ORACLE error from auxiliary database: ORA-01092: ORACLE instance terminated. Disconnection forced 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表空间都应当被包括，但RMAN仅还原了其中一个undo表空间。失败，ORA-01173: data dictionary indicates missing data file from system tablespace出现，因为其他实例的其他undo表空间未被还原。这是一个bug，被记录为bug 19218445。 解决方案 使用'SKIP TABLESPACE'运行RMAN 复制，跳过所有你不想包括的表空间，除了： System表空间 Sysaux表空间 RAC目标使用的所有undo表空间 参考 BUG:19218445 - RAC TARGETLESS DUPLICATE WITH TABLESPACE CLAUSE RESTORES ONLY ONE UNDO TABLESPC