Oracle GoldenGate 11gR2 Event Marker System
- by Doug Reid
0
false
18 pt
18 pt
0
0
false
false
false
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-ascii-font-family:Cambria;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"Times New Roman";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Cambria;
mso-hansi-theme-font:minor-latin;}
Oracle GoldenGate 11gR2 includes a number of refinements to
the Event Marker system. Using
event markers enables GoldenGate processes to take a defined action based on an
event in the data stream. This
feature within Oracle GoldenGate simplifies methods to embed specific custom
processing in the areas of error handling, alerts, and notification.
The event marker system effectively allows for DML driven
workflows to be created within GoldenGate and enables customers to craft non-standard
processing based on special events. There are a number of supported event
actions including: trace, log, checkpoint before, suspend, abort, and several
others. With 11gR1 events
can now be triggered by DDL operations, plus variables can be passed in and out
of the system to shell scripts.
Some good use cases for this feature are
Automatic switchover to the secondary system during planned
outages
Better monitoring over source systems’ performance and
automated switchover to the standby system in case of an outage with the
primary system
Automatic switchover from initial load to changed data
movement
Automatic synchronization of any type of batch processing
taking place on both the source and target databases for database consistency
Automatic stoppage of the Delivery module to allow
end-of-day reporting
Finding, tracking, and reporting on transactions that are of
interest including the ones that do not have primary keys or transaction record
numbers
If you would like to see a demo, please visit our youtube
channel (http://youtube.com/oraclegoldengate)
To learn more about the new features of Oracle GoldenGate 11gR2 and to ask questions to the PM team, please join us on September 12th 8am or 10am PST for our live webcast. Click here to register.
