Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Summary

Oracle Streams replication works with buffered and persistent queues of type ANYDATA. The queues are secured and transactional in nature. By default, these are commit-time queues. The queue must be created for Streams clients such as capture, apply, and propagation processes. The associated queue table is owned by the instance where the queue is created. The Streams client process runs on the instance that owns the queue table. It is possible to specify the primary and secondary instances for the queue table in a RAC environment. This facilitates the failover of the Streams client process when the instance that owns the queue table becomes unavailable.

Messages enqueued to the source queue are propagated, or copied, to the destination queue by the propagation process. The propagation process can be created implicitly or explicitly. The procedure that adds rules to the propagation process also creates propagation if it did not exist. An explicitly created propagation process can use an existing rule set. Oracle also creates a propagation job and a schedule to run the propagation job. By default, the job is of type EVENT with a propagation window that is open forever or until the propagation is disabled. This enables speedier delivery of the messages to the destination queue.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint