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 from the FRA, even if capture needs them to restart. In the event that you decide not to use the FRA to store your archived logfiles, another option is to back these logs up to another disk volume on your SAN or NAS filesystem. For added protection...