In this chapter, the Streams configuration
details involving the multiple instances in a RAC database
environment have been examined.
The main points of this chapter include:
In a RAC environment, only one instance has
the queue buffers. Therefore, the capture or apply is confined
to that instance.
Queue affinity can be controlled by setting
up the specification of primary and secondary instance. Based on
this affinity, queue buffers always move to the primary
When RAC is acting as the destination
database for Streams replication, the source database should
have the database link to the instance having the queue buffers.
Information on the enhancements that were
introduced in Oracle10g was presented. These enhancements were
examined in terms of automatic failure of the Capture process to
a surviving node in case of the instance failure where the
Capture process is running and the hot mining of the redo logs
by the Capture process.
In the next chapter, Streams replication to
heterogeneous databases such as Sybase and SQL Server will be