逻辑standby的apply进程自动stop

最新推荐文章于 2021-04-15 11:55:33 发布

cnmcsdn8786

最新推荐文章于 2021-04-15 11:55:33 发布

阅读量123

点赞数

今天收到logical standby发过来的sms，消息显示log apply进程已经stop。登入server查看，发现log显示：
Mon Nov 9 01:00:04 2009
alter tablespace SYSTEM begin backup
Mon Nov 9 01:00:04 2009
ORA-1123 signalled during: alter tablespace SYSTEM begin backup ...
LOGSTDBY status: ORA-01123: cannot start online backup; media recovery not enabled
LOGSTDBY Apply process P004 pid=24 OS id=29661 stopped
Mon Nov 9 01:00:05 2009
Errors in file /u01/product/admin/mxdell/bdump/mxdell_lsp0_29872.trc:
ORA-12801: error signaled in parallel query server P004
ORA-01123: cannot start online backup; media recovery not enabled
LOGSTDBY Apply process P006 pid=26 OS id=29665 stopped
LOGSTDBY Apply process P007 pid=29 OS id=29667 stopped
LOGSTDBY Analyzer process P003 pid=23 OS id=29659 stopped
LOGSTDBY Apply process P005 pid=25 OS id=29663 stopped
LOGSTDBY Apply process P008 pid=31 OS id=29669 stopped
Mon Nov 9 01:00:17 2009
RFS[1]: Archived Log: '/data1/mxdell/arch2/1_88_702393373.arc'

询问同事，发现在进行热备准备做物理standby。

因此暂时只能skip ddl。

SQL> alter database stop logical standby apply;

Database altered.

SQL> exec dbms_logstdby.skip('NON_SCHEMA_DDL');

PL/SQL procedure successfully completed.

SQL> alter database start logical standby apply;

Database altered.

应用完成后，再开启ddl应用：

SQL> alter database stop logical standby apply;

Database altered.

SQL> exec dbms_logstdby.unskip('NON_SCHEMA_DDL');

PL/SQL procedure successfully completed.

SQL> alter database start logical standby apply;

Database altered.

参看log：
Mon Nov 9 01:09:22 2009
LOGSTDBY status: ORA-16205: DDL skipped due to skip setting
LOGSTDBY status: ORA-16205: DDL skipped due to skip setting
LOGSTDBY status: ORA-16205: DDL skipped due to skip setting
LOGSTDBY status: ORA-16205: DDL skipped due to skip setting
LOGSTDBY status: ORA-16205: DDL skipped due to skip setting
LOGSTDBY status: ORA-16205: DDL skipped due to skip setting
LOGSTDBY status: ORA-16205: DDL skipped due to skip setting
LOGSTDBY status: ORA-16205: DDL skipped due to skip setting
LOGSTDBY status: ORA-16205: DDL skipped due to skip setting
LOGSTDBY status: ORA-16205: DDL skipped due to skip setting
LOGSTDBY status: ORA-16205: DDL skipped due to skip setting
LOGSTDBY status: ORA-16205: DDL skipped due to skip setting
LOGSTDBY status: ORA-16205: DDL skipped due to skip setting
Mon Nov 9 01:09:23 2009
LOGMINER: End mining logfile: /data1/mxdell/arch2/1_87_702393373.arc
Mon Nov 9 01:09:23 2009
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 88, /data1/mxdell/arch2/1_88_702393373.arc
Mon Nov 9 01:09:23 2009
LOGMINER: End mining logfile: /data1/mxdell/arch2/1_88_702393373.arc