Oracle GoldenGate – Event Marker Mechanism (EVENTACTIONS)

Event Marker Mechanism

The Extract and Replicat processes can be used to perform specific actions following the occurrence of certain events in the transaction log or the trail file.
Event Marker consists of two components i.e. Event Record and EVENTACTIONS Clause
Event Record: Is a specific type of record that satisfies certain selection criteria; is used to trigger actions. The event record is selected by a FILTER or WHERE clause included in a TABLE statement (Extract) or a MAP and TABLE statement (Replicat).
EVENTACTIONS clause determines what actions must be taken by the Extract or Replicat process. Such actions can be stopping the Extract or Replicat process, producing a statistics report, executing a shell command, and so on.
EVENTACTIONS options can be combined (and usually are).
A few EVENTACTIONS options are incompatible with each other, and some take precedence over others while being evaluated.
Several actions will occur before the record is written to the trail or applied to the target, whereas other actions will occur after the record has been written.
It is possible to instruct the Extract or Replicat process to discard the event record, or even to ignore the entire transaction that includes the event record.

EVENTACTIONS that are evaluated before the record is written: TRACE, LOG, CHECKPOINT BEFORE, IGNORE, DISCARD, SHELL & ROLLOVER

EVENTACTIONS that are evaluated after the record is written: REPORT, ABORT, CHECKPOINT AFTER, FORCESTOP & STOP

Event Marker Actions

  • STOP: Causes the process to end gracefully after the current transaction completes
  • SUSPEND: Pauses the process, which can still receive the SEND command. To resume, send a RESUME command.
  • ABORT: Forces an abrupt end of the process. The transaction is not completed and a recovery is necessary at the next start.
  • FORCESTOP: Forces a graceful end of the process only if the event record is the last operation in the transaction.
  • IGNORE: Ignores (either completely or partially) the current event record or the transaction.
  • DISCARD: Causes the process to write the specified event record to the discard file, updating the statistics of discarded records.
  • LOG: Causes the process to log the event when the specified event record is encountered.
Share This

Muhammad Rawish Siddiqui

Master in Computer Science (Database Engineering) and PGD in Management Information System.
45+ Online Certifications, which includes EDRP (EC-Council Disaster Recovery Professional), Data Management, Security+, DBaaS - Cloud Certified Expert, Oracle Cloud Autonomous Database Specialist, Oracle Database Cloud Certified Professional, Oracle Cloud Infrastructure, OCP 7.3, 10g, 11g, 11i, R12, OCE/OCS 11i System Administration, Solaris, Linux and Real Application Cluster 10g, 11g, Oracle Autonomous Database, Real Application Cluster, Oracle Data Guard and Performance Tuning etc. .

Foremost interested areas include, Data Management, Oracle Databases and EBS Health Checks, Real Application Cluster, Disaster Recovery, GoldenGate and Oracle Cloud.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments