If a DDL or DML transaction is executed on the source database and the table does not exist on the target side the Replicat process will abend. Learn how to get around this.
The Integrated Capture Mode provides enhanced integration with new Oracle Features and improvement in usage of the resources and performance enhancement. Here are the steps required to upgrade a new or an existing GoldenGate Classical Extract process
The Integrated Capture GoldenGate Mode also known as the Integrated Extract Goldengate process in 12c (also backported to 11gr2) is one of the more interesting and useful feature released with this version. This capture process is the component responsible for extracting the DML transactional data and DDL’s from the source database redo log files. This […]
Oracle Golden Gate Replication will not propagate transactions to the destination which have NOT been committed on the source yet. However Oracle Golden gate will write the open transaction data to the dirtemp directory in the home directory. This data will then be read back later when the transaction is committed and needs to be propagated to the destination. This is especially true when bulk transactions are run, processing a large account of the uncommitted data, which then has to be written temporarily to the dirtemp location.
GoldenGate GGSCI commands executed at the ggsci line utility, are used to configure, manage, monitor and troubleshoot the different components of the Goldengate Replication configuration. Oracle Golden Gate Commands Series • GoldenGate: GGSCI Commands I • GoldenGate: GGSCI Commands II • GoldenGate: GGSCI Commands III You are able to look at the current status, lag, […]