Index

A

• ACFS
  • about / ACFS
• ACFS-shared filesystem
  • creating / Creating an ACFS-shared filesystem
• Active Data Guard (ADG) / Availability
• Advanced Encryption Security (AES) / Security
  • about / Security features
• Amazon Web Services (AWS) / The Oracle virtual machine, On-premises to cloud migrations
• apply process
  • about / The apply process
  • GoldenGate admin user, creating on target database / Creating the GoldenGate admin user on the target database
  • Replicat process, registering in target database / Registering the Replicat process in the target database
  • creating / Creating and starting the apply process
  • starting / Creating and starting the apply process
• Automatic Storage Management (ASM) / The capture process
• Automatic Workload Repository (AWR) report
  • about / The online redo logs
  • generating / The online redo logs

B

• BATCHSQL
  • about / Using BATCHSQL
  • using / Using BATCHSQL
  • SQL cache / The SQL cache
  • exception handling / Exceptions
  • usage, considerations / When to use BATCHSQL
• bequeath connection
  • about / Bequeath connections
  • investigating / Bequeath connections
• bidirectional configuration
  • implementing / Bidirectional configuration options
  • loop detection / The loop detection
  • Conflict Detection and Resolution (CDR) / Conflict Detection and Resolution in bidirectional environment
  • exception handling / Exception handling
  • Oracle sequences / Oracle sequences
  • Oracle triggers / Oracle triggers
• Bounded Recovery (BR) / Disk
• Broadcast / One-to-many architecture
• business intelligence (BI) / What is GoldenGate?

C

• 12c container database
  • preparing, for data replication / Preparing the 12c container database for data replication
  • capture process, registering / Registering the capture process in a 12c container database
• capital expenditure (CAPEX) / The Oracle Integration Cloud Service
• capture process
  • about / The capture process
  • creating / Creating the capture process
  • registering, in 12c container database / Registering the capture process in a 12c container database
  • registering, in 11g database / Registering the capture process in a 11g database
  • starting / Starting the capture process
• cascading architecture / Cascading
• change data capture
  • configuring / Configuring change data capture
  • configuration summary / The configuration summary
  • configuration, creating for multitenant databases / Creating the configuration for multitenant databases
  • nonCDB databasesTopicnconfiguration, creating / Creating the configuration for nonCDB databases
  • testing / Testing change data capture and delivery
• change data capture (CDC) / Knowledge Modules
• Change Data Delivery (CDD) / Configuring change delivery
• changed data capture (CDC)
  • about / The Manager process
• Changed Data Delivery (CDD) / Changed data recovery
• changed data management
  • about / Changed data management
  • integrated capture and delivery / Integrated capture and delivery
  • classic mode / Classic mode
  • coordinated mode / Coordinated mode
  • DDL replication / DDL replication
• changed data recovery
  • about / Changed data recovery
  • Point-in-time recovery (PITR) / Point-in-time recovery (PITR)
• change delivery
  • configuring / Configuring change delivery
  • testing / Testing change data capture and delivery
• Character Large Object (CLOB)
  • about / The Oracle table compression
• Classic Delivery / Integrated Replicat
• cloud computing
  • about / Cloud computing
  • Oracle Integration Cloud Service / The Oracle Integration Cloud Service
  • on-premises, to cloud migrations / On-premises to cloud migrations
  • migration, benefits / On-premises to cloud migrations
• CMDSEC file
  • creating / The CMDSEC file
• COLMAP option / Using the COLMAP option
• COLMATCH option / The COLMATCH option
• column mapping
  • COLMAP option, using / Using the COLMAP option
  • COLMATCH option / The COLMATCH option
  • DEFGEN utility, using / Using the DEFGEN utility
• command-level security
  • about / Command-level security
  • CMDSEC file, creating / The CMDSEC file
• Command Level Security (CLS)
  • about / The CMDSEC file
• COMPRESS option
  • using / The COMPRESS option
• computer architecture
  • diagram / Computing architectures
  • grid computing / Grid computing
  • single server / Single server
  • clusters / Clusters
  • cloud computing / Cloud computing
• Conflict Detection and Resolution (CDR) / Conflict Detection and Resolution
  • about / Conflict Detection and Resolution in bidirectional environment, Exception handling
  • reporting / CDR reporting
• Conflict Handling / Many-to-one architecture
• consolidation / Many-to-one architecture
• container database (CDB) / Multitenant database replication, Deprecation of the nonCDB architecture
• Container Database (CDB) / Flashback
• Cost Based Optimizer (CBO) / Scaling up and out
• Create Table As Select (CTAS)
  • about / The Oracle table compression
• Credential Store
  • about / The Credential Store
• Credential Store Framework (CSF)
  • about / The Credential Store
• Critical Patch Updates (CPUs) / Support
• CSN (Commit Sequence Number)
  • about / CSN coordination

D

• data compression
  • about / Data compression
  • data stream, compressing / Compressing the data stream
  • COMPRESS option, using / The COMPRESS option
  • Oracle table compression / The Oracle table compression
• data delivery, tuning
  • about / Tuning data delivery
  • load, balancing across parallel process groups / Balancing load across parallel process groups
  • parallel process groups, considerations / Considerations when using parallel process groups
  • large tables, splitting into row ranges across process groups / Splitting large tables into row ranges across process groups
• data encryption
  • about / The data encryption
  • message encryption / The message encryption
  • trail file encryption / The trail file encryption
• data filtering
  • complex / Data selection and filtering
  • noncomplex / Data selection and filtering
  • WHERE clause / The WHERE clause
  • FILTER clause / The FILTER clause
  • loop, detecting / Loop detection
  • active-active / Active-active
  • cascade topology / Cascade
• data lookups, SQLEXEC parameter
  • about / Data lookups
  • stored procdures, executing / Executing stored procedures
  • SQL, executing / Executing SQL
• data mapping
  • about / Mapping your data
  • column mapping / Column mapping
• data pump
  • about / Data pump
• data pump process
  • about / The data pump process
• data replication
  • 12c container database, preparing for / Preparing the 12c container database for data replication
  • logic, using / Using logic in the data replication
  • between different GoldenGate versions / Replicating data between different GoldenGate versions
• data throughput
  • measuring / The data throughput
• data transformations
  • about / Data transformation
  • extraction / Truncation and extraction
  • truncation / Truncation and extraction
  • concatenation / Concatenation
  • substitution / Substitution
  • case changes / Case changing
  • numeric conversion / Conversion functions
  • arithmetic expressions / Arithmetic expressions
  • data functions / Date functions
• DBFS / DBFS
  • enhancements / DBFS enhancements
• DDL configuration
  • filtering / Filtering
  • mapping options / Mapping options
  • DDLOPTIONS parameter / The DDLOPTIONS parameter
• DDL support
  • about / The DDL support, DDL support
  • reference link / The DDL support
  • DDL replication / The DDL replication
  • DDL configuration / The DDL configuration
  • DUMPDDL command, using / Using DUMPDDL
  • LogMiner, using / Using LogMiner
• DEFGEN utility
  • features / The DEFGEN utility
  • using / Using the DEFGEN utility
• Direct Bulk Load method
  • about / Direct Bulk Load
  • extract parameters / Extract parameters
  • replicat parameters / Replicat parameters
• Direct Load method
  • about / Direct Load
  • extract parameters / Extract parameters
  • replicat parameters / Replicat parameters
• disaster recovery (DR) / What is GoldenGate?, Active-active replication
• DML
  • executing / Executing DML
• downstream mining database
  • configuring / Configuring the downstream mining database
  • source database, preparing / Preparing the source database
  • target database, preparing / Preparing the target database
  • GoldenGate configuration / The GoldenGate configuration
• DUMPDDL command
  • using / Using DUMPDDL
• dynamic performance views
  • about / The GoldenGate dynamic performance views
• Dynamic Rollback
  • about / Dynamic Rollback
  • process groups, creating / Creating process groups and trails for reverse processing
  • process groups, reversing / Creating process groups and trails for reverse processing

E

• ENCKEYS method
  • about / The ENCKEYS method
  • configuration / The ENCKEYS method
• environment, preparing
  • about / Preparing the environment
  • 12c container database preparation, for data replication / Preparing the 12c container database for data replication
  • archive log mode, enabling / Enabling archive log mode
  • supplemental logging, enabling / Enabling supplemental logging
  • GoldenGate admin user, creating / Creating GoldenGate admin user
  • Flashback Query / Enabling the Flashback Query
  • transaction data capture, enabling / Enabling transaction data capture
• error
  • file list / Monitoring errors
• errors
  • monitoring / Monitoring errors
• ETL
  • versus E-LT / ETL versus E-LT
  • versus E-LT, pros / Pros
  • versus E-LT, cons / Cons
• event-based processing
  • about / Event-based processing
  • Event Marker System / The Event Marker System
• Event-Driven Architecture (EDA) / Supported platforms and databases
• Event Actions
  • about / Event-based processing
  • triggering / Triggering Event Actions
  • used, for improving batch performance / Using Event Actions to improve batch performance
• Event Maker Interface (EMI) / Coordinated mode
• event marker interface (EMI) / Coordinated Delivery
  • about / The Event Marker System
• Event Markers
  • about / Event-based processing
• Event Marker System
  • about / The Event Marker System
  • Event Actions, triggering / Triggering Event Actions
  • Event Actions, using / Using Event Actions to improve batch performance
• Event Records
  • about / Event-based processing
• Exadata Hybrid Columnar Compression (EHCC) / The database machine, Supported compression methods
• exception handling
  • about / Exceptions, Exception handling, Exception handling
  • exceptions handler, creating / Creating an exceptions handler
  • exceptions, viewing / Viewing exceptions
• Extract
  • about / Extract – the capture process
• Extract, Load, and Transform (E-LT) tools / Oracle GoldenGate solutions

F

• failover
  • about / Failover
  • automatic failover / The automatic failover
  • manual failover / The manual failover
  • active-active configuration / The active-active configuration
• fast recovery area (FRA) / The capture process
• Fast Recovery Area (FRA) / Flashback
• Fast Start Failover (FSFO) / Bidirectional – active-passive, Backup and recovery
• Filesystem in Userspace (FUSE)
  • about / DBFS
• File to Database Utility method
  • about / File to Database Utility
• File to Database utility method
  • extract parameters / Extract parameters
• File to database utility method
  • replicat parameters / Replicat parameters
• File to Replicat method
  • about / File to Replicat
  • extract parameters / Extract parameters
  • replicat parameters / Replicat parameters
• full table scans (FTS) / Large objects – LOBs

G

• 11g database
  • preparing, for replication / Preparing the 11g database for replication
  • archive log mode, enabling / Enabling the archive log mode
  • GoldenGate admin user, creating / Creating the GoldenGate admin user
  • transaction data capture, enabling / Enabling the transaction data capture
  • operating system, preparing / Preparing the operating system
  • capture process, registering / Registering the capture process in a 11g database
• GoldenGate
  • about / What is GoldenGate?
  • history / Oracle GoldenGate evolution
  • solutions / Oracle GoldenGate solutions
  • technology, overview / Oracle GoldenGate technology overview
  • installation, prerequisites / Prerequisites
  • certification matrix / The GoldenGate certification matrix
  • software, downloading / Downloading the software
  • software, requisites / Software requirements
  • hardware, requisites / Hardware requirements
  • installing, OUI used / Installing GoldenGate using the OUI
  • home / Patching the GoldenGate home
  • deinstalling, from Linux / GoldenGate deinstallation from Linux/Unix
  • deinstalling, from Unix / GoldenGate deinstallation from Linux/Unix
  • parameters / GoldenGate parameters
  • instantiation / The GoldenGate instantiation
  • processes, stopping / Stopping GoldenGate processes
  • on RAC / GoldenGate on RAC
  • Grid Infrastructure (GI), configuring / Configuring Grid Infrastructure for GoldenGate
  • software, installing / Installing the GoldenGate software
  • application VIP, creating / Creating the GoldenGate application VIP
  • on Exadata / GoldenGate on Exadata
  • failover / Failover
  • DDL support / DDL support
  • pre-tuning process / Before tuning GoldenGate
  • upgrading / Upgrading GoldenGate
  • and big data / GoldenGate and Big Data
• GoldenGate, architecture
  • about / Oracle GoldenGate architecture
  • classic configurations / Classic configurations
  • one-to-one architecture / One-to-one architecture
  • one-to-many architecture / One-to-many architecture
  • many-to-one architecture / Many-to-one architecture
  • cascading architecture / Cascading
  • active-active configuration / Bidirectional – active-active
  • active-passive configuration / Bidirectional – active-passive
  • new configurations / New configurations
  • Oracle Data Integrator / Oracle Data Integrator
  • Oracle Big Data / Oracle Big Data
• GoldenGate, design
  • considerations / Design considerations
  • solution, selecting / Choosing a solution
  • network / Network
  • database schema / Database schema
• GoldenGate, on Exadata
  • about / GoldenGate on Exadata
  • compression, methods / Supported compression methods
  • considerations / Considerations
  • Extract process, creating / Creating the Extract process
  • Replicat process, creating / Creating the Replicat process
• GoldenGate, on RAC
  • about / GoldenGate on RAC
  • shared storage / Shared Storage
  • configuring / Configuring GoldenGate on RAC
  • Virtual IP (VIP) / The Virtual IP
  • ACFS-shared filesystem, creating / Creating an ACFS-shared filesystem
• GoldenGate, process topology
  • rules / The rules
  • position / Position
  • statistics / Statistics
• GoldenGate, topology
  • process topology / Process topology
• GoldenGate certification matrix
  • URL / The GoldenGate certification matrix
• GoldenGate installing, OUI used
  • media, unpacking / Unpacking the media
  • X server, enabling / Enabling the X server
  • installer, running / Running the installer
• GoldenGate Software Command Interpreter (GGSCI) / GGSCI
• GoldenGate technology
  • Extract process / Extract – the capture process
  • Trail files / Trail files
  • data pump / Data pump
  • server collector / Server collector
  • apply process / Replicat – the apply process
  • manager process / The Manager process
  • GoldenGate Software Command Interpreter (GGSCI) / GGSCI
  • process data flow / Process data flow
• grid computing / Grid computing
• Grid Infrastructure (GI)
  • configuring, for GoldenGate / Configuring Grid Infrastructure for GoldenGate
  • Oracle Grid Infrastructure Agents (XAG) / Oracle Grid Infrastructure Agents (XAG)

H

• hardware, requisites
  • memory / Memory
  • CPU / CPU
  • network / Network
  • disk / Disk
• hardware considerations
  • about / Hardware considerations
  • hardware components, diagram / Computing architectures
  • machines / Machines
• health check, GoldenGate
  • URL / GoldenGate health check
  • about / GoldenGate health check
• heterogeneous environments
  • about / Heterogeneous environments
  • Microsoft SQL Server / Microsoft SQL Server
  • IBM DB2 / IBM DB2
  • DEFGEN utility / The DEFGEN utility
• Hewlett-Packard Continuous Access (HPCA) / What is GoldenGate?
• high availability (HA) / What is GoldenGate?
• host bus adapter (HBA) / Solid-state disks

I

• IBM DB2
  • features / IBM DB2
• initial configuration, creating
  • about / Creating the initial configuration
  • Manager process / Configuring the Manager process
  • capture process / The capture process
  • apply process / The apply process
  • summary / The configuration summary
• initial load / Initial load
  • performing / Performing the initial load
  • example architecture / The example architecture
  • direct load / Direct Load instantiation
  • initial data capture, configuring / Configuring initial data capture
• instantiation method
  • selecting / Choosing an instantiation method
  • File to Replicat / File to Replicat
  • File to Database Utility / File to Database Utility
• integrated parameters
  • viewing / Viewing integrated parameters
• inter-process communication (IPC)
  • about / Bequeath connections
• Internet Control Message Protocol (ICMP)
  • about / TCP/IP

J

• Java Management Extensions (JMX)
  • about / Oracle GoldenGate Monitor 12c

K

• Knowledge Modules (KMs) / Knowledge Modules

L

• latency
  • monitoring / Monitoring latency
• licensing
  • about / Licensing
  • URL / Licensing
