Best practices for Streams in an RAC environment

While the installation and configuration of Oracle 11g Streams is outside the scope of this chapter, we will provide you with some best practices and design considerations for Oracle Streams with RAC environments. To ensure a successful Streams implementation in an Oracle RAC environment, use the following recommendations when constructing a Streams environment.

Additional configuration of RAC environments for a Source Database

The archive log threads from all instances must be available to any instance running a Capture process. This is true for both local and downstream capture.

It is recommended not to have Flash Recovery Area (FRA) as the location of the archived logs because logfiles can be removed ...

Get Oracle 11g R1/R2 Real Application Clusters Essentials now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.