Oracle 11g Streams Implementer's Guide
|Also available on:|
- Implement Oracle Streams to manage and coordinate the resources, information, and functions of a distributed system
- Get to grips with in-depth explanations of the components that make up Oracle Streams, and how they work together
- Learn design considerations that help identify and avoid Oracle Streams obstacles – before you get caught in them
- Covers implementation steps with explanations of 'why' as well as 'how'
Table of Contents
Chapter 1: All the Pieces: The Parts of an Oracle 11g Streams Environment
Chapter 2: Plot Your Course: Design Considerations
Chapter 3: Prepare the Rafts and Secure Your Gear: The pre-work before configuring Oracle 11g Streams
Chapter 4: Single-Source Configuration
Chapter 5: N-Way Replication
Chapter 6: Get Fancy with Streams Advanced Configurations
Chapter 7: Document What You Have and How It Is Working
Chapter 8: Dealing with the Ever Constant Tides of Change
Chapter 9: Appendix and Glossary
Download the code and support files for this book.
Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.
Errata- 2 submitted: last submission 12 Mar 2013
Errata type: Typo | Page number: 41 |
This procedure must be one at least once in the database before a Capture process can be created.
This procedure must be run at least once in the database before a Capture process can be created.
Errata type: Code| Page number: 130 |
ALTER TABLE "HR"."
LTER TABLE "HR"."
What you will learn from this book
- Clear, concise explanations of Oracle Streams components and concepts
- Up-front design considerations and techniques – know what you need BEFORE you start building
- Configure both Source and Target databases to support Streams capture, propagation, and apply processes
- Set up a Single-Source Configuration using the Enterprise manager DB Console to divert flow in one direction and apply its concepts to a multi-master, or N-Way Replication environment configuration
- Solidify your Streams concepts through basic implementation examples that can then be applied to more complicated systems
- Learn about popular advanced features of Oracle Streams including Subsetting, Tags, Rules, and Rule based transformations
- Discover effective and efficient troubleshooting techniques and tools
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.
This book has a tutorial approach that provides both theoretical explanations and practical step-by-step examples using familiar Oracle demo schemas. Step-by-step examples include use of both Enterprise Manager and the SQLPLUS command-line interface. The authors have combined their experiences of working with customers in Oracle Support, Oracle training and education, and Oracle consulting, to identify the most common areas of confusion and misinterpretation experienced by Oracle Streams users. This book highlights these areas and focuses on bringing clarity and understanding to the reader.
Who this book is for
This book is for users who have implemented, or are about to implement, a distributed database environment using Oracle Streams replication. The reader is expected to have an intermediate understanding of Oracle database technology.
This book is mainly intended for use by:
- Oracle Database Administrators responsible for the implementation and maintenance of an Oracle Streamed environment
- System and Database Architects responsible for the design of distributed database environments using Oracle Streams
Readers with limited knowledge of basic Oracle database technology can benefit from Chapters 1 and 2, which cover Oracle Streams Components and Design Considerations.