• Linux TCP tuning / Linux TCP tuning
• Live Standby / Bidirectional – active-passive
• LOGDUMP
  • about / Using LOGDUMP
  • using / Using LOGDUMP
  • files, opening / Opening files
  • header record, viewing / Viewing the header record
  • transaction record, viewing / Viewing the transaction record
  • miscellaneous commands, using / Miscellaneous commands
  • records, filtering / Filtering records
• Logdump / Trail file format
• Logical Change Records (LCR) / Integrated capture and delivery, Configuring change delivery
  • about / Conflict Detection and Resolution in bidirectional environment
• Logical Change Records (LCRs)
  • about / Using Event Actions to improve batch performance
• LogMiner
  • using / Using LogMiner
• loop, detecting
  • active-active / Active-active
  • cascade topology / Cascade
• loop detection
  • about / The loop detection

M

• machines
  • x86-64 Linux Server / The x86-64 Linux server
  • database machine / The database machine
  • scaling out / Scaling up and out
  • scaling up / Scaling up and out
• macros
  • using / Using and defining macros
  • defining / Using and defining macros
• Manager process / Configuring the Manager process
  • status / The Manager process
  • configuring / Configuring Oracle Manager process
• manual failover
  • GoldenGate application failover / The GoldenGate application failover
• many-to-one architecture / Many-to-one architecture
• maximum availability architecture (MAA) / Availability
• memory consumption
  • controlling / Controlling the memory consumption
• message encryption
  • about / The message encryption
• Metric Extensions (MEs)
  • about / Creating an OEM 12c Metric Extension to monitor GoldenGate processes
• Microsoft SQL Server
  • about / Microsoft SQL Server
  • features / Microsoft SQL Server
• My Oracle Support (MOS)
  • URL / Supported platforms and databases, Oracle Grid Infrastructure Agents (XAG)
  / The GoldenGate certification matrix
• My Oracle Support portal
  • URL / Choosing an instantiation method

N

• N-way replication / Cascading
• network
  • tuning / Tuning the network
• networking
  • about / Networking
  • outages / Surviving network outages
  • redundant networks / Redundant networks
  • NIC teaming / NIC teaming
• Network Interface Card (NIC) / NIC teaming
• network issues
  • investigating / Investigating network issues
  • TCP/IP, investigating / TCP/IP
  • SQL*Net, investigating / SQL*Net
  • bequeath connection, investigating / Bequeath connections
• network tuning
  • Linux TCP tuning / Linux TCP tuning
• nonCDB architecture
  • deprecation / Deprecation of the nonCDB architecture
• Non functional requirements (NFR)
  • about / Non-functional requirements
  • performance / Performance
  • availability / Availability
  • security / Security
  • backup / Backup and recovery
  • recovery / Backup and recovery
  • support / Support

O

• OCFS2
  • URL / OCFS
• OEM 12c Metric Extension
  • creating, for monitoring GoldenGate processes / Creating an OEM 12c Metric Extension to monitor GoldenGate processes
  • monitoring script, creating / Creating the monitoring script
  • Metric Extension, creating / Creating the Metric Extension
  • Metric Extension, deploying / Deploying the Metric Extension
• one-to-many architecture / One-to-many architecture
• one-to-one architecture / One-to-one architecture
• operation throughput
  • measuring / The operation throughput
• Oracle
  • table compression / The Oracle table compression
  • URL / Oracle Grid Infrastructure Agents (XAG)
• Oracle Big Data / Oracle Big Data
• Oracle Cluster File System (OCFS2) / OCFS
• Oracle Data Integrator / Oracle Data Integrator
• Oracle Data Integrator (ODI) / Extract Load and Transform (E-LT), The Oracle Integration Cloud Service
  • about / Oracle Data Integrator 12c
• Oracle Enterprise Manager (OEM) 12c
  • about / Creating an OEM 12c Metric Extension to monitor GoldenGate processes
• Oracle Enterprise Manager 12c Plug-in
  • about / The Oracle Management Pack for GoldenGate
• Oracle errors
  • investigating / Investigating Oracle errors
• Oracle Fusion Middleware / The Oracle Integration Cloud Service
• Oracle GoldenGate (OGG) / Oracle Data Integrator
• Oracle GoldenGate 12c
  • Oracle Streams, migrating / Oracle Streams to GoldenGate Migration
