Oracle 11g Streams implementer's guide :: design, implement, and maintain a distributed environment with Oracle Streams /
Annotation
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Weitere Verfasser: | |
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham, U.K. :
Packt Pub.,
©2010.
|
| Schriftenreihe: | From technologies to solutions.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | Annotation |
| Beschreibung: | Includes index. |
| Beschreibung: | 1 online resource (vi, 332 pages) : illustrations. |
| ISBN: | 9781847199713 1847199712 1847199704 9781847199706 |
Internformat
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocn560654847 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 100319s2010 enka o 001 0 eng d | ||
| 040 | |a UMI |b eng |e pn |c UMI |d COO |d CEF |d N$T |d E7B |d OCLCQ |d B24X7 |d DEBSZ |d UKMGB |d OCLCQ |d C6I |d OCLCQ |d DKDLA |d YDXCP |d OCLCQ |d OCLCF |d OCLCQ |d AGLDB |d MOR |d PIFAG |d ZCU |d LIV |d MERUC |d OCLCQ |d JBG |d OCLCQ |d OCLCO |d LENOT |d U3W |d STF |d WRM |d VTS |d ICG |d INT |d VT2 |d AU@ |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d DKC |d OCLCQ |d M8D |d UKAHL |d HS0 |d OCLCO |d OCLCQ |d OCLCO |d OCLCL | ||
| 016 | 7 | |a 015853217 |2 Uk | |
| 019 | |a 706457001 |a 764550687 |a 765143506 |a 961562948 |a 962626509 |a 988439683 |a 991916530 |a 1012672018 |a 1037792544 |a 1038633351 |a 1055393656 |a 1058129631 |a 1081294286 |a 1086339783 |a 1103277904 |a 1119767580 |a 1129374909 |a 1153055154 |a 1228586599 | ||
| 020 | |a 9781847199713 |q (electronic bk.) | ||
| 020 | |a 1847199712 |q (electronic bk.) | ||
| 020 | |a 1847199704 | ||
| 020 | |a 9781847199706 | ||
| 020 | |z 9781847199706 | ||
| 035 | |a (OCoLC)560654847 |z (OCoLC)706457001 |z (OCoLC)764550687 |z (OCoLC)765143506 |z (OCoLC)961562948 |z (OCoLC)962626509 |z (OCoLC)988439683 |z (OCoLC)991916530 |z (OCoLC)1012672018 |z (OCoLC)1037792544 |z (OCoLC)1038633351 |z (OCoLC)1055393656 |z (OCoLC)1058129631 |z (OCoLC)1081294286 |z (OCoLC)1086339783 |z (OCoLC)1103277904 |z (OCoLC)1119767580 |z (OCoLC)1129374909 |z (OCoLC)1153055154 |z (OCoLC)1228586599 | ||
| 037 | |a CL0500000060 |b Safari Books Online | ||
| 050 | 4 | |a QA76.9.D3 |b Mc54 2010 | |
| 072 | 7 | |a COM |x 018000 |2 bisacsh | |
| 082 | 7 | |a 005.75/85 |2 22 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a McKinnell, Ann L. R. | |
| 245 | 1 | 0 | |a Oracle 11g Streams implementer's guide : |b design, implement, and maintain a distributed environment with Oracle Streams / |c Ann L.R. McKinnell, Eric Yen. |
| 260 | |a Birmingham, U.K. : |b Packt Pub., |c ©2010. | ||
| 300 | |a 1 online resource (vi, 332 pages) : |b illustrations. | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 490 | 1 | |a From technologies to solutions | |
| 500 | |a Includes index. | ||
| 520 | 8 | |a Annotation |b 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.<br /><br />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.<br /><br />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.<br /><br />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. | |
| 505 | 0 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 630 | 0 | 0 | |a Oracle (Computer file) |0 http://id.loc.gov/authorities/names/n91015760 |
| 630 | 0 | 4 | |a Oracle (Computer file) |
| 630 | 0 | 7 | |a Oracle (Computer file) |2 blmlsh |
| 630 | 0 | 7 | |a Oracle (Computer file) |2 fast |
| 650 | 0 | |a Database management. |0 http://id.loc.gov/authorities/subjects/sh85035848 | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 7 | |a COMPUTERS |x Data Processing. |2 bisacsh | |
| 650 | 7 | |a Database management. |2 blmlsh | |
| 650 | 7 | |a Database management |2 fast | |
| 700 | 1 | |a Yen, Eric. | |
| 758 | |i has work: |a Oracle 11g Streams implementer's guide (Text) |1 https://id.oclc.org/worldcat/entity/E39PCH6tkMbjXPjJpcRF4bgmMP |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a McKinnell, Ann L.R. |t Oracle 11g Streams implementer's guide. |d Birmingham, U.K. : Packt Pub., ©2010 |z 9781847199706 |
| 830 | 0 | |a From technologies to solutions. |0 http://id.loc.gov/authorities/names/no2008038412 | |
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=357209 |3 Volltext |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26943127 | ||
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26942311 | ||
| 938 | |a Books 24x7 |b B247 |n bks00034082 | ||
| 938 | |a EBSCOhost |b EBSC |n 357209 | ||
| 938 | |a YBP Library Services |b YANK |n 3605053 | ||
| 938 | |a YBP Library Services |b YANK |n 3647490 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-ocn560654847 |
|---|---|
| _version_ | 1816881708389105664 |
| adam_text | |
| any_adam_object | |
| author | McKinnell, Ann L. R. |
| author2 | Yen, Eric |
| author2_role | |
| author2_variant | e y ey |
| author_facet | McKinnell, Ann L. R. Yen, Eric |
| author_role | |
| author_sort | McKinnell, Ann L. R. |
| author_variant | a l r m alr alrm |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D3 Mc54 2010 |
| callnumber-search | QA76.9.D3 Mc54 2010 |
| callnumber-sort | QA 276.9 D3 M C54 42010 |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBA |
| contents | 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 |
| ctrlnum | (OCoLC)560654847 |
| dewey-full | 005.75/85 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/85 |
| dewey-search | 005.75/85 |
| dewey-sort | 15.75 285 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>08864cam a2200697 a 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn560654847</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr unu||||||||</controlfield><controlfield tag="008">100319s2010 enka o 001 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">UMI</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">UMI</subfield><subfield code="d">COO</subfield><subfield code="d">CEF</subfield><subfield code="d">N$T</subfield><subfield code="d">E7B</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">B24X7</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">UKMGB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">C6I</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">DKDLA</subfield><subfield code="d">YDXCP</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCF</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">AGLDB</subfield><subfield code="d">MOR</subfield><subfield code="d">PIFAG</subfield><subfield code="d">ZCU</subfield><subfield code="d">LIV</subfield><subfield code="d">MERUC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">JBG</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">LENOT</subfield><subfield code="d">U3W</subfield><subfield code="d">STF</subfield><subfield code="d">WRM</subfield><subfield code="d">VTS</subfield><subfield code="d">ICG</subfield><subfield code="d">INT</subfield><subfield code="d">VT2</subfield><subfield code="d">AU@</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">DKC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">M8D</subfield><subfield code="d">UKAHL</subfield><subfield code="d">HS0</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">015853217</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">706457001</subfield><subfield code="a">764550687</subfield><subfield code="a">765143506</subfield><subfield code="a">961562948</subfield><subfield code="a">962626509</subfield><subfield code="a">988439683</subfield><subfield code="a">991916530</subfield><subfield code="a">1012672018</subfield><subfield code="a">1037792544</subfield><subfield code="a">1038633351</subfield><subfield code="a">1055393656</subfield><subfield code="a">1058129631</subfield><subfield code="a">1081294286</subfield><subfield code="a">1086339783</subfield><subfield code="a">1103277904</subfield><subfield code="a">1119767580</subfield><subfield code="a">1129374909</subfield><subfield code="a">1153055154</subfield><subfield code="a">1228586599</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781847199713</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1847199712</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1847199704</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781847199706</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781847199706</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)560654847</subfield><subfield code="z">(OCoLC)706457001</subfield><subfield code="z">(OCoLC)764550687</subfield><subfield code="z">(OCoLC)765143506</subfield><subfield code="z">(OCoLC)961562948</subfield><subfield code="z">(OCoLC)962626509</subfield><subfield code="z">(OCoLC)988439683</subfield><subfield code="z">(OCoLC)991916530</subfield><subfield code="z">(OCoLC)1012672018</subfield><subfield code="z">(OCoLC)1037792544</subfield><subfield code="z">(OCoLC)1038633351</subfield><subfield code="z">(OCoLC)1055393656</subfield><subfield code="z">(OCoLC)1058129631</subfield><subfield code="z">(OCoLC)1081294286</subfield><subfield code="z">(OCoLC)1086339783</subfield><subfield code="z">(OCoLC)1103277904</subfield><subfield code="z">(OCoLC)1119767580</subfield><subfield code="z">(OCoLC)1129374909</subfield><subfield code="z">(OCoLC)1153055154</subfield><subfield code="z">(OCoLC)1228586599</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">CL0500000060</subfield><subfield code="b">Safari Books Online</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.9.D3</subfield><subfield code="b">Mc54 2010</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">018000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.75/85</subfield><subfield code="2">22</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">McKinnell, Ann L. R.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Oracle 11g Streams implementer's guide :</subfield><subfield code="b">design, implement, and maintain a distributed environment with Oracle Streams /</subfield><subfield code="c">Ann L.R. McKinnell, Eric Yen.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Birmingham, U.K. :</subfield><subfield code="b">Packt Pub.,</subfield><subfield code="c">©2010.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (vi, 332 pages) :</subfield><subfield code="b">illustrations.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">From technologies to solutions</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index.</subfield></datafield><datafield tag="520" ind1="8" ind2=" "><subfield code="a">Annotation</subfield><subfield code="b">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.<br /><br />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.<br /><br />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.<br /><br />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.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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</subfield></datafield><datafield tag="630" ind1="0" ind2="0"><subfield code="a">Oracle (Computer file)</subfield><subfield code="0">http://id.loc.gov/authorities/names/n91015760</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Oracle (Computer file)</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">Oracle (Computer file)</subfield><subfield code="2">blmlsh</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">Oracle (Computer file)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85035848</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Gestion.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Data Processing.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management.</subfield><subfield code="2">blmlsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management</subfield><subfield code="2">fast</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Yen, Eric.</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">Oracle 11g Streams implementer's guide (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCH6tkMbjXPjJpcRF4bgmMP</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">McKinnell, Ann L.R.</subfield><subfield code="t">Oracle 11g Streams implementer's guide.</subfield><subfield code="d">Birmingham, U.K. : Packt Pub., ©2010</subfield><subfield code="z">9781847199706</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">From technologies to solutions.</subfield><subfield code="0">http://id.loc.gov/authorities/names/no2008038412</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=357209</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH26943127</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH26942311</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Books 24x7</subfield><subfield code="b">B247</subfield><subfield code="n">bks00034082</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">357209</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">3605053</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">3647490</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBA-ocn560654847 |
| illustrated | Illustrated |
| indexdate | 2024-11-27T13:17:01Z |
| institution | BVB |
| isbn | 9781847199713 1847199712 1847199704 9781847199706 |
| language | English |
| oclc_num | 560654847 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource (vi, 332 pages) : illustrations. |
| psigel | ZDB-4-EBA |
| publishDate | 2010 |
| publishDateSearch | 2010 |
| publishDateSort | 2010 |
| publisher | Packt Pub., |
| record_format | marc |
| series | From technologies to solutions. |
| series2 | From technologies to solutions |
| spelling | McKinnell, Ann L. R. Oracle 11g Streams implementer's guide : design, implement, and maintain a distributed environment with Oracle Streams / Ann L.R. McKinnell, Eric Yen. Birmingham, U.K. : Packt Pub., ©2010. 1 online resource (vi, 332 pages) : illustrations. text txt rdacontent computer c rdamedia online resource cr rdacarrier From technologies to solutions Includes index. Annotation 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.<br /><br />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.<br /><br />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.<br /><br />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. 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 Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760 Oracle (Computer file) Oracle (Computer file) blmlsh Oracle (Computer file) fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Bases de données Gestion. COMPUTERS Data Processing. bisacsh Database management. blmlsh Database management fast Yen, Eric. has work: Oracle 11g Streams implementer's guide (Text) https://id.oclc.org/worldcat/entity/E39PCH6tkMbjXPjJpcRF4bgmMP https://id.oclc.org/worldcat/ontology/hasWork Print version: McKinnell, Ann L.R. Oracle 11g Streams implementer's guide. Birmingham, U.K. : Packt Pub., ©2010 9781847199706 From technologies to solutions. http://id.loc.gov/authorities/names/no2008038412 FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=357209 Volltext |
| spellingShingle | McKinnell, Ann L. R. Oracle 11g Streams implementer's guide : design, implement, and maintain a distributed environment with Oracle Streams / From technologies to solutions. 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 Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760 Oracle (Computer file) Oracle (Computer file) blmlsh Oracle (Computer file) fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Bases de données Gestion. COMPUTERS Data Processing. bisacsh Database management. blmlsh Database management fast |
| subject_GND | http://id.loc.gov/authorities/names/n91015760 http://id.loc.gov/authorities/subjects/sh85035848 |
| title | Oracle 11g Streams implementer's guide : design, implement, and maintain a distributed environment with Oracle Streams / |
| title_auth | Oracle 11g Streams implementer's guide : design, implement, and maintain a distributed environment with Oracle Streams / |
| title_exact_search | Oracle 11g Streams implementer's guide : design, implement, and maintain a distributed environment with Oracle Streams / |
| title_full | Oracle 11g Streams implementer's guide : design, implement, and maintain a distributed environment with Oracle Streams / Ann L.R. McKinnell, Eric Yen. |
| title_fullStr | Oracle 11g Streams implementer's guide : design, implement, and maintain a distributed environment with Oracle Streams / Ann L.R. McKinnell, Eric Yen. |
| title_full_unstemmed | Oracle 11g Streams implementer's guide : design, implement, and maintain a distributed environment with Oracle Streams / Ann L.R. McKinnell, Eric Yen. |
| title_short | Oracle 11g Streams implementer's guide : |
| title_sort | oracle 11g streams implementer s guide design implement and maintain a distributed environment with oracle streams |
| title_sub | design, implement, and maintain a distributed environment with Oracle Streams / |
| topic | Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760 Oracle (Computer file) Oracle (Computer file) blmlsh Oracle (Computer file) fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Bases de données Gestion. COMPUTERS Data Processing. bisacsh Database management. blmlsh Database management fast |
| topic_facet | Oracle (Computer file) Database management. Bases de données Gestion. COMPUTERS Data Processing. Database management |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=357209 |
| work_keys_str_mv | AT mckinnellannlr oracle11gstreamsimplementersguidedesignimplementandmaintainadistributedenvironmentwithoraclestreams AT yeneric oracle11gstreamsimplementersguidedesignimplementandmaintainadistributedenvironmentwithoraclestreams |