oracle 10g stream weihu
1 啟動apply,propagation和capture程式的語句
exec dbms_capture_adm.start_capture(capture_name=>'CAPTURE_DB1_STRM');
exec dbms_apply_adm.start_apply(apply_name=>'APPLY_DB2_STRM');
exec dbms_propagation_adm.start_propagation('PROP_DB1_TO_DB2_STRM');
2 停止apply,propagation和capture程式的語句
exec dbms_capture_adm.stop_capture(capture_name=>'CAPTURE_DB1_STRM');
exec dbms_apply_adm.stop_apply(apply_name=>'APPLY_DB2_STRM');
exec dbms_propagation_adm.stop_propagation('PROP_DB1_TO_DB2_STRM');
3 刪除apply,propagation和capture流及佇列和相應的規則集和規則的語句
exec dbms_capture_adm.stop_capture('capture_cap1_strm');
exec dbms_capture_adm.drop_capture('capture_cap1_strm');
exec dbms_propagation_adm.stop_propagation('prop_cap1_to_app1_strm');
exec dbms_propagation_adm.drop_propagation(propagation_name=> 'prop_cap1_to_app1_strm',drop_unused_rule_sets=> true);
exec dbms_apply_adm.stop_apply('apply_app1_strm');
exec dbms_apply_adm.drop_apply('apply_app1_strm');
exec dbms_aqadm.stop_queue(queue_name => 'capture_cap1_qn');
exec dbms_aqadm.drop_queue(queue_name => 'capture_cap1_qn');
exec dbms_aqadm.drop_queue_table(queue_table => 'capture_cap1_qt');
?
begin
(
object_name => 'SCOTT.BONUS1',
object_type => 'TABLE',
operation_name => 'INSERT',
user_procedure => null,
apply_name => 'APPLY_APP1_STRM',
assemble_lobs => true);
end;
/
8.4 在本地資料庫中清除整個流配置
exec dbms_streams_adm.remove_streams_configuration;
注:此語句及其危險,並且有時也不見得能徹底清除所有的與流有關的物件。
------------------------------------------------------------------------------------------------------------
8.5 資料庫級例項化過程
declare
iscn number; -- Variable to hold instantiation SCN value
begin
iscn := dbms_flashback.get_system_change_number();
(source_database_name => 'rep1',
instantiation_scn => iscn ,
recursive =>true
);
end;
/
8.6 使用者級例項化過程
declare
iscn number; -- Variable to hold instantiation SCN value
begin
iscn := dbms_flashback.get_system_change_number ();
(source_schema_name => 'SCOTT',
source_database_name => 'REP1',
instantiation_scn => iscn,
recursive => true);
end;
/
庫表級例項化過程
declare
iscn number; -- Variable to hold instantiation SCN value
begin
iscn := dbms_flashback.get_system_change_number ();
(source_object_name => 'SCOTT.BONUS',
source_database_name => 'REP1',
instantiation_scn => iscn);
end;
/
-----------------------------------------------------------------------------------
8.20 清除指定應用程式的錯誤佇列
EXEC DBMS_APPLY_ADM.DELETE_ALL_ERRORS(apply_name =>'APPLY_DB2_STRM');
8.21 清除錯誤佇列中指定應用事務的錯誤
EXEC DBMS_APPLY_ADM.DELETE_ERROR(local_transaction_id=>'5.4.312');
8.22 重新應用錯誤佇列中指定的出錯事務
EXEC DBMS_APPLY_ADM.EXECUTE_ERROR(local_transaction_id =>'5.23.1004', execute_as_user =>FALSE,user_procedure =>NULL);
注:execute_as_user =>FALSE表示在原有應用事務環境執行。
8.23 重新應用錯誤佇列中所有出錯事務
EXEC DBMS_APPLY_ADM.EXECUTE_ALL_ERRORS(apply_name=>'APPLY_DB2_STRM',execute_as_user=>FALSE);
-------------------------------------------------------------------------------
Streams配置和管理的相關package
dbms_steams_adm
dbms_capture_adm
dbms_propagation_adm
dbms_apply_adm
dbms_rule_adm
Streams主要相關資料字典
dba_streams_administrator
dba_capture
dba_capture_parameters
dba_propagation
dba_registered_archived_log
dba_apply
dba_apply_confict_columns
dba_apply_dml_handlers
dba_apply_enqueue
dba_apply_error
dba_apply_execute
dba_apply_parameters
dba_apply_progress
dba_rules
dba_rule_sets
dba_rule_set_rules
select * from V$STREAMS_CAPTURE
V$STREAMS_POOL_ADVICE
V$STREAMS_TRANSACTION
V$PROPAGATION_RECEIVER
V$PROPAGATION_SENDER
V$STREAMS_APPLY_COORDINATOR
V$STREAMS_APPLY_READER
V$STREAMS_APPLY_SERVER
select * from dba_capture
select * from dba_rule_set_rules
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9879835/viewspace-1060462/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle 10g table streamOracle 10g
- oracle 10g user streamOracle 10g
- Oracle 10g stream 一對多複製Oracle 10g
- Oracle 10g Stream 時時資料同步, 全程試驗紀錄Oracle 10g
- ORACLE STREAM ERROROracleError
- restart oracle streamRESTOracle
- Oracle simple streamOracle
- 10g Stream 單表同步問題
- Oracle stream案例分享Oracle
- oracle stream pool sizeOracle
- Oracle Stream概述與配置Oracle
- Oracle Stream Replication 技術Oracle
- oracle stream學習(一)Oracle
- Oracle Stream 深入探討Oracle
- oracle 10 g stream tableOracle
- Oracle Stream(2)--Streams功能Oracle
- Oracle Stream(1)--Streams概述Oracle
- ORACLE 10g下載|ORACLE 10g下載地址|ORACLE 10g官網下載地址Oracle 10g
- oracle stream之schema級複製Oracle
- Oracle Stream配置詳細步驟Oracle
- oracle 10g patchOracle 10g
- ORACLE 10G AUTOTRACEOracle 10g
- oracle asm 10gOracleASM
- recyclebin for oracle 10gOracle 10g
- Oracle 10g flashbackOracle 10g
- Glossary Oracle 10gOracle 10g
- Oracle Stream的安裝、配置和使用Oracle
- Oracle Stream實戰(9)—測試(二)Oracle
- Oracle Stream實戰(8)—測試(一)Oracle
- oracle 9i stream配置備記Oracle
- Oracle Stream(3)--Stream與高階複製和邏輯Dataguard的比較Oracle
- oracle 10g flashback databaseOracle 10gDatabase
- Oracle 10g RAC NFSOracle 10gNFS
- oracle 10g em建立Oracle 10g
- ORACLE 10G 升級Oracle 10g
- Oracle 10g RAC TAFOracle 10g
- oracle 10g RMAN管理Oracle 10g
- ORACLE 10G AWR 速查!Oracle 10g