dg同步后RFS进程起不来,归错于ORA-00604和ORA-16000
SQL>setlines1000
SQL>selectPROCESS,PID,STATUS,GROUP#,RESETLOG_ID,THREAD#,SEQUENCE#fromv$managed_standby;
PROCESSPIDSTATUSGROUP#RESETLOG_IDTHREAD#SEQUENCE#
------------------------------------------------------------------------------------------------------
ARCH3965CONNECTEDN/A000
ARCH3969CONNECTEDN/A000
ARCH3973CONNECTEDN/A000
ARCH3977CONNECTEDN/A000
MRP06708APPLYING_LOGN/A9181469071107387
查看日志
Errorsinfile/u01/app/oracle/diag/rdbms/yjzddbdg/yjzddb1/trace/yjzddb1_ora_4111.trc:
ORA-00604:erroroccurredatrecursiveSQLlevel1
ORA-16000:databaseopenforread-onlyaccess
找出隐藏参数_system_trig_enabled,先使他不起作用,在重新同步,可以看到RFS进程起来了。
SQL>altersystemset"_system_trig_enabled"=false;
Systemaltered.
SQL>recovermanagedstandbydatabasecancel;
Mediarecoverycomplete.
SQL>recovermanagedstandbydatabaseusingcurrentlogfiledisconnect;
Mediarecoverycomplete.
SQL>setlines1000
SQL>selectPROCESS,PID,STATUS,GROUP#,RESETLOG_ID,THREAD#,SEQUENCE#fromv$managed_standby;
PROCESSPIDSTATUSGROUP#RESETLOG_IDTHREAD#SEQUENCE#
------------------------------------------------------------------------------------------------------
ARCH3965CONNECTEDN/A000
ARCH3969CONNECTEDN/A000
ARCH3973CONNECTEDN/A000
ARCH3977CONNECTEDN/A000
MRP023687APPLYING_LOGN/A9181469071107401
RFS23964IDLEN/A000
RFS23960IDLEN/A000
RFS23968IDLEN/A000
RFS23955IDLE59181469071107401
9rowsselected.
在rac的所有节点都做该操作,等DG切换完成后记得在所有节点重新使该隐藏参数生效。
SQL>altersystemset"_system_trig_enabled"=true;
Systemaltered.