- Oracle 11g Streams Implementer's Guide
- Oracle 11g Streams Implementer's Guide
- Credits
- About the Authors
- About the Reviewers
- Preface
- 1. All the Pieces: The Parts of an Oracle 11g Streams Environment
- Streams architecture overview
- About those Queues
- Capture process—what are we supposed to stream?
- Instantiation
- Propagate process
- Apply process
- Combined Capture and Apply
- SCN Coordination—keeps it flowing smoothly
- LCRs—what they are and how they work
- Oracle 11g memory and storage architecture (basic) relating to Streams
- A word on performance
- Streams Change tables
- Oracle GoldenGate XSTREAMS
- Summary
- 2. Plot Your Course: Design Considerations
- 3. Prepare the Rafts and Secure Your Gear: The pre-work before configuring Oracle 11g Streams
- 4. Single-Source Configuration
- 5. N-Way Replication
- 6. Get Fancy with Streams Advanced Configurations
- Synchronous Capture—straight to the Queue
- Subsetting — the micro side of replication
- Tag! — you're it
- RULES — they're what we live by
- Downstream Capture — avoid white water at the source
- Streams change tables — just tracking the "Facts" Ma'am
- Automatic propagation split and merge — redirecting the current
- Basic Heterogeneous Configuration
- Basic XSTREAMS Configuration
- XSTREAMS Servers
- Configuring the Database
- Configuring XSTREAMS Out
- Steps for configuring an XSTREAMS Outbound Server
- Configuring XSTREAMS In
- 7. Document What You Have and How It Is Working
- 8. Dealing with the Ever Constant Tides of Change
- Affecting expected change effectively
- Troubleshooting unexpected changes and resulting Streams errors
- Failure Points and Most Likely Causes (a.k.a. FPs and MLCs)
- Failure Point 1: DML/DDL statement commit logging
- Failure Point 2: LogMiner
- Failure Point 3: Capture process and rules
- Failure Point 4: Capture enqueue
- Failure Point 5: Propagation dequeue from Capture queue
- Failure Point 6: Propagation Rules
- Failure Point 7: Database link configuration
- Failure Point 8: Network connectivity and stability
- Failure Point 9: Propagation enqueue to the Apply queue
- Failure Point 10: Apply dequeue
- Failure Point 11: Apply Rules
- Failure Point 12: Conflict detection and resolution rules
- Failure Point 13: Apply Errors
- Troubleshooting tools
- Failure Points and Most Likely Causes (a.k.a. FPs and MLCs)
- Summary
- 9. Appendix and Glossary
- XSTREAMS Servers
This book is not for the novice Oracle DBA. In order to gain the most out of this book, you should have a good background as a working Oracle DBA and have a good familiarity with the Oracle Streams Components mentioned in Chapter 1. However, Chapters 1 and 2 may prove helpful to the novice in gaining a high-level understanding of Streams architecture and components, and design considerations.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.