• Oracle GoldenGate 12c, features
  • about / 12c new features
  • integrated capture / Integrated capture
  • integrated Replicat / Integrated Replicat
  • downstream capture process / Downstream capture
  • installation / Installation
  • 12c, upgrading to / Upgrading to 12c
  • Coordinated Delivery option / Coordinated Delivery
  • event-based processing / Enhanced event-based processing
  • enhanced security / Enhanced security
  • Conflict Detection and Resolution (CDR) / Conflict Detection and Resolution
  • Dynamic Rollback / Dynamic Rollback
  • Streams / Streams to GoldenGate migration
  • Oracle Management Pack / Oracle Management Pack
  • Oracle GoldenGate Veridata / Oracle GoldenGate Veridata
• Oracle GoldenGate 12c Release 2
  • about / Oracle GoldenGate 12c Release 2
• Oracle GoldenGate Director 12c
  • about / The Oracle Management Pack for GoldenGate
• Oracle GoldenGate Monitor 12c
  • about / The Oracle Management Pack for GoldenGate, Oracle GoldenGate Monitor 12c
  • Monitor server / Oracle GoldenGate Monitor 12c
  • Monitor agent / Oracle GoldenGate Monitor 12c
  • Monitor repository / Oracle GoldenGate Monitor 12c
• Oracle GoldenGate topology
  • about / Oracle GoldenGate topology
• Oracle GoldenGate Veridata / Oracle GoldenGate Veridata
• Oracle Grid Infrastructure Agents (XAG)
  • XAG Grid Infrastructure Agents, installing / Installing the XAG Grid Infrastructure Agents
• Oracle Identity Manager (OIM) / On-premises to cloud migrations
• Oracle Large Objects (LOBs)
  • about / Exceptions
• Oracle managed files (OMF) / Preparing the target database
• Oracle Management Pack / Oracle Management Pack
  • about / The Oracle Management Pack for GoldenGate
  • Oracle Enterprise Manager 12c Plug-in / The Oracle Management Pack for GoldenGate
  • Oracle GoldenGate Monitor 12c / The Oracle Management Pack for GoldenGate
  • Oracle GoldenGate Director 12c / The Oracle Management Pack for GoldenGate
• Oracle Parallel Server (OPS) / Clusters
• Oracle Real Application Clusters (RAC) / Software requirements
• Oracle Recovery Manager (RMAN) / Backup and recovery, Oracle Recovery Manager (RMAN)
• Oracle Sequences
  • handling / Handling Oracle Sequences
• Oracle sequences
  • about / Oracle sequences
  • guidelines / Oracle sequences
• Oracle Software Delivery Cloud
  • URL / Prerequisites, Downloading the software, Upgrading GoldenGate
• Oracle Streams
  • migrating, to Oracle GoldenGate 12c / Oracle Streams to GoldenGate Migration
• Oracle Support Portal
  • URL / Oracle Streams to GoldenGate Migration
• Oracle triggers
  • about / Oracle triggers
• Oracle Universal Installer (OUI) / Installation, Oracle Grid Infrastructure Agents (XAG)
  • about / Oracle GoldenGate Monitor 12c
• Oracle virtual machine (VM)
  • about / The Oracle virtual machine
  • URL / The Oracle virtual machine
• Oracle wallet / Enhanced security
• Oracle website
  • URL / The Oracle virtual machine

P

