ISBN: xxx ISBN 13: xxx Library of Congress Number: TBD xxx Pages - perfect bind 9x7 Publication Date - 0512 Shelving Databases/Oracle Oracle In-Focus Series  # xx

Oracle Streams High Speed Replication and Data Sharing Second Edition   Retail Price $xx.xx /  £xx.xx         Key Features   About the Author Reader Comments Table of Contents   Index 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. This second edition book shares secrets for achieving high-speed replication and data sharing. Using proven techniques from mission-critical application, this book shows the front-line secrets for ensuring success with Oracle Streams. From installation through implementation, this book  provides step-by-step instruction to ensure your success with these powerful Oracle features.

* 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:

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

Index:

Reader Comments:

Errata: