Oracle GoldenGate – Integrated and Classic Capture Working Together

Integrated Capture : Limitations

Only work with Oracle as Source Database.
Alter Extract (Group) is also limited and cannot alter to before it was registered.
With info command, you cannot see SEQNO and RBA.

SECUREFILE LOBs are captured from Redo Logs only when the LOBs are not compressed, encrypted, or de-duplicated, and when they are stored out-of-row. Otherwise, they are captured from the source table.
The following data types are not supported:
– ANYDATASET
– ANYTYPE
– BFILE
– MLSLABEL
– ORDDICOM
– ROWID
– TIMEZONE_ABBR
– URITYPE
– UROWID

Integrated and Classic Capture: Working Together
Integrated Capture and Classic Capture are not mutually exclusive.
On the same system, a set of tables can be replicated by using Classic Capture, whereas a different set can use Integrated Capture for replication. This arrangement ensures a gradual upgrade path toward Integrated Capture, which is now the preferred mode for replication.

Established Oracle GoldenGate installations can continue using Classic Capture, while gradually introducing Integrated Capture to take advantage of compression and the ability to replicate data types that are not supported by Classic Capture.



HTML Table

About Me Muhammad Rawish Siddiqui
rawishsiddiqui@yahoo.ca
https://www.linkedin.com/in/rawishsiddiqui
Some of My Articles
Autonomous & Cloud Database Specialist
Oracle Database Fleet Administrator
High Availability and Disaster Recovery Consultant
Oracle Certified Expert
Professional Oracle ERP DBA
EC-Concil Disaster Recovery Professional



Share







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