如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com
Oracle数据库- 企业版- 版本11.2.0.以及更高版本
本文档中的信息适用于任何平台。
症状
由于ORA-01139/ ORA-16433，RMAN复制打开时报错CLONE，辅助pfile中指定了错误的UNDO表空间:
contents of Memory Script: { Alter clone database open resetlogs; } executing Memory Script } executing Memory Script RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00601: fatal error in recovery manager RMAN-03004: fatal error during execution of command RMAN-10041: Could not re-create polling channel context following failure. RMAN-10024: error setting up for rpc polling RMAN-10005: error opening cursor RMAN-10002: ORACLE error: ORA-03114: not connected to ORACLE RMAN-03002: failure of Duplicate Db command at 10/10/2012 14:27:10 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 ter minated. Disconnection forced ORA-30012: undo tablespace 'UNDOTBS1X' does not exist or of wrong type
所有试图解决人工恢复问题的尝试都失败了 :
使用 SQLPlus
SQL> recover database using backup controlfile until cancel; ORA-00283: recovery session canceled due to errors ORA-16433: The database must be opened in read/write mode.
SQL> alter database backup controlfile to trace; alter database backup controlfile to trace * ERROR at line 1: ORA-16433: The database must be opened in read/write mode.
使用 RMAN
RMAN> recover clone database; RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed start until cancel using backup controlfile ORA-00283: recovery session canceled due to errors ORA-16433: The database must be opened in read/write mode.
原因
辅助pfile指定一个无效的UNDO_表空间名，不存在于正被复制的数据库中。
这将导致打开重置日志后AUXILIARY立即报错。.
<Bug 14744052> AFTER FAILURE OF DUPICATE COMMAND DURING OPEN RESETLOGS, CLONE RAISES ORA-16433
关闭：不是错误
在辅助PFILE重置日志中设置一个标志，成功完成重置日志后可以通过字典检查取消该设置。因重置日志没有完成，标志仍需设置，会导致每次访问控制文件时出现ORA-16433。没有办法清除这个标志。
解决方案
重建控制文件，使用目标中生成的新建控制文件脚本的编辑版：如何重建一个控制文件（文档编号735106.1）
辅助警报日志表明，重置日志已完成并且将确定联机日志序列＃1:
Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0: C:\APP\DUP\REDO01.LOG
要完成这个过程 : - 在辅助pfile 中修正undo_ tablespace参数 - 用新建控制文件重新安装AUXILIARY - 恢复并打开重置日志
SQL> recover database using backup controlfile; ORA-00279: change 2023230 generated at 10/10/2012 14:27:01 needed for thread 1 ORA-00289: suggestion : C:\APP\FAST_RECOVERY_AREA\DUP\ARCHIVELOG\2012_10_10\O1_MF_1_1_%U_.ARC ORA-00280: change 2023230 for thread 1 is in sequence #1 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} C:\APP\DUP\REDO01.LOG Log applied. Media recovery complete. SQL> alter database open resetlogs; Database altered.
注意：为了避免将来出现该错误，确保为AUXILIARY指定的UNDO_TABLESPACE参数设置与当前目标数据库的设置相同。如果复制RAC目标数据库，你可以为AUXILIARY指定任意目标实例的UNDO_TABLESPACE。
注意: ----- o
如果指定了错误的UNDO表空间，然后在重置日志还原和恢复后试图打开RMAN数据库，同样的错误ORA-01139/ ORA-16433也会出现。