业务 数据 安全

摘要： 查询CDC信息select apply_name, status from dba_apply;select capture_name, state, total_messages_captured from v$streams_capture; select group#, thread#, sequence#, archived, status from v$standby_log; select app.apply_name, q.name, app.status, qt.queue_table from dba_apply app, dba_queues q, dba_queue_t. 阅读全文

摘要： 1.cdc 模式在源库是集群的情况下！ 源库的 log_archive_dest_2='SERVICE=alcdcstg lgwr async optional noregister reopen=5 valid_for=(online_logfile,primary_role) sid=’1’' log_archive_dest_2='SERVICE=alcdcstg lgwr async optional noregister reopen=5 valid_for=(online_logfile,primary_role) sid=’2’' 一.CDC au 阅读全文