Oracle 11g Streams Implementer's Guide

Design, implement, and maintain a distributed environment with Oracle Streams using this book and eBook
Preview in Mapt

Oracle 11g Streams Implementer's Guide

Ann L. R. McKinnell, Eric Yen

Design, implement, and maintain a distributed environment with Oracle Streams using this book and eBook
Mapt Subscription
FREE
$29.99/m after trial
eBook
$25.20
RRP $35.99
Save 29%
Print + eBook
$59.99
RRP $59.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$25.20
$59.99
$29.99p/m after trial
RRP $35.99
RRP $59.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


Oracle 11g Streams Implementer's Guide  Book Cover
Oracle 11g Streams Implementer's Guide
$ 35.99
$ 25.20
Oracle GoldenGate 11g Implementer's guide Book Cover
Oracle GoldenGate 11g Implementer's guide
$ 32.99
$ 23.10
Buy 2 for $35.00
Save $33.98
Add to Cart
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 

Book Details

ISBN 139781847199706
Paperback352 pages

Book Description

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

Chapter 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
Chapter 2: Plot Your Course: Design Considerations
Why?
What?
Where?
Who and How?
When and How?
Other factors to consider
Summary
Chapter 3: Prepare the Rafts and Secure Your Gear: The pre-work before configuring Oracle 11g Streams
Network connectivity
Configure the database
Streams users and privileges
Understanding your Instantiation tools
Oracle Demo Schemas
Summary
Chapter 4: Single-Source Configuration
The stream flows one way: Downhill
Summary
Chapter 5: N-Way Replication
Pre-planning for N-way replication
Avoiding conflict
The setup
Conflict resolution
Extending the example
Rinse and repeat
Summary
Chapter 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
Chapter 7: Document What You Have and How It Is Working
Mapping the Stream
The Stream without a map
DBMS_STREAMS_ADVISOR_ADM
Basic Streams views
UTL_SPADV
Summary
Chapter 8: Dealing with the Ever Constant Tides of Change
Affecting expected change effectively
Troubleshooting unexpected changes and resulting Streams errors
Summary
Chapter 9: Appendix and Glossary
Oracle Streams Commander
Streams and Oracle RAC
Oracle GoldenGate
Glossary
Summary

What You Will Learn

  • 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

Authors

Table of Contents

Chapter 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
Chapter 2: Plot Your Course: Design Considerations
Why?
What?
Where?
Who and How?
When and How?
Other factors to consider
Summary
Chapter 3: Prepare the Rafts and Secure Your Gear: The pre-work before configuring Oracle 11g Streams
Network connectivity
Configure the database
Streams users and privileges
Understanding your Instantiation tools
Oracle Demo Schemas
Summary
Chapter 4: Single-Source Configuration
The stream flows one way: Downhill
Summary
Chapter 5: N-Way Replication
Pre-planning for N-way replication
Avoiding conflict
The setup
Conflict resolution
Extending the example
Rinse and repeat
Summary
Chapter 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
Chapter 7: Document What You Have and How It Is Working
Mapping the Stream
The Stream without a map
DBMS_STREAMS_ADVISOR_ADM
Basic Streams views
UTL_SPADV
Summary
Chapter 8: Dealing with the Ever Constant Tides of Change
Affecting expected change effectively
Troubleshooting unexpected changes and resulting Streams errors
Summary
Chapter 9: Appendix and Glossary
Oracle Streams Commander
Streams and Oracle RAC
Oracle GoldenGate
Glossary
Summary

Book Details

ISBN 139781847199706
Paperback352 pages
Read More

Read More Reviews

Recommended for You

Oracle Database 11gR2 Performance Tuning Cookbook Book Cover
Oracle Database 11gR2 Performance Tuning Cookbook
$ 32.99
$ 23.10
Oracle GoldenGate 11g Implementer's guide Book Cover
Oracle GoldenGate 11g Implementer's guide
$ 32.99
$ 23.10
Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos Book Cover
Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos
$ 38.99
$ 27.30
Moodle 1.9 Theme Design: Beginner's Guide Book Cover
Moodle 1.9 Theme Design: Beginner's Guide
$ 26.99
$ 18.90
Oracle Database 11g - Underground Advice for Database Administrators Book Cover
Oracle Database 11g - Underground Advice for Database Administrators
$ 29.99
$ 21.00
Oracle 11g R1/R2 Real Application Clusters Essentials Book Cover
Oracle 11g R1/R2 Real Application Clusters Essentials
$ 41.99
$ 29.40