oracle流复制脚本（Oracle stream replication script）.docVIP

oracle流复制脚本（Oracle stream replication script） Queue: 1, create Begin Dbms_streams_adm.set_up_queue ( Queue_table = cssbak_queue_table, Queue_name = cssbak_queue); End; Begin Dbms_streams_adm.set_up_queue ( Queue_table = orcl_queue_table, Queue_name = orcl_queue); End; 2 capture process caption Establish Begin Dbms_streams_adm.add_schema_rules ( Schema_name = xpad- user name Streams_type = capture, - capture said Streams_name = capture_orcl, --capture. Queue_name = strmadmin.orcl_queuequeue name -- just created Include_dml = true, --dml rules Include_ddl = true, --ddl rules Include_tagged_lcr = false, Source_database = null, Inclusion_rule = true); End; query SELECT, CAPTURE_NAME, QUEUE_NAME, STATUS, CAPTURED_SCN, APPLIED_SCN, FROM, DBA_CAPTURE; Select * FROM V$STREAMS_CAPTURE Select, STATE, TO_CHAR (CAPTURE_MESSAGE_NUMBER), FROM, V$STREAMS_CAPTURE SELECT, queue_schema, queue_name, unbrowsed_msgs, overspilled_msgs, memory_usage, Publisher_state FROM V$BUFFERED_PUBLISHERS; Select * from, v$session_wait, where, wait_classIdle; Select * from, v$latchname, where, latch#=1; SELECT PUBLISHER_STATE FROM v$buffered_publishers; Select, STATUS, ERROR_MESSAGE, from, dba_propagation, where, PROPAGATION_NAME=h59g_101; Create table SSSS (UUID VARCHAR2 (32)) Select * from V$STREAMS_POOL_ADVICE SELECT * FROM DBA_CAPTURE_PARAMETERS; Select * from sys.STREAMS$_PROCESS_PARAMS; Set thread EXEC DBMS_CAPTURE_ADM.set_parameter (capture_name =capture_orcl, parameter =PARALLELISM, value =5); Set memory Exec, dbms_capture_adm.set_parameter (capture_orcl,_SGA_SIZE,200); Start / stop / delete / modify Begin Dbms_capture_adm.drop_capture ( Capture_name = capture_orcl); End; Begin Dbms_capture_adm.start_capture ( Capture_name = capture_orcl); End; BEGIN DBMS_CAPTURE_ADM.STOP_CAPTURE ( Capture_name = capture_orcl); END; 3, instantiation DECLARE Source_scn NUMBER; BEGIN Select, DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER (), into, source_scn, from, dual; DBMS_APPLY_ADM.SET_SCHEMA_INSTANTIATION_SCN