一、错误现象
1、duplicate过程
RMAN-05535: warning: All redo log files were not defined properly. Oracle error from auxiliary database: ORA-01275: Operation RENAME is not allowed if standby file management is automatic. Oracle error from auxiliary database: ORA-01275: Operation RENAME is not allowed if standby file management is automatic.
2、此时alert_<SID>.log日志错误
2021-08-13T09:03:04.169901+08:00 Errors in file /oracle/app/oracle/diag/rdbms/nccporclstd/nccporcl/trace/nccporcl_mz00_15785.trc: ORA-01110: data file 6: '/oracle/app/oracle/oradata/NCCPORCL/NNC_INDEX01.dbf'
3、上述trace中的错误
DDE encountered the following error: ORA-49204: Recursive DDE invocation at Phase I ORA-01110: data file 6: '/oracle/app/oracle/oradata/NCCPORCL/NNC_INDEX01.dbf' dbkh_create_finding: BEGIN dbkhu_prepare_default_msgobj: BEGIN dbkhu_prepare_default_msgobj:; name_id=71, type=2, flags=1 dbkhu_get_default_msg_def: BEGIN dbkhu_get_default_msg_def: END dbkhu_prepare_default_msgobj:: MSG PARAMS-1; i=0 dbkhu_prepare_default_msgobj: END dbkhu_prepare_default_msgobj: BEGIN dbkhu_prepare_default_msgobj:; name_id=71, type=2, flags=2 dbkhu_get_default_msg_def: BEGIN dbkhu_get_default_msg_def: END dbkhu_prepare_default_msgobj:: MSG PARAMS-2; i=0 dbkhu_prepare_default_msgobj: END dbkh_create_finding: END cross-check executed dbkh_post_process_run: BEGIN dbkh_post_process_run: NEW FAILURE COUNT: 0; DBKH_NUM_NEW_FAILURES_CTX(ctxp)=dbkh_post_process_run: END dbkh_run_check_internal: END dbkh_reactive_run_check: END
二、现象分析:
一个帖子指出:
ora-49204: recursive dde invocation at phase i This error is followed by ora-01110. This happens for all data files
这个是12c的一个BUG。 ORA-01110 For All Files In Standby Database
三、解决方案
参照:https://blog.csdn.net/weixin_54651775/article/details/119077731
MOS上给出的解决方案:下载并安装补丁包:p24844841_122010_Linux-x86-64.zip
考虑问题应该出在standby log上。
解决方案:
1.停止备库的恢复管理模式
2.清空standby日志
3.重启备库
4.开启备库应用日志
5.检查