舉報 
會員
Oracle Goldengate 11g Complete Cookbook
最新章節：
Index
OracleGoldengate11gCompleteCookbookfollowstheCookbookstyle.Eachrecipeprovidesstepbystepinstructionswithvariousexamplesandscripts.Thisbookprovidesthenecessaryinformationtosuccessfullycompletemostofthepossibleadministrationtasks.OracleGoldengate11gCompleteCookbookisaimedatDatabaseAdministrators,Architects,andMiddlewareAdministratorswhoarekeentoknowmoreaboutOracleGoldengate.WhetheryouarehandlingGoldengateenvironmentsonaday-to-daybasis,orusingitjustformigration,thisbookprovidesthenecessaryinformationrequiredtosuccessfullycompleteyouradministrationtasks.ThereaderisexpectedtohavesomeknowledgeofOracledatabases.
最新章節
- Index
- Steps to compare data between the source and target environment using Oracle GoldenGate Veridata
- Steps to install Oracle GoldenGate Veridata
- Steps to set up the GoldenGate monitoring using OEM 12c
- Installing and using Oracle GoldenGate Director Client to manage the GoldenGate instances
- Installing Oracle GoldenGate Director
品牌：中圖公司
上架時間：2021-08-04 09:45:37
出版社：Packt Publishing
本書數字版權由中圖公司提供，并由其授權上海閱文信息技術有限公司制作發行
- Index 更新時間：2021-08-04 10:00:11
- Steps to compare data between the source and target environment using Oracle GoldenGate Veridata
- Steps to install Oracle GoldenGate Veridata
- Steps to set up the GoldenGate monitoring using OEM 12c
- Installing and using Oracle GoldenGate Director Client to manage the GoldenGate instances
- Installing Oracle GoldenGate Director
- Setting up Oracle GoldenGate Monitor Agents
- Setting up the Oracle GoldenGate Monitor server
- Introduction
- Chapter 9. GoldenGate Veridata Director and Monitor
- Creating a multimaster GoldenGate replication configuration
- Cross RDBMS replication using GoldenGate
- GoldenGate Administration role separation from the DBA team
- Migrating from an Oracle Streams environment to Oracle GoldenGate
- Replicating data from an active standby database in Archivelog mode only
- Creating a GoldenGate configuration with a consistent state behind the target database
- Introduction
- Chapter 8. Advanced Administration Tasks – Part II
- Creating an Integrated Capture with a downstream database for compressed tables
- Undoing the applied changes using the reverse utility
- Resolving GoldenGate errors using the logdump utility
- Table structure changes in GoldenGate environments with different table definitions
- Table structure changes in GoldenGate environments with similar table definitions
- Upgrading Oracle GoldenGate binaries
- Introduction
- Chapter 7. Advanced Administration Tasks – I
- Steps to implement a Heartbeat mechanism for the GoldenGate replication
- Steps to re-instantiate a failed GoldenGate configuration
- Steps to measure throughput of a GoldenGate configuration
- Script to perform a regular scheduled healthcheck of a live GoldenGate configuration
- Performing a healthcheck of a live GoldenGate configuration
- Optimizing the network settings for a GoldenGate configuration
- Splitting the replication load into multiple process groups for optimal performance
- Steps to configure a BATCHSQL mode
- Introduction
- Chapter 6. Monitoring Tuning and Troubleshooting GoldenGate
- Creating a set of parallel load balanced highly available GoldenGate configurations using Oracle Clusterware and DBFS
- Automatic failover of a DBFS-based configuration
- Manually switching over Oracle Clusterware-based configuration to the other node
- Creating a highly available GoldenGate configuration using Oracle Clusterware and DBFS
- Creating a highly available GoldenGate configuration using Oracle Clusterware and OCFS2
- Creating a highly available GoldenGate configuration using Oracle Clusterware and ACFS
- Choosing a GoldenGate high availability option
- Introduction
- Chapter 5. Oracle GoldenGate High Availability
- Creating an exception handler to record the erroneous transactions in a GoldenGate configuration
- Creating a GoldenGate configuration to run a Shell script when an end-of-day processing record is replicated
- Mapping the changes to a target table and storing the transaction history in a history table
- Filtering the records using the FILTER and WHERE clause
- Adding custom fields to a replicated record using SQLEXEC
- Adding custom fields for a replicated record using tokens
- Setting up a GoldenGate replication with mapping between different columns
- Introduction
- Chapter 4. Mapping and Manipulating Data
- Loading data with bulk load to the SQL loader method
- Loading data with the GoldenGate direct load method
- Loading data with files to the database utility method
- Loading data using trail files to the Replicat process method
- Performing an initial load using an extract file to the GoldenGate's replicat method
- Performing an initial load using GoldenGate
- Setting up a GoldenGate DDL replication and verifying the changes
- Performing an initial setup required for GoldenGate DDL replication
- Introduction
- Chapter 3. DDL Replication and Initial Load
- Setting up a GoldenGate replication between tables with different structures using defgen
- Encrypting the trail files
- Encrypting database user passwords
- Generating encryption keys
- Verifying the data transfer on the target system
- Determining the size of trail file areas
- Setting up a GoldenGate replication between Oracle RAC databases
- Configuring an Extract process to read from an Oracle ASM instance
- Setting up a GoldenGate replication with multiple process groups
- Setting up a simple GoldenGate replication configuration between two single node databases
- Introduction
- Chapter 2. Setting up GoldenGate Replication
- Setting up a Replicat process
- Setting up a Datapump process
- Setting up an Integrated Capture Extract process
- Setting up a Classic Capture Extract process
- Setting up a Manager process
- Preparing the target database for GoldenGate setup
- Preparing the source database for GoldenGate setup
- Supported datatypes in Oracle GoldenGate
- Enabling supplemental logging in the source database
- Installing Oracle GoldenGate in a Windows environment
- Installing Oracle GoldenGate in a x86_64 Linux-based environment
- Introduction
- Chapter 1. Installation and Initial Setup
- Preface
- www.PacktPub.com
- About the Reviewers
- About the Author
- Credits
- 版權信息
- 封面
- 封面
- 版權信息
- 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 更新時間：2021-08-04 10:00:11
