As with any kind of day-to-day operational support, rare but unfortunate situations will arise where the target server or database incurs an outage. In a hub-and-spoke configuration,if a destination in a Streams replication environment becomesunavailable,it can cause file system issues or possible performance degradations on the source system.
Splitting a Stream
For such situations, DBAs can split (temporarily offline) the unavailable destination from a Stream configuration using the DBMS_STREAMS_ADM. SPLIT_STREAMSprocedure.The split_streams procedure creates cloned capture queue and processes on the source.In addition,a propagation is created with a disabled status. The split_streams procedure has these parameters:PROCEDURE split_streams (
The AUTO_MERGE_THRESHOLD is by default set to NULL or 0,which means the split stream is not automatically merged back with the original stream. If the result of CAPTURE_MESSAGE_CREATE_TIME in the V$STREAMS_CAPTURE view is within seconds of the AUTO_MERGE_THRESHOLD of the split_streams procedure with the original capture process,the two streams are automatically merged.
Merging the Streams
Once the issue on the target is resolved, you can merge the split stream back with the original stream using the merge_streams procedure in the same package:PROCEDURE merge_streams (
As mentioned, this merge can be automated by setting the auto_merge_threshold parameter of the split_streams procedure to a nonzero value.
Once a fault is detected at a target destination, you can query theV$BUFFERED_QUEUES view to identify how many messages are in a buffered queue and how many of these messages have spilled to disk.
Merge Streams Job
You can use the merge_streams_job procedure when you need to determine whether the original capture and cloned capture processes are in the range of the specified merge threshold.If the threshold is within the range, then the merge_streams procedure is executed to merge the two streams.PROCEDURE merge_streams_job (
Oracle 11g Related Interview Questions
|Oracle 10g Interview Questions||Oracle 9i Interview Questions|
|Oracle 8i Interview Questions||Informatica Interview Questions|
|PL/SQL Interview Questions||Oracle 11g Interview Questions|
|SQL Interview Questions||Oracle apps Interview Questions|
|Sybase Interview Questions||Oracle Apps ERP Interview Questions|
|Oracle 7.3 Interview Questions||Oracle Access Manager Interview Questions|
|Oracle Application Framework Interview Questions||Oracle Apps DBA Interview Questions|
Oracle 11g Related Practice Tests
|Oracle 10g Practice Tests||Oracle 9i Practice Tests|
|Oracle 8i Practice Tests||Informatica Practice Tests|
|PL/SQL Practice Tests||Oracle 11g Practice Tests|
|SQL Practice Tests||Oracle apps Practice Tests|
|Sybase Practice Tests||Oracle Apps ERP Practice Tests|
|Oracle 7.3 Practice Tests|
Oracle 11g Tutorial
Installing, Upgrading, And Managing Change
Database Diagnosability And Failure Repair
Backup And Recovery
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.