• parameters, GoldenGate
  • PORT / GoldenGate parameters
  • PURGEOLDEXTRACTS / GoldenGate parameters
  • AUTOSTART / GoldenGate parameters
  • AUTORESTART / GoldenGate parameters
  • EXTRACT / GoldenGate parameters
  • SOURCEISTABLE / GoldenGate parameters
  • SOURCECATALOG / GoldenGate parameters
  • LOGALLSUPCOLS / GoldenGate parameters
  • UPDATERECORDFORMAT / GoldenGate parameters
  • RMTTASK / GoldenGate parameters
  • RMTFILE / GoldenGate parameters
  • RMTTRAIL / GoldenGate parameters
  • RMTHOST / GoldenGate parameters
  • EXTFILE / GoldenGate parameters
  • MGRPORT / GoldenGate parameters
  • USERIDALIAS / GoldenGate parameters
  • USERID / GoldenGate parameters
  • PASSWORD / GoldenGate parameters
  • TABLE / GoldenGate parameters
  • DISCARDFILE / GoldenGate parameters
  • REPLICAT / GoldenGate parameters
  • SPECIALRUN / GoldenGate parameters
  • RUNTIME / GoldenGate parameters
  • SOURCEDEFS / GoldenGate parameters
  • ASSUMETARGETDEFS / GoldenGate parameters
  • HANDLECOLLISIONS / GoldenGate parameters
  • MAP / GoldenGate parameters
  • BULKLOAD / GoldenGate parameters
• parameters, tuning
  • about / Tuning parameters to improve the Replicat throughput
  • BATCHSQL / BATCHSQL
  • COMMIT_SERIALIZATION / COMMIT_SERIALIZATION
  • EAGER_SIZE / EAGER_SIZE
  • PARALLELISM / PARALLELISM
• password encryption
  • about / The password encryption
  • default method / The default method
  • named method / The named method
  • Credential Store / The Credential Store
• Peripheral Component Interconnect Express (PCIe) / Solid-state disks
• Platform as a Service (PaaS) / The Oracle virtual machine, Cloud computing
• Pluggable Database (PDB) / Flashback
• pluggable databases (PDB) / Multitenant database replication
• Point-in-time recovery (PITR) / Point-in-time recovery (PITR)
  • Oracle Recovery Manager (RMAN) / Oracle Recovery Manager (RMAN)
  • Flashback / Flashback
  • SAN Snapshot / SAN Snapshot
• pre-tuning process
  • about / Before tuning GoldenGate
  • online redo logs / The online redo logs
  • large objects (LOBs) / Large objects – LOBs
  • base lining / Base lining
• processes
  • tracing, to find wait events / Tracing processes to find wait events
• process startup
  • managing / Managing the process startup
• process startup failures
  • troubleshooting / Troubleshooting process startup failures
  • CHECKPARAMS parameter, troubleshooting / The CHECKPARAMS parameter
  • replication starting point, adjusting / Adjusting the replication starting point
  • Extract processes, altering / Altering Extract processes in RAC environments
  • Extract processes, altering for classic capture / Classic capture
  • Extract processes, altering for integrated capture / Integrated capture
  • integrated capture process status, confirming / Confirming the integrated capture process status
  • data throughput, checking / Checking data throughput
  • process checkpoints, checking / Checking process checkpoints

R

• RAC
  • GoldenGate / GoldenGate on RAC
• RAID (Redundant Array of Independent Disks) / Shared Storage
• RANGE function
  • about / The RANGE function
  • replicats, adding with / Adding Replicats with the @RANGE function
• Real Application Clusters (RAC) / Availability
• Red Hat Enterprise Linux (RHEL) / Machines
• Relational Database Management System (RDBMS) / Pros
• Relational Database Services (RDS) / Cloud computing
• relative byte address (RBA)
  • about / The data throughput, Checking data throughput
• Replicat
  • about / Replicat – the apply process
• replicate
  • about / What to replicate?
  • object mapping / Object mapping and data selection
  • initial load / Initial load
• replication
  • methods / Replication methods
  • active-active replication / Active-active replication
  • active-passive replication / Active-passive replication
  • cascading / Cascading
  • Downstream capture / Downstream capture
  • Extract Load and Transform (E-LT) / Extract Load and Transform (E-LT)
• reporting and statistics
  • about / Reporting and statistics
  • errors, monitoring / Monitoring errors
  • latency, monitoring / Monitoring latency
  • OEM 12c Metric Extension, creating / Creating an OEM 12c Metric Extension to monitor GoldenGate processes
  • historical reporting / Historical reporting
  • throughput, measuring / Measuring throughput
• reverse utility
  • about / Dynamic Rollback
• root container database (CDB$ROOT) / Deprecation of the nonCDB architecture

S

• SAN Snapshot / SAN Snapshot
• Secure Socket Layer (SSL)
  • about / Oracle GoldenGate Monitor 12c
