Tuesday, May 24, 2016

Oracle GoldenGate 12.2 New Features


Oracle GoldenGate 12.2 New Features

1. Replicat environment 
=======================
Note: No need specify No SOURCEDEFS! & No ASSUMETARGETDEFS!

REPLICAT rorcl
USERIDALIAS ggs_admin
DDL include all
MAP scott.*, TARGET scott.*;

2. Automatic Heartbeat Table
============================
a. Automatically discovers Database Replication Topology
b. Execute GGSCI command ADD HEARTBEATTABLE at each database 
c. Monitoring Lag using GG_LAG View

3. Parameter Validation
=======================
a. New standalone utility checkprm for validation 
b. New INFO PARAM GGSCI command to obtain definitions of parameters

4. Transparent Integration with Oracle Clusterware (OCS)
========================================================
a. Achieve GoldenGate high availability in a cluster configuration.
b. GoldenGate is managed/monitored by Oracle Clusterware.
c. Add parameter “XAG_ENABLE” to GLOBALS to enable this feature

5. Fetching from Oracle Active Data Guard (ADG)
===============================================
a. Need source database for startup validations, registration and some metadata lookups
b. Enable with FETCH_USER_ID ggadmin@adg password oracle or FETCHUSERIDALIAS ggadmin_adg

No comments:

Post a Comment