Book Image

Oracle 11g Streams Implementer's Guide

Book Image

Oracle 11g Streams Implementer's Guide

Overview of this book

From smaller businesses through to huge enterprises ñ users all over the world often require access to data 24 hours a day. Distributed database systems proliferate the world of data sharing providing an ability to access real-time data anywhere, anytime. Oracle Streams, a built-in feature of the Oracle database, is a data replication and integration feature critical to the success and wellbeing of enterprises in today's fast moving economy. This book provides the reader with solid techniques to master Oracle Streams technology and successfully deploy distributed database systems. This book quickly goes over the basics and gets you up and running with a simple Oracle 11g Streams environment. It will serve as an excellent companion to the Oracle Streams Administration Guide. It is intended for Oracle database architects and administrators, and provides in-depth discussion on must-know information for the design, implementation, and maintenance of an Oracle Streams environment. The book does not attempt to regurgitate all the information in the Oracle Streams Administration Guides, but rather provides additional clarification and explanation of design, implementation, and troubleshooting concepts that are often elusive in Streams documentation. It also identifies helpful tools and Oracle resources to add to your knowledge base, as well as tried and tested tricks and tips to help you tame Oracle Streams. The book starts by introducing and explaining the components of Oracle Streams and how they work together. It then moves on logically, helping you to determine your distributed environment requirements and design your Streams implementation to meet those requirements. Once these concepts are discussed, the book moves to configuration and basic implementation examples to help solidify those concepts. It then addresses advanced features such as tags, down-stream capture, and conflict resolution. You then move on to maintenance techniques such as documenting the environment, effectively planning and implementing changes to the environment, and monitoring and troubleshooting the environment. When you have studied the techniques and completed the hands-on examples, you will have an understanding of Oracle Streams' core concepts and functionally that will allow you to successfully design, implement, and maintain an Oracle Streamed environment.
Table of Contents (14 chapters)
Oracle 11g Streams Implementer's Guide
Credits
About the Authors
About the Reviewers
Preface

Oracle GoldenGate XSTREAMS


With the acquisition of GoldenGate, Oracle 11gR2 incorporates GoldenGate XSTREAMS technology providing client applications with the ability to insert and extract LCR datatypes directly into an implicit or explicit Stream.

Note

To use the XSTREAMS API's, you must purchase an Oracle GoldenGate product license. See the Oracle GoldenGate documentation at http://download.oracle.com/docs/cd/E15881_01/index.htm.

The following lists views that supply helpful information for XSTREAMS:

  • ALL_APPLY

  • ALL_APPLY_ERROR

  • ALL_XSTREAM_INBOUND

  • ALL_XSTREAM_INBOUND_PROGRESS

  • ALL_XSTREAM_OUTBOUND

  • ALL_XSTREAM_OUTBOUND_PROGRESS

  • ALL_XSTREAM_RULES

  • DBA_APPLY

  • DBA_APPLY_ERROR

  • DBA_APPLY_SPILL_TXN

  • DBA_XSTREAM_INBOUND

  • DBA_XSTREAM_INBOUND_PROGRESS

  • DBA_XSTREAM_OUTBOUND

  • DBA_XSTREAM_OUTBOUND_PROGRESS

  • DBA_XSTREAM_RULES

XTREAMS is built on Oracle Streams infrastructure and thus can take advantage of Oracle Streams' functionality and flexibility.

The Oracle database is configured to support XSTREAMS using the DBMS_XSTREAMS_ADM package subprograms. Specialized server processes are configured to handle inbound and outbound traffic to standard Oracle Streams queues. Outbound server processes can be created to dequeue from an existing Streams queue, or its own queue. Inbound server processes are created with their own Streams queue which can then be configured for use via normal Streams apply rule creation. These server processes are accessed via the OCI or Java API function interfaces.

XSTREAMS provides the ability to share information across a heterogeneous environment with excellent flexibility, usability, and performance. This functionality can be used as an alternative to replicating with Oracle Heterogeneous Gateways, and Java Messaging Service(JMS) clients.

Note

For more information on XSTREAMS, please reference the Oracle Database XSTREAMS Guide.

Special Documentation Notes:

The DBMS_XSTREAM_ADM package is documented in the Oracle Database XSTREAMS Guide rather than the Oracle PL/SQL Packages and Types Reference.

XSTREAM OCI interfaces are found in the Oracle Database XSTREAMS Guide.

XSTREAM Java API's are found in the XSTREAM Java API Reference.