• security features
  • about / Security features
  • wallet method / The wallet method
  • ENCKEYS method / The ENCKEYS method
  • data encryption / The data encryption
  • password encryption / The password encryption
• service-oriented architecture (SOA) / Oracle GoldenGate solutions, Knowledge Modules
• Service Level Agreement (SLA) / Performance
• shared storage
  • about / Shared Storage
  • ACFS / ACFS
  • Database File System (DBFS) / DBFS
  • Oracle Cluster File System (OCFS2) / OCFS
  • resilience / Resilience
• Simple Network Management Protocol (SNMP)
  • about / Monitoring errors
• Single Client Access Name (SCAN) / The Virtual IP
• single sign-on (SSO)
  • about / Oracle GoldenGate Monitor 12c
• slow Extract
  • diagnosing / Diagnosing a slow Extract
• software
  • requisites / Software requirements
• software installation
  • about / The software installation
  • GoldenGate, installing / Installing GoldenGate using the OUI
  • OUI used / Installing GoldenGate using the OUI
  • silent installation, performing / Performing a silent installation
  • subdirectories / The subdirectories
• solid-state devices (SSD) / The online redo logs
• solid-state disk (SSD) / Solid-state disks
• SQL
  • executing / Executing SQL
• SQL*Net
  • investigating / SQL*Net
• SQL cache
  • about / The SQL cache
• SQLEXEC parameter
  • about / The SQLEXEC parameter
  • data lookups / Data lookups
  • DML, executing / Executing DML
  • errors, handling / Handling errors
  • jobs, scheduling / Scheduling jobs
• SSH (secure shell) / On-premises to cloud migrations
• static data dictionary views
  • about / Static data dictionary views
  • DBA_HIST_CAPTURE / Static data dictionary views
  • DBA_HIST_APPLY_SUMMARY / Static data dictionary views
  • DBA_HIST_REPLICATION_TBL_STATS / Static data dictionary views
• Storage Area Network (SAN) / Backup and recovery
• storage area network (SAN) / Shared Storage, Solid-state disks
• subdirectories, software installation
  • br subdirectory / br
  • dircrd subdirectory / dircrd
  • dirchk subdirectory / dirchk
  • dirdat subdirectory / dirdat
  • dirdef subdirectory / dirdef
  • dirpcs subdirectory / dirpcs
  • dirprm subdirectory / dirprm
  • dirrpt subdirectory / dirrpt
  • dirsql subdirectory / dirsql
  • dirtmp subdirectory / dirwlt
• Swingbench
  • URL / Base lining
• System Change Number (SCN)
  • about / CSN coordination
• system change number (SCN)
  • about / Integrated capture

T

• table compression
  • about / The Oracle table compression
  • basic compression / The Oracle table compression
  • OLTP compression / The Oracle table compression
  • Exadata Hybrid Columnar compression / The Oracle table compression
• TCP/IP
  • investigating / TCP/IP
• TCP/IP errors
  • managing / Managing TCP/IP errors
• throughput
  • measuring / Measuring throughput
  • data throughput, measuring / The data throughput
  • operation throughput, measuring / The operation throughput
• trail file
  • managing / Managing the trail file
• trail file encryption
  • about / The trail file encryption
• trail files
  • about / More about trail files, The trail
  • purging / Trail file purging
• troubleshooting
  • tips / Troubleshooting tips
  • process startup failures / Troubleshooting process startup failures
  • corrupt trail file, recovering from / Recovering from a corrupt trail file

U

• user-defined metrics (UDMs)
  • about / Creating an OEM 12c Metric Extension to monitor GoldenGate processes
• user exits
  • about / User exits
  • C routines, calling / Calling C routines
  • examples / Sample user exits
  • source files / Source files explained
• user tokens
  • about / User tokens
  • used, for populating heartbeat table / Using user tokens to populate a heartbeat table

V

• Veritas Volume Replicator (VVR) / What is GoldenGate?
• Virtual IP (VIP)
  • about / The Virtual IP

W

• wallet method
  • about / The wallet method

X

• XAG Grid Infrastructure Agents
  • installing / Installing the XAG Grid Infrastructure Agents