--1、流正常吗?
--(1)查看源上的captrue进程和propagation进程的状态(以黔东南为例,在ETL上利用dblink查看。注意,dba_captrue和dba_propagation都是各地的市州sys用户下view):
-----------------------------------------------------------------------------------------
select capture_name,status from sys.dba_capture@qdn.gzdsqdn.gov.cn;
select propagation_name,status from sys.dba_propagation@qdn.gzdsqdn.gov.cn;
--(2)查看ETL上应用进程的状态:
select apply_name,status from dba_apply;
--如果有CAPTURE进程DISABLE了
EXEC DBMS_CAPTURE_ADM.START_CAPTURE(CAPTURE_NAME => 'CAPTURE_8_QDN');
--如果有PROPAGATION进程DISABLE了
EXEC DBMS_PROPAGATION_ADM.START_PROPAGATION(PROPAGATION_NAME => 'PROPAGATION_8_QDN');
--如果有CAPTRUE进程ABORTED了
EXEC DBMS_CAPTURE_ADM.STOP_CAPTURE(CAPTURE_NAME => 'CAPTURE_8_QDN');
EXEC DBMS_CAPTURE_ADM.START_CAPTURE(CAPTURE_NAME => 'CAPTURE_8_QDN');
--如果有PROPAGATION进程ABORTED了
EXEC DBMS_PROPAGATION_ADM.STOP_PROPAGATION(PROPAGATION_NAME => 'PROPAGATION_7_AS');
EXEC DBMS_PROPAGATION_ADM.START_PROPAGATION(PROPAGATION_NAME => 'PROPAGATION_7_AS');
--2、归档空间的使用情况如何?
--(1)查看源上的captrue进程和propagation进程的状态(以黔东南为例,在ETL上利用dblink查看。注意,dba_captrue和dba_propagation都是各地的市州sys用户下view):
-----------------------------------------------------------------------------------------
select capture_name,status from sys.dba_capture@qdn.gzdsqdn.gov.cn;
select propagation_name,status from sys.dba_propagation@qdn.gzdsqdn.gov.cn;
--(2)查看ETL上应用进程的状态:
select apply_name,status from dba_apply;
--如果有CAPTURE进程DISABLE了
EXEC DBMS_CAPTURE_ADM.START_CAPTURE(CAPTURE_NAME => 'CAPTURE_8_QDN');
--如果有PROPAGATION进程DISABLE了
EXEC DBMS_PROPAGATION_ADM.START_PROPAGATION(PROPAGATION_NAME => 'PROPAGATION_8_QDN');
--如果有CAPTRUE进程ABORTED了
EXEC DBMS_CAPTURE_ADM.STOP_CAPTURE(CAPTURE_NAME => 'CAPTURE_8_QDN');
EXEC DBMS_CAPTURE_ADM.START_CAPTURE(CAPTURE_NAME => 'CAPTURE_8_QDN');
--如果有PROPAGATION进程ABORTED了
EXEC DBMS_PROPAGATION_ADM.STOP_PROPAGATION(PROPAGATION_NAME => 'PROPAGATION_7_AS');
EXEC DBMS_PROPAGATION_ADM.START_PROPAGATION(PROPAGATION_NAME => 'PROPAGATION_7_AS');
--2、归档空间的使用情况如何?