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