| |
|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNINA9910826157603321 |
|
|
Autore |
McKinnell Ann L. R |
|
|
Titolo |
Oracle 11g Streams implementer's guide : design, implement, and maintain a distributed environment with Oracle Streams / / Ann L.R. McKinnell [and] Eric Yen |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Birmingham, U.K., : Packt Pub., 2010 |
|
|
|
|
|
|
|
ISBN |
|
1-282-50184-4 |
9786612501845 |
1-84719-971-2 |
|
|
|
|
|
|
|
|
Edizione |
[1st ed.] |
|
|
|
|
|
Descrizione fisica |
|
1 online resource (352 p.) |
|
|
|
|
|
|
Collana |
|
From technologies to solutions |
|
|
|
|
|
|
Altri autori (Persone) |
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
Database management |
Distributed databases |
Electronic data processing - Distributed processing |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
|
|
|
|
|
Nota di contenuto |
|
Cover; Copyright; Credits; About the Authors; About the Reviewers; Table of Contents; Preface; Chapter 1: All the Pieces: The Parts of an Oracle 11g Streams Environment; Streams architecture overview; Topology configurations; Single source; Multiple source; Simultaneous versus Synchronous replication; Oracle's Streams replication process flow; Streams components; About those Queues; Capture process-what are we supposed to stream?; Downstream Capture; Synchronous Capture; Instantiation; What sets the instantiation SCN and when?; Propagate process; The Network: COMLINK |
Propagation success/failurePropagation Stream Split and Merge; Apply process; Trigger firing and Apply; Combined Capture and Apply; SCN Coordination-keeps it flowing smoothly; The SCNs of Capture; FIRST_SCN; START_SCN; REQUIRED_CHECKPOINT_SCN; CAPTURED_SCN; APPLIED_SCN; MAXIMUM_SCN; LAST_ENQUEUED_SCN; SOURCE_RESETLOGS_SCN; MAX_CHECKPOINT_SCN; The SCNs of Propagation; The SCNs of Apply; IGNORE_SCN; MAXIMUM_SCN; OLDEST_SCN_NUM; Low-watermark SCN; SCN SYNC-hronization; Capture checkpointing; Archive Log availability; LCRs-what they are |
|
|
|
|
|
|
|
|
|
|
|
and how they work; Extracting data from an LCR |
Conflict detection and the LCRControlling conflict detection; Types of LCRs and how they get created; 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; Network capabilities; Transaction sizes; Potential queue growth; Additional hardware resource requirements; Administration and maintenance costs; Third party application requirements; Security; Change auditing |
Platform and version compatibilityKISS; Design aid: Streams site matrix; The Matrix template; Summary; Chapter 3: Prepare the Rafts and Secure Your Gear: The pre-work before configuring Oracle 11g Streams; Network connectivity; Check the waterways; Configure the Oracle Net ""Current""; Configure the database; Initialization parameters; Logging features; Archive logging; Supplemental logging; Forced logging; Separate tablespaces; LogMiner tablespace; Streams Administration tablespace; Streams users and privileges; Trusted Streams Administrator user configuration |
Untrusted Streams capture, propagation, and apply user configurationStreams Administration user; Capture user; Propagation user; Apply user; Database links; Trusted versus untrusted configurations; Understanding your Instantiation tools; Using Data Pump to Instantiate; Setting Instantiation SCN manually; Oracle Demo Schemas; Summary; Chapter 4: Single-Source Configuration; The stream flows one way: Downhill; The Enterprise Manager; Setup options; Schedule Streams setup job; Verify; The code behind the curtain; Checking the waters; Diving in |
The proof is in the pudding (or propagation in this case) |
|
|
|
|
|
|
Sommario/riassunto |
|
Design, implement, and maintain a distributed environment with Oracle Streams using this book and eBook |
|
|
|
|
|
|
|
| |