Oracle RMAN 复制失败显示错误ORA-01173: 数据字典指明系统表空间丢失的数据文件

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

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

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

ORA-01173: 数据字典指明系统表空间丢失的数据文件

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