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 ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.