Administration of Stream Processes

 < Day Day Up > 



After you have configured the Streams environment between your two (or more) databases, it is time to consider the ongoing administration that will be required to keep the environment healthy and operational. Like any other availability solution, Streams can operate without much user intervention after you have it set up correctly. The difference, unfortunately, is that it is much easier to misconfigure Streams-there are just so many moving parts. You need to spend a certain amount of time monitoring Streams to ensure that the LCRs are being queued and dequeued successfully at each database. This means keeping a trained eye on the error logs, as well as any performance views that we discuss below. You also need to make sure that you have a sanity check to ensure that the two environments are staying in sync. If the network connection goes down, for instance, there may be some restarting and resyncing of Streams propagation.

Unfortunately, it is outside the scope of this humble chapter to provide all the management techniques for Streams. You will need to dig into the Streams documentation for Oracle for more information. Here are some of the highlights of the data dictionary and v$views available for Streams:

  • DBA_APPLY

  • DBA_APPLY_ERROR

  • DBA_CAPTURE

  • DBA_PROPAGATION

  • DBA_RULES

  • V$BUFFERED_QUEUES

Completely Removing a Streams Configuration from the Database

Starting in Oracle Database 10g, Oracle provides a means by which you can remove an entire Streams environment from a database. The procedure is part of the DBMS_STREAMS_ADMIN package, and it will remove all the pieces and parts you've configured for Streams. It will not remove the Streams admin user, however. This will need to be done afterward. You will need to run the procedure at all databases involved in a Streams replication scheme.

SQL> execute DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION();



 < Day Day Up > 



Oracle Database 10g. High Availablity with RAC Flashback & Data Guard
Oracle Database 10g. High Availablity with RAC Flashback & Data Guard
ISBN: 71752080
EAN: N/A
Year: 2003
Pages: 134

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net