舉報(bào) 
會(huì)員
Oracle Goldengate 11g Complete Cookbook
最新章節(jié)：
Index
OracleGoldengate11gCompleteCookbookfollowstheCookbookstyle.Eachrecipeprovidesstepbystepinstructionswithvariousexamplesandscripts.Thisbookprovidesthenecessaryinformationtosuccessfullycompletemostofthepossibleadministrationtasks.OracleGoldengate11gCompleteCookbookisaimedatDatabaseAdministrators,Architects,andMiddlewareAdministratorswhoarekeentoknowmoreaboutOracleGoldengate.WhetheryouarehandlingGoldengateenvironmentsonaday-to-daybasis,orusingitjustformigration,thisbookprovidesthenecessaryinformationrequiredtosuccessfullycompleteyouradministrationtasks.ThereaderisexpectedtohavesomeknowledgeofOracledatabases.
目錄(96章)
倒序
- 封面
- 版權(quán)信息
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Preface
- Chapter 1. Installation and Initial Setup
- Introduction
- Installing Oracle GoldenGate in a x86_64 Linux-based environment
- Installing Oracle GoldenGate in a Windows environment
- Enabling supplemental logging in the source database
- Supported datatypes in Oracle GoldenGate
- Preparing the source database for GoldenGate setup
- Preparing the target database for GoldenGate setup
- Setting up a Manager process
- Setting up a Classic Capture Extract process
- Setting up an Integrated Capture Extract process
- Setting up a Datapump process
- Setting up a Replicat process
- Chapter 2. Setting up GoldenGate Replication
- Introduction
- Setting up a simple GoldenGate replication configuration between two single node databases
- Setting up a GoldenGate replication with multiple process groups
- Configuring an Extract process to read from an Oracle ASM instance
- Setting up a GoldenGate replication between Oracle RAC databases
- Determining the size of trail file areas
- Verifying the data transfer on the target system
- Generating encryption keys
- Encrypting database user passwords
- Encrypting the trail files
- Setting up a GoldenGate replication between tables with different structures using defgen
- Chapter 3. DDL Replication and Initial Load
- Introduction
- Performing an initial setup required for GoldenGate DDL replication
- Setting up a GoldenGate DDL replication and verifying the changes
- Performing an initial load using GoldenGate
- Performing an initial load using an extract file to the GoldenGate's replicat method
- Loading data using trail files to the Replicat process method
- Loading data with files to the database utility method
- Loading data with the GoldenGate direct load method
- Loading data with bulk load to the SQL loader method
- Chapter 4. Mapping and Manipulating Data
- Introduction
- Setting up a GoldenGate replication with mapping between different columns
- Adding custom fields for a replicated record using tokens
- Adding custom fields to a replicated record using SQLEXEC
- Filtering the records using the FILTER and WHERE clause
- Mapping the changes to a target table and storing the transaction history in a history table
- Creating a GoldenGate configuration to run a Shell script when an end-of-day processing record is replicated
- Creating an exception handler to record the erroneous transactions in a GoldenGate configuration
- Chapter 5. Oracle GoldenGate High Availability
- Introduction
- Choosing a GoldenGate high availability option
- Creating a highly available GoldenGate configuration using Oracle Clusterware and ACFS
- Creating a highly available GoldenGate configuration using Oracle Clusterware and OCFS2
- Creating a highly available GoldenGate configuration using Oracle Clusterware and DBFS
- Manually switching over Oracle Clusterware-based configuration to the other node
- Automatic failover of a DBFS-based configuration
- Creating a set of parallel load balanced highly available GoldenGate configurations using Oracle Clusterware and DBFS
- Chapter 6. Monitoring Tuning and Troubleshooting GoldenGate
- Introduction
- Steps to configure a BATCHSQL mode
- Splitting the replication load into multiple process groups for optimal performance
- Optimizing the network settings for a GoldenGate configuration
- Performing a healthcheck of a live GoldenGate configuration
- Script to perform a regular scheduled healthcheck of a live GoldenGate configuration
- Steps to measure throughput of a GoldenGate configuration
- Steps to re-instantiate a failed GoldenGate configuration
- Steps to implement a Heartbeat mechanism for the GoldenGate replication
- Chapter 7. Advanced Administration Tasks – I
- Introduction
- Upgrading Oracle GoldenGate binaries
- Table structure changes in GoldenGate environments with similar table definitions
- Table structure changes in GoldenGate environments with different table definitions
- Resolving GoldenGate errors using the logdump utility
- Undoing the applied changes using the reverse utility
- Creating an Integrated Capture with a downstream database for compressed tables
- Chapter 8. Advanced Administration Tasks – Part II
- Introduction
- Creating a GoldenGate configuration with a consistent state behind the target database
- Replicating data from an active standby database in Archivelog mode only
- Migrating from an Oracle Streams environment to Oracle GoldenGate
- GoldenGate Administration role separation from the DBA team
- Cross RDBMS replication using GoldenGate
- Creating a multimaster GoldenGate replication configuration
- Chapter 9. GoldenGate Veridata Director and Monitor
- Introduction
- Setting up the Oracle GoldenGate Monitor server
- Setting up Oracle GoldenGate Monitor Agents
- Installing Oracle GoldenGate Director
- Installing and using Oracle GoldenGate Director Client to manage the GoldenGate instances
- Steps to set up the GoldenGate monitoring using OEM 12c
- Steps to install Oracle GoldenGate Veridata
- Steps to compare data between the source and target environment using Oracle GoldenGate Veridata
- Index 更新時(shí)間：2021-08-04 10:00:11
推薦閱讀
- 操作系統(tǒng)實(shí)用教程（Linux版）
- Cybersecurity：Attack and Defense Strategies
- 阿里云數(shù)字新基建系列：云原生操作系統(tǒng)Kubernetes
- WordPress Mobile Web Development：Beginner's Guide
- 嵌入式Linux系統(tǒng)開(kāi)發(fā)：基于Yocto Project
- Docker+Kubernetes應(yīng)用開(kāi)發(fā)與快速上云
- Linux使用和管理指南：從云原生到可觀測(cè)性
- Windows 7案例教程
- Kali Linux高級(jí)滲透測(cè)試
- 寫(xiě)給架構(gòu)師的Linux實(shí)踐：設(shè)計(jì)并實(shí)現(xiàn)基于Linux的IT解決方案
- Linux應(yīng)用大全 基礎(chǔ)與管理
- Agile IT Security Implementation Methodology
- 完美應(yīng)用Ubuntu（第2版）
- 辦公自動(dòng)化教程（Windows7+Office2010）
- Implementing Cloud Design Patterns for AWS（Second Edition）
- 程序員必讀經(jīng)典（算法基礎(chǔ)+計(jì)算機(jī)系統(tǒng)）
- Getting Started with Citrix XenApp 6.5
- Instant Responsive Web Design
- Windows PE權(quán)威指南
- 蘋(píng)果派
- Oracle Goldengate 11g Complete Cookbook
- Command Line Fundamentals
- 蘋(píng)果Mac OS X El Capitan 10.11完全手冊(cè)
- The Node Craftsman Book
- React Native Blueprints
- INSTANT HTML5 Presentations How-to
- Creating templates with Artisteer
- 我的第一本操作系統(tǒng)書(shū)（安裝、重裝與維護(hù)）
- Linux從初學(xué)到精通
- Linux嵌入式系統(tǒng)開(kāi)發(fā)從小白到大牛
