ISBN 0-9745993-5-2 ISBN 13 978-0974599359 Library of Congress Number: 2004096471 304 pages: Perfect bind - 9x7 Shelving: Database/Oracle Oracle In-Focus Series #20

Oracle Streams High Speed Replication and Data Sharing Madhu Tumma Retail Price $27.95 / £20.95 Order now and get immediate online access to the code depot! Only $19.95 (30% off) Key Features About the Author Table of Contents Index Reader Comments Errata

Oracle Streams is a high-speed tool that allows synchronization of replicated databases across the globe and an indispensable feature for any company using Oracle for global eCommerce. A noted and respected Oracle author, Madhu Tumma shares his secrets for achieving high-speed replication and data sharing. Using proven techniques from mission-critical application, Tumma show the front-line secrets for ensuring success with Oracle Streams. From installation through implementation, Tumma provides step-by-step instruction to ensure your success with these powerful Oracle features. Tumma walks you safely through the myriad of complex Oracle Streams tasks including the set-up of the staging area queue, propagation through data hubs, customized apply functions, rule-based data propagation, Oracle Streams transformation, and lots, lots more. Best of all, Tumma shares working code examples to allow you to easily manage even the most complex Oracle Streams implementation.

* Learn expert secrets for high speed data replication * Understand the successful installation and configuration techniques * Use Oracle Streams to create a reliable failover database * Achieve global data sharing and seamless data replication * Learn the tricks to easily manage subscribed destinations * Get working scripts to improve streams management * Learn to customize data apply functions * Understands tricks for rule-based propagation and data transformations

About the Author:

Madhu Tumma

Madhu Tumma has been working as Software Developer, IT Manager, Database Administrator, and Technical Consultant for about 18 years. He has worked on a wide variety of projects and environments ranging from mainframe, client-server, eBusiness to managed services. He has provided consultancy to variety of clients on database clusters, business continuity and high availability solutions. His experience ranges across multiple relational database systems. Madhu is frequent speaker at Oracle World and IOUG where he presented many technical papers. Madhu has Master Degree in science and attended Business Management graduate program. He lives in New Jersey with his wife Hema and two children Sandi and Sudeep.

Table of Contents:

I INTRODUCTION Data Sharing • Growing Need • Global Operations • Heterogeneous Systems Data Synchronization • Data Movement • Data Transformation • Data Migration • Data Replication What is Oracle Streams? Why Oracle Streams? Where to use Streams Mechanism • Replication • AQ – Advanced Queuing • Event Management • Data Loading • Summarization of Data • High Availability and Disaster Recovery Streams Historical Growth • Advanced Replication • Advanced Queuing Related Oracle Technologies • Log Miner • Standby – Data Guard Peer Products • Sybase Replication • Quest Shareplex • GoldenGate • Data Mirror II Streams Components and Processes Producer and Consumer LCR Object • Row LCR • DDL LCR • Additional Attributes Hot Mining and Cold Mining Log based Changes Capture Process Propagation of Changes Apply Process Queuing and Dequeuing Rules and Rules Engine • Application of Rules • Transformation • Contexts Streams Tags Directed Network DownStreams Capture Change Data Capture LogMiner Supplemental Logging Sys.Anydata Object DML Handlers III Streams Replication Source • Database Changes • User Application Message Destination Database Data Types for Replication Rules • Rule Set • Capture Rules • Propagation Rules • Apply Rules • Contexts • Transformations Instantiation • Capture process for Instantiation • Oracle Data Pump for Instantiation • Export and Import for Instantiation The Role of Streams Tags • How to create • Utility of Tags • Tags for Apply Process Methodology Examples

IV Capture and Propagation Configuration Capture Mechanism • Data Types • DML Changes and Considerations (I, U, U, D and M) • Types of DDL(s) • NoLogging and Unrecoverable • Supplemental Logging • Instantiation • Local v/s DownStream • The Role of SCN • In Restricted Session Capture Process • Components • Capture States • Multiple Processes • Rule Evaluation • Parallelism Propagation and Staging • Schedules • Configuration • Monitoring Application of Rules • Rule Set • Capture Rules • Propagation Rules V Apply Configuration Apply Process • DML Handlers Application of Rules • Rule Set • Apply Rules • Contexts • Transformations Methodology Examples VI Troubleshooting and Monitoring Conflict Detection Conflict Resolution Monitoring Streams Data Flow Helpful Scenarios VII Heterogeneous Data Replication Heterogeneous Data Sharing Oracle to Non-Oracle • Capture process • Instantiation • Data Types • Apply process • Heterogeneous Services • Database link Non-Oracle to Oracle User Application VIII Event Management - Messaging Event Propagation Advanced Queuing IX Data Loading – Data Warehousing Data Loading CDC – Change Data Capture X Downstream Capture Log Transportation Services DBMS_FILE_TRANSFER XI RAC and Streams Multiple Instances Multiple Buffers XII Using OEM Oracle Enterprise Manager Grid Control Appendix a) Oracle Supplied Packages b) Data Dictionary – Views