如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 : 13764045638 QQ号:47079569 邮箱:[email protected]
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
Leave a Reply