- 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
Authors
Ann L. R. McKinnell
Eric Yen
Reviewer
Shekar Kadur
Lavanya Kompella
Acquisition Editor
James Lumsden
Development Editor
Dilip Venkatesh
Technical Editors
Neha Damle
Arani Roy
Copy Editor
Sanchari Mukherjee
Indexer
Rekha Nair
Production Editorial Manager
Abhijeet Deobhakta
Editorial Team Leader
Gagandeep Singh
Project Team Leader
Lata Basantani
Project Coordinator
Poorvi Nair
Proofreader
Andie Scothern
Production Coordinator
Aparna Bhagat
Cover Work
Aparna Bhagat
Graphics
Nilesh R. Mohite
Geetanjali Sawant
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.