CHAPTER 12Maintenance and Troubleshooting

Once you implement Streams replication in your environment, maintaining it and troubleshooting any problems is the next challenge. Implementing structural changes to the objects involved in replication requires careful planning and execution, particularly the decision of whether or not to replicate DDL.

Maintaining existing Streams replication involves tasks such as adding and removing replicated objects or destinations. You may also need to remove the entire Streams configuration, or only part of the configuration if multiple Streams processes were defined in the database.

When Streams processes encounter errors, troubleshooting and correcting them become a priority. Errors in the replication environment ...

Get Oracle Streams 11g Data Replication now with O’Reilly online learning.

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