Index
A
- ACFS
- about / ASM Cluster File System (ACFS)
- advantages / ASM Cluster File System (ACFS)
- used, for creating GoldenGate configuration / Creating a highly available GoldenGate configuration using Oracle Clusterware and ACFS, How to do it..., How it works...
- Add button / How to do it...
- ADD EXTRACT command / How it works…
- ADD TRANDATA command / There's more…
- AES128 algorithm / How it works…
- AES192 algorithm / How it works…
- AES256 algorithm / How it works…
- ALTER TABLE ADD SUPPLEMENTAL LOG DATA command / There's more…
- appvipcfg command / How it works..., How it works...
- Archivelog mode
- data, replicating from active standby database / Replicating data from an active standby database in Archivelog mode only, How to do it…, How it works...
- ASSUMETARGETDEFS parameter / There's more…, How it works…
- Autorestart ER* parameter / How it works…
- Autostart ER* parameter / How it works…
- AUTOSTART parameter / How it works...
B
- BATCHERRORMODE parameter / There's more…
- BATCHESPERQUEUE parameter / How it works...
- BATCHSQL / How to do it...
- BATCHSQL mode
- configuring / Steps to configure a BATCHSQL mode, How it works..., There's more…
- BATCHSQL parameter / There's more…
- BATCHTRANSOPS parameter / How it works...
- BLOWFISH algorithm / How it works…
- BYTESPERQUEUE parameter / How it works...
C
- CAPLAG column / There's more...
- CAPTIME column / There's more...
- Certificate Authority (CA) / Installing the GoldenGate Monitor server using HTTPS
- Certificate Signing Request (CSR) / Installing the GoldenGate Monitor server using HTTPS
- Classic Capture Extract process
- Classic Capture mode / The Classic Capture mode
- CMDSEC file / How to do it…
- COLMAP clause / How it works...
- count command / Count
- CREATE SUBDIRS command / How it works...
- crontab / There's more...
- crsctl command / How it works...
- custom field
- adding for replicating record, tokens used / Adding custom fields for a replicated record using tokens, How to do it..., How it works..., There's more...
- adding to replicated record, SQLEXEC used / Adding custom fields to a replicated record using SQLEXEC, Getting ready, How to do it..., There's more...
D
- data
- loading, trail files used to Replicat process method / Loading data using trail files to the Replicat process method, Getting ready, How to do it..., How it works...
- loading, with file to database utility method / Loading data with files to the database utility method, Getting ready, How to do it..., How it works...
- loading, with GoldenGate direct load / Loading data with the GoldenGate direct load method, Getting ready, How to do it..., How it works..., There's more...
- loading, with bulk load to SQL loader method / Loading data with bulk load to the SQL loader method, How to do it..., How it works...
- replicating, from active standby database in Archivelog mode / Replicating data from an active standby database in Archivelog mode only, How to do it…, How it works...
- database user passwords
- encrypting / Encrypting database user passwords, How to do it…, How it works…
- database utility method
- data, loading with file / Loading data with files to the database utility method, Getting ready, How to do it..., How it works...
- data collision avoidance
- about / Data collision avoidance
- data collision resolution
- timestamp-based / Timestamp-based
- trusted source, defining / Defined trusted source
- Datapump Parameter file / How to do it...
- Datapump process
- setting up / Setting up a Datapump process, How to do it…, There's more…
- Datapumps processes / How it works...
- data throughput / Steps to measure throughput of a GoldenGate configuration
- data transfer
- verifying, on target system / Verifying the data transfer on the target system, How to do it..., There's more...
- DBA team
- separating, from DBA team / Getting ready, How to do it…, How it works...
- DBFS
- about / Database File System (DBFS)
- used, for creating GoldenGate configuration / Creating a highly available GoldenGate configuration using Oracle Clusterware and DBFS, How to do it..., How it works..., Creating a set of parallel load balanced, highly available GoldenGate configurations using Oracle Clusterware and DBFS, How to do it..., How it works...
- DBFS based GoldenGate configuration
- automatic failover / Automatic failover of a DBFS-based configuration, How to do it..., How it works...
- relocating / Manual relocation of a DBFS-based GoldenGate configuration
- dbfsdb / Getting ready
- DBFS repository
- creating, in dbfsdb database / How to do it...
- DBORATES / Getting ready
- dborates / How to do it...
- dboratest / Getting ready
- DDL EXCLUDE parameter / Filtering and mapping
- DDL INCLUDE parameter / How it works..., Filtering and mapping
- DDLOPTIONS
- ADDTRANDATA / Additional DDLOPTIONS
- REPORT / Additional DDLOPTIONS
- DDLOPTIONS ADDTRANDATA / Additional DDLOPTIONS
- DDLOPTIONS ADDTRANDATA option / Additional DDLOPTIONS
- DDLOPTIONS parameters / How it works...
- DDLOPTIONS REPORT / Additional DDLOPTIONS
- DDL parameter / How it works...
- DDL replication
- GoldenGate environment, using / Performing an initial setup required for GoldenGate DDL replication, How it works..., There's more...
- ddl_enable.sql script / How to do it...
- ddl_setup.sql script / How to do it...
- DECRYPTTRAIL command / How to do it…
- DEFERAPPLYINTERVAL parameter / How it works...
- DEFERAPPLYINTERVAL unit / DEFERAPPLYINTERVAL UNITS
- defgen
- used, for setting up GoldenGate replication / Setting up a GoldenGate replication between tables with different structures using defgen, How to do it…, How it works…
- defgen utility / How it works…
- definitions file / How it works…
- DELETE record / Getting ready
- Delete statement / There's more…
- DELGROUP column / There's more...
- DELLAG column / There's more...
- DELTIME column / There's more...
- dirdat directory / How to do it..., How it works...
- discard file / How to do it..., How it works...
- DISCARDFILE parameter / There's more…
- DISCARD option / There's more...
- downstrm / Getting ready
- dump file / How to do it..., How it works...
- Dynamic port list parameter / How it works…
- DYNAMICRESOLUTION parameter / There's more…, There's more…, There's more…
E
- EDDLDELTASTATS column / There's more...
- EDMLDELTASTATS column / There's more...
- EGGREV / How it works...
- egrep command / How to do it...
- ENCKEYS file / How to do it…, How it works…, Getting ready
- encryption keys
- generating / Generating encryption keys, How to do it…
- ENCRYPT PASSWORD command / How to do it…, How it works…
- ENCRYPTTRAIL command / How to do it…
- ENCRYPT utility / Encrypting database user passwords
- EOFDELAY secs parameter / There's more…, There's more…, There's more…
- erroneous transactions
- recording, for creating exception handler / Creating an exception handler to record the erroneous transactions in a GoldenGate configuration, How to do it..., How it works..., There's more..., Handle exceptions with a MACRO
- exception handler
- creating, for recording erroneous transactions / Creating an exception handler to record the erroneous transactions in a GoldenGate configuration, How to do it..., How it works..., There's more..., Handle exceptions with a MACRO
- exceptions
- handling, with MACRO / Handle exceptions with a MACRO
- EXCLUDE parameter / Filtering and mapping
- EXTFILE parameter / How it works...
- extract file
- used, for performing initial load / Performing an initial load using an extract file to the GoldenGate's replicat method, Getting ready, How to do it..., How it works...
- extract process
- configuring, to read from Oracle ASM instance / Configuring an Extract process to read from an Oracle ASM instance, How to do it…, How it works…
- Extracts processes / How it works...
- EXTRACT_NAME column / There's more...
- EXTTRAIL command / How to do it…
F
- file
- data, loading to database utility method / Loading data with files to the database utility method, Getting ready, How to do it..., How it works...
- FILTER
- used, for filtering records / Filtering the records using the FILTER and WHERE clause, How it works..., There's more..., Filtering the records into parallel groups
- FILTER clause / How it works..., Filtering in the source environment, How it works...
- FILTER command / Filtering the records using the FILTER and WHERE clause, There's more...
- filter on csn command / Filter on SCN
- FORMATASCII parameter / There's more...
G
- General Purpose File System option / How to do it...
- GETAPPLOPS parameter / How it works...
- GETREPLICATES parameter / How it works...
- GETUPDATEBEFORES option / There's more...
- GETUPDATEBEFORES parameter / How it works...
- GGATE_ADMIN schema / How it works...
- GGSCI
- about / How to do it…
- ggsci command / How it works...
- GGSCI commands / How it works...
- ggserr.log file / How to do it...
- global mappings
- about / Defining global mappings
- GLOBALS parameter / There's more…
- global SQL procedure
- running / Running a global SQL statement/procedure
- global SQL statement
- running / Running a global SQL statement/procedure
- GoldenGate
- used, for performing initial load / Performing an initial load using GoldenGate, Getting ready, How to do it..., File to the database utility method, See also
- schema changes, with similar table definitions / Table structure changes in GoldenGate environments with similar table definitions, Getting ready, How to do it…, Specific tables defined in GoldenGate parameter files
- schema changes, with different table definitions / Table structure changes in GoldenGate environments with different table definitions, How to do it..., There's more…
- used, for RDBMS replication / Cross RDBMS replication using GoldenGate, Getting ready, How to do it..., How it works...
- GoldenGate Administration role
- separating, from DBA team / GoldenGate Administration role separation from the DBA team, How to do it…, How it works...
- GoldenGate Admin user
- GoldenGate configuration
- creating, to run Shell script / Creating a GoldenGate configuration to run a Shell script when an end-of-day processing record is replicated, How to do it..., How it works...
- creating, Oracle Clusterware used / Creating a highly available GoldenGate configuration using Oracle Clusterware and ACFS, How to do it..., How it works..., Creating a highly available GoldenGate configuration using Oracle Clusterware and OCFS2, How to do it..., How it works..., Creating a highly available GoldenGate configuration using Oracle Clusterware and DBFS, How to do it..., How it works..., Creating a set of parallel load balanced, highly available GoldenGate configurations using Oracle Clusterware and DBFS, How to do it..., How it works...
- creating, ACFS used / Creating a highly available GoldenGate configuration using Oracle Clusterware and ACFS, How to do it..., How it works...
- creating, OCFS2 used / Getting ready, How to do it..., How it works...
- creating, DBFS used / Creating a highly available GoldenGate configuration using Oracle Clusterware and DBFS, How to do it..., How it works..., Creating a set of parallel load balanced, highly available GoldenGate configurations using Oracle Clusterware and DBFS, Getting ready, How to do it..., How it works...
- network settings, optimizing / Optimizing the network settings for a GoldenGate configuration, Getting ready, How to do it..., How it works...
- healthcheck, performing / Performing a healthcheck of a live GoldenGate configuration, How to do it..., How it works...
- healthcheck, performing by script / Script to perform a regular scheduled healthcheck of a live GoldenGate configuration, How to do it..., How it works...
- throughput, measuring / Steps to measure throughput of a GoldenGate configuration , How to do it..., How it works..., There's more..., Stats command options, See also
- failure, re-instantiating / Steps to re-instantiate a failed GoldenGate configuration, How to do it..., How it works...
- creating, with consistent state behind target database / Creating a GoldenGate configuration with a consistent state behind the target database, How to do it..., How it works..., Why use deferred apply
- GoldenGate DDL replication
- GoldenGate direct load
- data, loading with / Loading data with the GoldenGate direct load method, Getting ready, How to do it..., How it works..., There's more...
- GoldenGate environment
- configuring / Introduction
- used, for DDL replication / Performing an initial setup required for GoldenGate DDL replication, How it works..., There's more...
- GoldenGate errors
- resolving, logdump utility used / Resolving GoldenGate errors using the logdump utility, How to do it..., How it works..., Scan for timestamp, Filter on SCN
- GoldenGate high availability option
- GoldenGate instances
- Oracle GoldenGate Director Client, installing / Installing and using Oracle GoldenGate Director Client to manage the GoldenGate instances, How to do it..., How it works...
- Oracle GoldenGate Director Client, using / Installing and using Oracle GoldenGate Director Client to manage the GoldenGate instances, How to do it..., How it works...
- GoldenGate monitoring
- setting up, Oracle Grid Control 12c used / Steps to set up the GoldenGate monitoring using OEM 12c, How to do it..., How it works..., There's more...
- GoldenGate parameter files
- specific tables, defining / Specific tables defined in GoldenGate parameter files
- GoldenGate replication
- setting up, with multiple process groups / Setting up a GoldenGate replication with multiple process groups, How to do it..., How it works..., There's more...
- setting up, between Oracle RAC databases / Setting up a GoldenGate replication between Oracle RAC databases, Getting ready, How it works…, See also
- setting up, defgen used / Setting up a GoldenGate replication between tables with different structures using defgen, How to do it…, How it works…
- setting up, with mapping between different columns / Setting up a GoldenGate replication with mapping between different columns, How to do it..., How it works..., Source environment mapping
- Heartbeat mechanism, implementing / Steps to implement a Heartbeat mechanism for the GoldenGate replication , Getting ready, How to do it..., How it works..., There's more...
- GoldenGate replication configuration
- setting up, between two single node databases / Setting up a simple GoldenGate replication configuration between two single node databases, How to do it..., How it works..., There's more...
- GoldenGate resources
- relocating, to other nodes / Manually switching over Oracle Clusterware-based configuration to the other node, How it works...
- GoldenGate setup
- source database, preparing for / Preparing the source database for GoldenGate setup, How it works…, There's more…, The Integrated Capture mode
- target database, preparing for / Preparing the target database for GoldenGate setup, How it works…, There's more…
- GoldenGate_action.scr script / How to do it...
- GROUP RPTINIT parameter / How it works...
H
- HANDLECOLLISIONS parameter / Getting ready, How to do it..., How it works..., How to do it..., How to do it..., How to do it..., How it works...
- HANDLECOLLISSIONS parameter / How to do it..., How it works...
- healthcheck
- performing, of live GoldenGate configuration / Performing a healthcheck of a live GoldenGate configuration, How to do it..., How it works..., See also
- Heartbeat / Steps to implement a Heartbeat mechanism for the GoldenGate replication
- Heartbeat mechanism
- implementing, for GoldenGate replication / Steps to implement a Heartbeat mechanism for the GoldenGate replication , Getting ready, How to do it..., How it works..., There's more...
- High Availability / Setting up a GoldenGate replication between Oracle RAC databases
- history table
- transaction history, storing / Mapping the changes to a target table and storing the transaction history in a history table, How to do it..., How it works...
- HTTPS
- used, for installing GoldenGate Monitor server / Installing the GoldenGate Monitor server using HTTPS
I
- ID column / There's more...
- IGNOREAPPLOPS parameter / How it works...
- IGNORE option / There's more...
- IGNOREREPLICATES parameter / How it works...
- INCLUDE clause / Filtering and mapping
- INCLUDE parameter / Filtering and mapping
- info command / How to do it...
- initial load
- performing, GoldenGate used / Performing an initial load using GoldenGate, Getting ready, How to do it..., File to the database utility method, See also
- performing, extract file used / Performing an initial load using an extract file to the GoldenGate's replicat method, Getting ready, How to do it..., How it works...
- INSERTALLRECORDS parameter / How it works..., How it works...
- Insert statement / There's more…
- INSERT statement / Getting ready
- Integrated Capture
- creating, with downstream database for compressed tables / Creating an Integrated Capture with a downstream database for compressed tables, Getting ready, How to do it..., How it works...
- Integrated Capture Extract / Introduction
- Integrated Capture Extract process
- Integrated Capture mode / The Integrated Capture mode
J
- Java Key Store (JKS) / Installing the GoldenGate Monitor server using HTTPS
- JMX (Java Management Extensions) / How it works...
K
- keygen utility / How to do it…
L
- LAG command / How it works...
- LAGREPORT parameter / There's more…
- LCR / The Integrated Capture mode
- LOB datatype / There's more…
- logdump utility
- used, for resolving GoldenGate errors / Resolving GoldenGate errors using the logdump utility, How to do it..., How it works..., Scan for timestamp, Filter on SCN
- LOG option / There's more...
- LONG datatype / There's more…
M
- MACRO
- exceptions, handling / Handle exceptions with a MACRO
- Manager process
- setting up / Setting up a Manager process, How it works…, There's more…
- MAP command / How to do it…, How it works..., Filtering in the source environment
- MAPEXCEPTION method / MAPEXCEPTION method
- mappings
- GoldenGate replication, setting up between different columns / Setting up a GoldenGate replication with mapping between different columns, How to do it..., How it works..., Source environment mapping, Defining mappings using prefix/suffix
- defining, prefix used / Defining mappings using prefix/suffix
- defining, suffix used / Defining mappings using prefix/suffix
- MAP statement / How it works..., How it works..., MAPEXCEPTION method
- MEGABYTES <N> parameter / There's more…, There's more…, There's more…
- mount_dbfs.sh script / How to do it..., How it works...
- multimaster GoldenGate replication configuration
- multiple process groups
- GoldenGate replication, setting up with / Setting up a GoldenGate replication with multiple process groups, How to do it..., How it works..., See also
- replication load, splitting into / Splitting the replication load into multiple process groups for optimal performance, How to do it..., How it works..., There's more…
N
- 2 Node Oracle RAC 11.2.0.3 database / Getting ready
- network settings
- optimizing, for GoldenGate configuration / Optimizing the network settings for a GoldenGate configuration, Getting ready, How to do it..., How it works...
- NOCOMPRESSDELETES option / There's more...
- NOCOMPRESSDELETES parameter / How it works...
O
- OCFS2
- about / Oracle Cluster File System (OCFS2)
- used, for creating GoldenGate configuration / How to do it..., How it works...
- setting up / How to do it...
- URL / How to do it...
- ocfs2console utility / How to do it..., How it works...
- oggdba / How it works...
- oggtest / How to do it...
- operational throughput / Steps to measure throughput of a GoldenGate configuration
- OPSPERBATCH parameter / How it works...
- OPSPERQUEUE parameter / How it works...
- Oracle ASM instance
- extract process, configuring to read from / Configuring an Extract process to read from an Oracle ASM instance, How to do it…, How it works…
- Oracle Clusterware
- used, for creating GoldenGate configuration / Creating a highly available GoldenGate configuration using Oracle Clusterware and ACFS, How to do it..., How it works..., How to do it..., How it works..., Creating a highly available GoldenGate configuration using Oracle Clusterware and DBFS, How to do it..., How it works..., Creating a set of parallel load balanced, highly available GoldenGate configurations using Oracle Clusterware and DBFS, How to do it..., How it works...
- Oracle GoldenGate
- installing, in x86_64 Linux-based environment / Installing Oracle GoldenGate in a x86_64 Linux-based environment, How it works...
- installing, on Windows environment / Installing Oracle GoldenGate in a Windows environment, How it works...
- supported datatypes, installing / Supported datatypes in Oracle GoldenGate, How it works…, There's more…
- Oracle Streams environment, migrating to / Migrating from an Oracle Streams environment to Oracle GoldenGate, How to do it..., How it works...
- Oracle GoldenGate Binaries
- for x86_64 Windows, URL / Getting ready
- Oracle GoldenGate binaries
- for x86_64 Linux, URL / Getting ready
- upgrading / Upgrading Oracle GoldenGate binaries, How to do it..., How it works...
- Oracle GoldenGate Director
- Oracle GoldenGate Director Client
- installing, for managing GoldenGate instances / Installing and using Oracle GoldenGate Director Client to manage the GoldenGate instances, How to do it..., How it works...
- used, for managing GoldenGate instances / Installing and using Oracle GoldenGate Director Client to manage the GoldenGate instances, How to do it..., How it works...
- Oracle GoldenGate Monitor Agents
- Oracle GoldenGate Monitor server
- Oracle GoldenGate Veridata
- installing / Steps to install Oracle GoldenGate Veridata, How to do it..., How it works...
- used, for comparing data between source and target environment / Steps to compare data between the source and target environment using Oracle GoldenGate Veridata , How to do it..., How it works...
- Oracle Grid Control 12c
- used, for setting up GoldenGate monitoring / Steps to set up the GoldenGate monitoring using OEM 12c, How to do it..., How it works..., There's more...
- Oracle RAC / Setting up a GoldenGate replication between Oracle RAC databases
- Oracle RAC databases
- GoldenGate replication, setting up between / Setting up a GoldenGate replication between Oracle RAC databases, Getting ready, How it works…, See also
- Oracle Streams environment
- migrating from, to Oracle GoldenGate / Migrating from an Oracle Streams environment to Oracle GoldenGate, How to do it..., How it works...
- Order Entry schema / How to do it...
P
- parallel groups
- records, filtering into / Filtering the records into parallel groups
- params.sql script / There's more...
- PARAMS clause / Running a stored procedure with SQLEXEC
- PASSTHRU parameter / There's more…
- PMPGROUP column / There's more...
- PMPLAG column / There's more...
- PMPTIME column / There's more...
- Port no parameter / How it works…
- prefix
- used, for defining mappings / Defining mappings using prefix/suffix
- Purgeoldextracts parameter / How it works…
R
- @RANGE function / The RANGE function
- RANGE function / How it works..., There's more..., The RANGE function
- RANGE option / How it works...
- RDBMS replication
- GoldenGate, using / Cross RDBMS replication using GoldenGate, Getting ready, How to do it..., How it works...
- RDDLDELTASTATS column / There's more...
- RDMLDELTASTATS column / There's more...
- records
- filtering, FILTER used / Filtering the records using the FILTER and WHERE clause, How to do it..., There's more..., Filtering the records into parallel groups
- filtering, WHERE clause used / Filtering the records using the FILTER and WHERE clause, How it works..., There's more..., Filtering the records into parallel groups
- filtering, into parallel groups / Filtering the records into parallel groups
- REPERROR (DEFAULT, EXCEPTION) parameter / How it works...
- replicated record
- custom field, adding for / Adding custom fields for a replicated record using tokens, How to do it..., How it works..., There's more...
- custom field, adding to / Adding custom fields to a replicated record using SQLEXEC, Getting ready, How to do it..., There's more...
- replication load
- splitting, into multiple process groups / Splitting the replication load into multiple process groups for optimal performance, How to do it..., How it works..., There's more…
- Replicat process
- setting up / Setting up a Replicat process, How to do it…, How it works…, There's more…
- Replicat process method
- data loading, trail files used / Loading data using trail files to the Replicat process method, Getting ready, How to do it..., How it works...
- Replicats processes / How it works...
- REPORTCOUNT parameter / There's more…
- reverse utility
- used, for reversing changes / Undoing the applied changes using the reverse utility, How to do it..., How it works..., There's more...
- RMTHOSTOPTIONS parameter / There's more…
- RMTHOST parameter / How to do it...
- role_setup.sql script / How to do it...
- Round-Trip Time (RTT) / How to do it...
S
- Scott / Getting ready
- SCOTT schema / Getting ready
- script
- used, for performing healthcheck of GoldenGate configuration / Script to perform a regular scheduled healthcheck of a live GoldenGate configuration, How to do it..., How it works...
- scripts directory / How to do it...
- Shell script
- running, for creating GoldenGate configuration / Creating a GoldenGate configuration to run a Shell script when an end-of-day processing record is replicated, How to do it..., How it works...
- source database
- supplemental log, enabling / Enabling supplemental logging in the source database, How it works…, There's more…
- preparing, for GoldenGate setup / Preparing the source database for GoldenGate setup, How it works…, There's more…, The Integrated Capture mode
- SOURCEDEFS/TARGETDEFS parameter / How it works…
- SOURCEDEFS parameter / How it works...
- source environment
- mapping / Source environment mapping
- filtering / Filtering in the source environment
- SOURCEISTABLE parameter / How it works..., How it works..., How it works...
- SOURCE_COMMIT column / There's more...
- SPECIALRUN parameter / How it works...
- SPNAME option / Running a stored procedure with SQLEXEC
- SQLEXEC
- used, for adding custom field to replicated record / Adding custom fields to a replicated record using SQLEXEC, Getting ready, How to do it..., There's more...
- stored procedure, running with / Running a stored procedure with SQLEXEC
- SQLEXEC clause / How it works...
- SQLEXEC command / How it works..., There's more...
- SQL loader method
- data, loading with bulk load / Loading data with bulk load to the SQL loader method, Getting ready, How to do it..., How it works...
- SQL Server Integration Services (SSIS) / File to the database utility method
- SRC_DB column / There's more...
- standby database
- data replicating from, in Archivelog mode / Getting ready, How to do it…, How it works...
- START command / How it works...
- startmgr / How it works...
- startmgr script / How it works...
- STARTUPVALIDATONDELAY parameter / There's more…
- stats command / There's more...
- STATS command / How to do it..., Stats command options
- stored procedure
- running, with SQLEXEC / Running a stored procedure with SQLEXEC
- suffix
- used, for defining mappings / Defining mappings using prefix/suffix
- supplemental logging
- enabling, in source database / Enabling supplemental logging in the source database, How it works…, There's more…
- supported datatypes
- installing, for Oracle GoldenGate / How it works…, There's more…
T
- TABLE/MAP command / There's more...
- TABLE command / Filtering in the source environment
- TABLE parameter / How it works...
- tables
- defining, in GoldenGate parameter files / Specific tables defined in GoldenGate parameter files
- supplemental logging for / Supplemental logging for modified tables without any keys, Supplemental logging for modified tables without any keys
- Target Database / How it works...
- target database
- preparing, for GoldenGate setup / Preparing the target database for GoldenGate setup, How it works…, There's more…
- GoldenGate configuration, creating / Getting ready, How to do it..., How it works..., Why use deferred apply
- target table
- TARGET_COMMIT column / There's more...
- TCPBUFSIZE option / How to do it...
- TCPBUFSIZE parameter / How it works...
- TCPFLUSHBYTES option / How to do it...
- TCPFLUSHBYTES parameter / How to do it...
- THREAD column / There's more...
- throughput
- measuring, of GoldenGate configuration / Steps to measure throughput of a GoldenGate configuration , How to do it..., How it works..., There's more..., Stats command options, See also
- timestamp-based / Timestamp-based
- tokens
- used, for adding custom field for replicated record / Adding custom fields for a replicated record using tokens, How to do it..., How it works..., There's more...
- TOKENS clause / How it works...
- TOTALLAG column / There's more...
- totalsonly parameter / How it works...
- TRACE option / There's more...
- trail file area size
- calculating / Determining the size of trail file areas, How it works...
- trail files
- encrypting / Encrypting the trail files, How to do it…, How it works…
- used, for loading data to Replicat process method / Loading data using trail files to the Replicat process method, Getting ready, How to do it..., How it works...
- TRANLOGOPTIONS INTEGRATEDPARAMS parameter / There's more…
- transaction history
- storing, in history table / Mapping the changes to a target table and storing the transaction history in a history table, How to do it..., How it works...
- TRANSLOGOPTIONS DBLOGREADER parameter / How it works…
- TRANSLOGOPTIONS parameter / How to do it…, How it works…
- trusted source
- defining / Defined trusted source
U
- Update statement / There's more…
- UPDATE_TIMESTAMP column / There's more...
V
- virtual machine (VM) / Getting ready
W
- WHERE clause
- used, for filtering records / Filtering the records using the FILTER and WHERE clause, How it works..., There's more..., Filtering the records into parallel groups
- using / Using the Where clause
- Windows environment
- Oracle GoldenGate, installing / Installing Oracle GoldenGate in a Windows environment, How it works...
X
- x86_64 Linux-based environment
- Oracle GoldenGate, installing / Installing Oracle GoldenGate in a x86_64 Linux-based environment, How it works...