| Stopping Stream replication to restart server [message #349914] |
Tue, 23 September 2008 08:23  |
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
|
Senior Member |
|
|
Hi,
I am using oracle 10g. If i want to stop One way Stream replication to restart the Production server
I have setup schema replication from Production to destination server . How i can do that?
|
|
|
|
| Re: Stopping Stream replication to restart server [message #350001 is a reply to message #349914] |
Tue, 23 September 2008 13:38  |
shrinika
Messages: 306
Registered: April 2008
|
Senior Member |
|
|
Hello, I am not sure about the schema replication. We are using table replication. I believe,
you are asking the procedure to restart the stream database. Here is the process we do to
disable to streams before we restart the server.
If you use OEM,
disable the capture process
disable the propagation
disable the apply
Go to Advanced queue, click strmadmin, disable queues.
shutdown the server.
After restarting the server,
Go to Advanced queue, click strmadmin, enable queues.
enable the capture process
enable the propagation
enable the apply
Hope it helps.
One question to you. Can you please let me now any steps/links to learn about
schema level replication?
Thanks
|
|
|
|
|
|
| Re: Stopping Stream replication to restart server [message #350170 is a reply to message #350001] |
Wed, 24 September 2008 05:08 |
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
|
Senior Member |
|
|
Usualy i do is, i stop Capture and Apply process and then shut it down.
As far as Schema replication is concerned i hope following points wll help
At Source:
1)exec dbms_streams_adm.set_up_queue(queue_table => 'strmadm.M1_queue_table',queue_name => 'strmadm.M1_queue');
2)exec dbms_streams_adm.add_schema_rules(schema_name => 'M1',streams_type => 'capture',streams_name => 'M1_capture',queue_name => 'M1_queue',include_dml => true,include_ddl => true,include_tagged_lcr => false,source_database => NULL,inclusion_rule => true);
3)exec dbms_streams_adm.add_schema_propagation_rules(schema_name => 'M1',streams_name => 'M1_propagate',source_queue_name => 'M1_queue',destination_queue_name => 'strmadm.M12_queue@d2',include_dml => true,include_ddl => true,include_tagged_lcr => false,source_database => 'd1',inclusion_rule => true);
6)declare iscn number;
begin
iscn:=dbms_flashback.get_system_change_number();
dbms_output.put_line('instantiation SC : '||iscn);
dbms_apply_adm.set_schema_instantiation_scn@d2(source_schema_name=>'M1',source_database_name=>'d1',instantiation_scn=>iscn,recursive=>true);
end;
8)EXEC DBMS_CAPTURE_ADM.start_capture(capture_name => 'M1_CAPTURE');
Destination:
4)exec dbms_streams_adm.set_up_queue(queue_table => 'strmadm.M12_queue_table',queue_name => 'strmadm.M12_queue');
5)exec dbms_streams_adm.add_schema_rules(schema_name => 'M1',streams_type => 'apply',streams_name => 'M1_apply',queue_name => 'M12_queue',include_dml => true,include_ddl => true,include_tagged_lcr => false,source_database => 'd1',inclusion_rule => true);
7)exec dbms_apply_adm.start_apply(apply_name => 'M1_APPLY');
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
