Categories
Ebooks
-
Business and economy
- Bitcoin
- Businesswoman
- Coaching
- Controlling
- E-business
- Economy
- Finances
- Stocks and investments
- Personal competence
- Computer in the office
- Communication and negotiation
- Small company
- Marketing
- Motivation
- Multimedia trainings
- Real estate
- Persuasion and NLP
- Taxes
- Social policy
- Guides
- Presentations
- Leadership
- Public Relation
- Reports, analyses
- Secret
- Social Media
- Sales
- Start-up
- Your career
- Management
- Project management
- Human Resources
-
For children
-
For youth
-
Education
-
Encyclopedias, dictionaries
-
E-press
- Architektura i wnętrza
- Biznes i Ekonomia
- Home and garden
- E-business
- Finances
- Personal finance
- Business
- Photography
- Computer science
- HR & Payroll
- Computers, Excel
- Accounts
- Culture and literature
- Scientific and academic
- Environmental protection
- Opinion-forming
- Education
- Taxes
- Travelling
- Psychology
- Religion
- Agriculture
- Book and press market
- Transport and Spedition
- Healthand beauty
-
History
-
Computer science
- Office applications
- Data bases
- Bioinformatics
- IT business
- CAD/CAM
- Digital Lifestyle
- DTP
- Electronics
- Digital photography
- Computer graphics
- Games
- Hacking
- Hardware
- IT w ekonomii
- Scientific software package
- School textbooks
- Computer basics
- Programming
- Mobile programming
- Internet servers
- Computer networks
- Start-up
- Operational systems
- Artificial intelligence
- Technology for children
- Webmastering
-
Other
-
Foreign languages
-
Culture and art
-
School reading books
-
Literature
- Antology
- Ballade
- Biographies and autobiographies
- For adults
- Dramas
- Diaries, memoirs, letters
- Epic, epopee
- Essay
- Fantasy and science fiction
- Feuilletons
- Work of fiction
- Humour and satire
- Other
- Classical
- Crime fiction
- Non-fiction
- Fiction
- Mity i legendy
- Nobelists
- Novellas
- Moral
- Okultyzm i magia
- Short stories
- Memoirs
- Travelling
- Narrative poetry
- Poetry
- Politics
- Popular science
- Novel
- Historical novel
- Prose
- Adventure
- Journalism, publicism
- Reportage novels
- Romans i literatura obyczajowa
- Sensational
- Thriller, Horror
- Interviews and memoirs
-
Natural sciences
-
Social sciences
-
School textbooks
-
Popular science and academic
- Archeology
- Bibliotekoznawstwo
- Cinema studies
- Philology
- Polish philology
- Philosophy
- Finanse i bankowość
- Geography
- Economy
- Trade. World economy
- History and archeology
- History of art and architecture
- Cultural studies
- Linguistics
- Literary studies
- Logistics
- Maths
- Medicine
- Humanities
- Pedagogy
- Educational aids
- Popular science
- Other
- Psychology
- Sociology
- Theatre studies
- Theology
- Economic theories and teachings
- Transport i spedycja
- Physical education
- Zarządzanie i marketing
-
Guides
-
Game guides
-
Professional and specialist guides
-
Law
- Health and Safety
- History
- Road Code. Driving license
- Law studies
- Healthcare
- General. Compendium of knowledge
- Academic textbooks
- Other
- Construction and local law
- Civil law
- Financial law
- Economic law
- Economic and trade law
- Criminal law
- Criminal law. Criminal offenses. Criminology
- International law
- International law
- Health care law
- Educational law
- Tax law
- Labor and social security law
- Public, constitutional and administrative law
- Family and Guardianship Code
- agricultural law
- Social law, labour law
- European Union law
- Industry
- Agricultural and environmental
- Dictionaries and encyclopedia
- Public procurement
- Management
-
Tourist guides and travel
- Africa
- Albums
- Southern America
- North and Central America
- Australia, New Zealand, Oceania
- Austria
- Asia
- Balkans
- Middle East
- Bulgary
- China
- Croatia
- The Czech Republic
- Denmark
- Egipt
- Estonia
- Europe
- France
- Mountains
- Greece
- Spain
- Holand
- Iceland
- Lithuania
- Latvia
- Mapy, Plany miast, Atlasy
- Mini travel guides
- Germany
- Norway
- Active travelling
- Poland
- Portugal
- Other
- Russia
- Romania
- Slovakia
- Slovenia
- Switzerland
- Sweden
- World
- Turkey
- Ukraine
- Hungary
- Great Britain
- Italy
-
Psychology
- Philosophy of life
- Kompetencje psychospołeczne
- Interpersonal communication
- Mindfulness
- General
- Persuasion and NLP
- Academic psychology
- Psychology of soul and mind
- Work psychology
- Relacje i związki
- Parenting and children psychology
- Problem solving
- Intellectual growth
- Secret
- Sexapeal
- Seduction
- Appearance and image
- Philosophy of life
-
Religion
-
Sport, fitness, diets
-
Technology and mechanics
Audiobooks
-
Business and economy
- Bitcoin
- Businesswoman
- Coaching
- Controlling
- E-business
- Economy
- Finances
- Stocks and investments
- Personal competence
- Communication and negotiation
- Small company
- Marketing
- Motivation
- Real estate
- Persuasion and NLP
- Taxes
- Guides
- Presentations
- Leadership
- Public Relation
- Secret
- Social Media
- Sales
- Start-up
- Your career
- Management
- Project management
- Human Resources
-
For children
-
For youth
-
Education
-
Encyclopedias, dictionaries
-
History
-
Computer science
-
Other
-
Foreign languages
-
Culture and art
-
School reading books
-
Literature
- Antology
- Ballade
- Biographies and autobiographies
- For adults
- Dramas
- Diaries, memoirs, letters
- Epic, epopee
- Essay
- Fantasy and science fiction
- Feuilletons
- Work of fiction
- Humour and satire
- Other
- Classical
- Crime fiction
- Non-fiction
- Fiction
- Mity i legendy
- Nobelists
- Novellas
- Moral
- Okultyzm i magia
- Short stories
- Memoirs
- Travelling
- Poetry
- Politics
- Popular science
- Novel
- Historical novel
- Prose
- Adventure
- Journalism, publicism
- Reportage novels
- Romans i literatura obyczajowa
- Sensational
- Thriller, Horror
- Interviews and memoirs
-
Natural sciences
-
Social sciences
-
Popular science and academic
-
Guides
-
Professional and specialist guides
-
Law
-
Tourist guides and travel
-
Psychology
- Philosophy of life
- Interpersonal communication
- Mindfulness
- General
- Persuasion and NLP
- Academic psychology
- Psychology of soul and mind
- Work psychology
- Relacje i związki
- Parenting and children psychology
- Problem solving
- Intellectual growth
- Secret
- Sexapeal
- Seduction
- Appearance and image
- Philosophy of life
-
Religion
-
Sport, fitness, diets
-
Technology and mechanics
Videocourses
-
Data bases
-
Big Data
-
Biznes, ekonomia i marketing
-
Cybersecurity
-
Data Science
-
DevOps
-
For children
-
Electronics
-
Graphics/Video/CAX
-
Games
-
Microsoft Office
-
Development tools
-
Programming
-
Personal growth
-
Computer networks
-
Operational systems
-
Software testing
-
Mobile devices
-
UX/UI
-
Web development
-
Management
Podcasts
E-book details
Log in, If you're interested in the contents of the item.
Oracle GoldenGate 11g Implementer's guide. Design, install, and configure high-performance data replication solutions using Oracle GoldenGate
Ebook
Data replication is an important part of any database system that is growing due to today's demand for real-time reporting and regulatory requirements. GoldenGate has recently become Oracle's strategic real-time data replication solution. Until now, very little has been written about how to implement GoldenGate in a production enterprise environment where performance, scalability, and data integrity are paramount.
Your days of dismay over the lack of documentation over Oracle GoldenGate are over.
Welcome to Oracle GoldenGate 11g Implementer's guide – a comprehensive practical book, which will deliver answers to your questions in a clear, concise style, allowing you to progress effectively in a timeline-driven environment. Based on the author's own experience, this long awaited GoldenGate administration book has all that is required to install, design, configure, and tune data replication solutions suited to every environment. Be the first to master GoldenGate's power and flexibility by reading this unique hands-on implementation companion.
Systems need to send data from one system to another in a timely manner to satisfy the ever-increasing need for speed. Regardless of whether you are a novice or an expert – or someone in between – this book will guide you through all the steps necessary to build a high-performance GoldenGate solution on Oracle11gR1. Expert users can dive into key topic areas such as performance tuning or troubleshooting, while novice users can step through the early installation and configuration chapters, later progressing to the advanced chapters.
This book is more than an implementation guide. It offers detailed real-life examples, encouraging additional thought and discussion by going beyond the manual.
With Oracle GoldenGate 11g Implementer's guide in hand, you'll be designing, installing, and configuring high-performance solutions using GoldenGate in less time than you can say replicate
Your days of dismay over the lack of documentation over Oracle GoldenGate are over.
Welcome to Oracle GoldenGate 11g Implementer's guide – a comprehensive practical book, which will deliver answers to your questions in a clear, concise style, allowing you to progress effectively in a timeline-driven environment. Based on the author's own experience, this long awaited GoldenGate administration book has all that is required to install, design, configure, and tune data replication solutions suited to every environment. Be the first to master GoldenGate's power and flexibility by reading this unique hands-on implementation companion.
Systems need to send data from one system to another in a timely manner to satisfy the ever-increasing need for speed. Regardless of whether you are a novice or an expert – or someone in between – this book will guide you through all the steps necessary to build a high-performance GoldenGate solution on Oracle11gR1. Expert users can dive into key topic areas such as performance tuning or troubleshooting, while novice users can step through the early installation and configuration chapters, later progressing to the advanced chapters.
This book is more than an implementation guide. It offers detailed real-life examples, encouraging additional thought and discussion by going beyond the manual.
With Oracle GoldenGate 11g Implementer's guide in hand, you'll be designing, installing, and configuring high-performance solutions using GoldenGate in less time than you can say replicate
- Oracle GoldenGate 11g Implementers guide
- Table of Contents
- Oracle GoldenGate 11g Implementer's guide
- Credits
- Foreword
- About the Author
- About the Reviewers
- www.PacktPub.com
- Support files, eBooks, discount offers and more
- Why Subscribe?
- Free Access for Packt account holders
- Instant Updates on New Packt Books
- Support files, eBooks, discount offers and more
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Errata
- Piracy
- Questions
- 1. Getting Started
- What is GoldenGate?
- Oracle GoldenGate evolution
- Oracle GoldenGate solutions
- Oracle GoldenGate technology overview
- The capture process (Extract)
- Trail files
- Data Pump
- Server Collector
- The Apply process (Replicat)
- The Manager process
- GGSCI
- Process data flow
- Oracle GoldenGate architecture
- One-to-One
- One-to-Many
- Many-to-One
- Cascading
- Bi-directional (Active-Active)
- Bi-directional (Active-Passive)
- Supported platforms and databases
- Oracle Goldengate topology
- Process topology
- The rules
- Position
- Statistics
- Process topology
- Design considerations
- Choosing a solution
- Network
- Database schema
- What to Replicate?
- Object mapping and data selection
- Initial Load
- CSN co-ordination
- Trail file format
- Summary
- 2. Installing and Preparing GoldenGate
- Prerequisites
- Downloading the software
- Software requirements
- Hardware requirements
- Memory
- CPU
- Network
- Disk
- Software installation
- Installing GoldenGate
- The subdirectories
- dirchk
- dirdat
- dirdef
- dirpcs
- dirprm
- dirrpt
- dirsql
- dirtmp
- Preparing the environment
- Preparing the database for data replication
- Enabling supplemental logging
- Preparing the operating system
- Preparing the database for data replication
- Creating the initial configuration
- Creating the GoldenGate administrator
- The Manager process
- The Extract process
- Creating and starting an Extract process
- The Data Pump process
- The Replicat process
- Creating and starting a Replicat process
- Configuration summary
- Uninstalling GoldenGate from Linux/UNIX
- Summary
- Prerequisites
- 3. Design Considerations
- Replication methods
- Active-active
- Active-passive
- Cascading
- Physical Standby
- Networking
- Surviving network outages
- Redundant networks
- NIC teaming
- Redundant networks
- Surviving network outages
- Non-functional requirements (NFRs)
- Latency
- Availability
- Backup and recovery
- Hardware considerations
- Computing architectures
- Grid computing
- Single server
- Clusters
- Machines
- The x86-64 Linux Server
- The Database Machine
- Scaling up and out
- Computing architectures
- Changed data management
- Point in Time Recovery (PITR)
- Oracle Recovery Manager (RMAN)
- Flashback
- SAN Snapshot
- Point in Time Recovery (PITR)
- Summary
- Replication methods
- 4. Configuring Oracle GoldenGate
- GoldenGate parameters
- Configuring the Initial Load
- Choosing a method
- File to Replicat
- Extract parameters
- Replicat parameters
- File to database utility
- Extract parameters
- Replicat parameters
- Direct Load
- Extract parameters
- Replicat parameters
- Direct Bulk Load
- Extract parameters
- Replicat parameters
- File to Replicat
- Choosing a method
- Performing the Initial Load
- Example architecture
- File to Replicat method
- Configuring Initial Data Capture
- Configuring Initial Data Delivery
- Configuring Change Data Capture
- Configuring Change Delivery
- Testing Change Data Capture and Delivery
- Stopping GoldenGate processes
- More about trail files
- The trail
- Trail file purging
- Configuring the Manager process
- Summary
- 5. Configuration Options
- Using BATCHSQL
- SQL cache
- Exceptions
- When to use BATCHSQL
- Data compression
- Compressing the Data Stream
- The COMPRESS option
- Oracle table compression
- Compressing the Data Stream
- Security features
- Data encryption
- Password encryption
- Default method
- Named method
- Event Actions
- Event Records
- Bi-directional configuration options
- Loop detection
- Conflict detection
- Conflict resolution
- Oracle sequences
- Oracle triggers
- Heterogeneous environments
- Specific options
- Microsoft SQL Server
- IBM DB2
- The DEFGEN utility
- Specific options
- DDL replication
- The DDL parameter
- Filtering
- Mapping options
- Initial setup
- Known issues
- Using DUMPDDL
- DDL OPTIONS
- The DDL parameter
- Summary
- Using BATCHSQL
- 6. Configuring GoldenGate for HA
- GoldenGate on RAC
- Shared storage
- Automatic Storage Management Cluster File System (ACFS)
- Database File System (DBFS)
- Configuring Clusterware for GoldenGate
- The Virtual IP
- Creating a GoldenGate application
- Increasing system resilience
- Shared storage
- GoldenGate on Exadata
- Configuration
- Creating the Extract process
- Creating the Replicat process
- Configuration
- Failover
- Automatic failover
- Manual failover
- Relocating a service
- Relocating a VIP
- Summary
- GoldenGate on RAC
- 7. Advanced Configuration
- Mapping your data
- Column mapping
- Using the COLMAP option
- The COLMATCH option
- Using the DEFGEN utility
- Column mapping
- Data selection and filtering
- The WHERE clause
- The FILTER clause
- Loop detection
- Active-active
- Cascade
- Data transformation
- Truncation and extraction
- Concatenation
- Substitution
- Case changing
- Numeric conversions
- Date conversions
- DDL support
- The SQLEXEC parameter
- Data lookups
- Executing stored procedures
- Executing SQL
- Executing DML
- Handling errors
- Scheduling jobs
- Data lookups
- Using and defining macros
- User tokens
- User Exits
- Calling C routines
- Sample User Exits
- Source files explained
- Using logic in data replication
- Licensing
- Summary
- Mapping your data
- 8. Managing Oracle GoldenGate
- Command level security
- The CMDSEC file
- Trail file management
- Managing process startup
- Managing TCP/IP errors
- The tcperrs file
- Reporting and statistics
- Monitoring errors
- Monitoring latency
- A bespoke solution to monitoring and reporting
- Graphing the results using Microsoft Excel
- A bespoke solution to monitoring and reporting
- Measuring throughput
- Data throughput
- Operation throughput
- Summary
- Command level security
- 9. Performance Tuning
- Before tuning GoldenGate
- Online redo
- Large objects (LOBs)
- Base lining
- Balancing the load across parallel process groups
- Considerations for using parallel process groups
- Splitting large tables into row ranges across process groups
- The RANGE function
- Adding Replicats with @RANGE function
- The RANGE function
- Configuring multiple parallel process groups
- Source system configuration
- Parallel process parameter files
- Creating extract parallel process groups
- Target system configuration
- Parallel process parameter files
- Creating Replicat parallel process groups
- Improving Replicat throughput
- Source system configuration
- New releases
- DBFS enhancements
- New redo log OCI API
- Tuning the network
- Linux TCP tuning
- Configuring a Bequeath connection
- Summary
- Before tuning GoldenGate
- 10. Troubleshooting GoldenGate
- Troubleshooting tips
- Replication not working?
- The CHECKPARAMS parameter
- Adjusting the start point
- Altering Extract processes in RAC environments
- Checking process checkpoints
- Investigating network issues
- TCP/IP
- SQL*Net
- Investigating Oracle errors
- Replication not working?
- Exception handling
- Creating an Exceptions handler
- Viewing Exceptions
- Before and after images
- Handling Oracle Sequences
- Using LOGDUMP
- Opening files
- Viewing the header record
- Viewing the transaction record
- Miscellaneous commands
- Filtering records
- Upgrading GoldenGate
- Summary
- Troubleshooting tips
- A. GGSCI Commands
- B. GoldenGate Installed Components
- C. The Future of Oracle GoldenGate
- Index
- Title: Oracle GoldenGate 11g Implementer's guide. Design, install, and configure high-performance data replication solutions using Oracle GoldenGate
- Author: John P Jeffries
- Original title: Oracle GoldenGate 11g Implementer's guide. Design, install, and configure high-performance data replication solutions using Oracle GoldenGate
- ISBN: 9781849682015, 9781849682015
- Date of issue: 2011-02-22
- Format: Ebook
- Item ID: e_3axu
- Publisher: Packt Publishing