生产库模拟测试
在qhmes上异常关机之后 造成了下面的错误。
解：
单机
关机顺序
shutdown immediate
lsnrctl stop
开机顺序
lsnrctl start
startup
RAC环境：
<同上>
SQL> SELECT apply_name,apply_captured,status FROM dba_apply;
APPLY_NAME
APP STATUS
------------------------------ --- ----------
APPLY_MES_QH
YES ENABLED
APPLY_MES_QBJ
YES ABORTED
SQL> select PROPAGATION_NAME,SOURCE_QUEUE_NAME,QUEUE_TO_QUEUE,error_message from dba_propagation;
PROPAGATION_NAME
SOURCE_QUEUE_NAME QUEUE
------------------------------ ------------------------------ -----
ERROR_MESSAGE
--------------------------------------------------------------------------------
MES_TO_QBJMES
MES_QUEUE_QBJ FALSE
MES_TO_QHMES
MES_QUEUE_QH FALSE
ORA-12541: TNS:no listener
ORA-12541: TNS:no listener
问题一
APPLY_MES_QBJ
MES_QUEUE_QBJ ABORTED
ORA-26714: User error encountered while applying
SQL> select PROPAGATION_NAME,SOURCE_QUEUE_NAME,QUEUE_TO_QUEUE,error_message from dba_propagation;
PROPAGATION_NAME
SOURCE_QUEUE_NAME QUEUE
------------------------------ ------------------------------ -----
ERROR_MESSAGE
--------------------------------------------------------------------------------
MES_TO_QBJMES
MES_QUEUE_QBJ FALSE
MES_TO_QHMES
MES_QUEUE_QH FALSE
ORA-12541: TNS:no listener
ORA-12541: TNS:no listener
解：
qhmes 上 lsnrctl start
OK
这个两个错误是因为 刚开始不能同步的时候 我drop table造成的，当数据库重启之后最好开始
查查状态在删除
qhmes上
SQL> select APPLY_NAME,QUEUE_NAME,ERROR_MESSAGE,SOURCE_COMMIT_SCN from DBA_APPLY_ERROR;
APPLY_NAME
QUEUE_NAME
------------------------------ ------------------------------
ERROR_MESSAGE
SOURCE_COMMIT_SCN
---------------------------------------------------- -----------------
APPLY_QHMES_QH
QHMES_QUEUE_QH
ORA-23308:
object QHMES.AA does not exist or is inva 3865113
lid
APPLY_QHMES_QH
QHMES_QUEUE_QH
ORA-23308: object QHMES.AA does not
exist or is inva 3864848
lid
解决：
select apply_name,LOCAL_TRANSACTION_ID,SOURCE_TRANSACTION_ID,ERROR_MESSAGE
from dba_apply_error;
SQL>
BEGIN
DBMS_APPLY_ADM.EXECUTE_ERROR(
LOCAL_TRANSACTION_ID => '9.15.663', <------LOCAL_TRANSACTION_ID
EXECUTE_AS_USER => FALSE);
END;
/
生产库模拟测试
在qhmes上异常关机之后 造成了下面的错误。
解：
单机
关机顺序
shutdown immediate
lsnrctl stop
开机顺序
lsnrctl start
startup
RAC环境：
<同上>
SQL> SELECT apply_name,apply_captured,status FROM dba_apply;
APPLY_NAME
APP STATUS
------------------------------ --- ----------
APPLY_MES_QH
YES ENABLED
APPLY_MES_QBJ
YES ABORTED
SQL> select PROPAGATION_NAME,SOURCE_QUEUE_NAME,QUEUE_TO_QUEUE,error_message from dba_propagation;
PROPAGATION_NAME
SOURCE_QUEUE_NAME QUEUE
------------------------------ ------------------------------ -----
ERROR_MESSAGE
--------------------------------------------------------------------------------
MES_TO_QBJMES
MES_QUEUE_QBJ FALSE
MES_TO_QHMES
MES_QUEUE_QH FALSE
ORA-12541: TNS:no listener
ORA-12541: TNS:no listener
问题一
APPLY_MES_QBJ
MES_QUEUE_QBJ ABORTED
ORA-26714: User error encountered while applying
SQL> select PROPAGATION_NAME,SOURCE_QUEUE_NAME,QUEUE_TO_QUEUE,error_message from dba_propagation;
PROPAGATION_NAME
SOURCE_QUEUE_NAME QUEUE
------------------------------ ------------------------------ -----
ERROR_MESSAGE
--------------------------------------------------------------------------------
MES_TO_QBJMES
MES_QUEUE_QBJ FALSE
MES_TO_QHMES
MES_QUEUE_QH FALSE
ORA-12541: TNS:no listener
ORA-12541: TNS:no listener
解：
qhmes 上 lsnrctl start
OK
这个两个错误是因为 刚开始不能同步的时候 我drop table造成的，当数据库重启之后最好开始
查查状态在删除
qhmes上
SQL> select APPLY_NAME,QUEUE_NAME,ERROR_MESSAGE,SOURCE_COMMIT_SCN from DBA_APPLY_ERROR;
APPLY_NAME
QUEUE_NAME
------------------------------ ------------------------------
ERROR_MESSAGE
SOURCE_COMMIT_SCN
---------------------------------------------------- -----------------
APPLY_QHMES_QH
QHMES_QUEUE_QH
ORA-23308:
object QHMES.AA does not exist or is inva 3865113
lid
APPLY_QHMES_QH
QHMES_QUEUE_QH
ORA-23308: object QHMES.AA does not
exist or is inva 3864848
lid
解决：
盖国强的处理办法：
select apply_name,LOCAL_TRANSACTION_ID,SOURCE_TRANSACTION_ID,ERROR_MESSAGE
from dba_apply_error;
SQL>
BEGIN
DBMS_APPLY_ADM.EXECUTE_ERROR(
LOCAL_TRANSACTION_ID => '9.15.663', <------LOCAL_TRANSACTION_ID
EXECUTE_AS_USER => FALSE);
END;
/