GoldenGate

Hi Suman,

Only Integrated Capture and Integrated Replicat supports Multi-tenant container databases. Classic Mode does not supports.

Classic Mode

The first and initial Extract / Capture process introduced in Oracle GoldenGate is called as Classic Capture / Extract process. In Classic mode, the Extract process directly reads the redo or archive logs and captures the committed transactions and writes it to the trail files called local trails.

There is no parallel serves spawned in the Classic mode of capture process and it will also not support many data types.

Integrated Mode

Later Oracle introduced Integrated Mode of Capture and Apply. This mode of extract and replicat only supported for Oracle Database. Here in the Integrated Mode, the IE processes are bind with the Oracle Architecture. So, the Streams processes will play the role in the background.

For Integrated Mode, you need to register the Extract process. When registering the Extract process, a Log Miner server will be attached to that Extract process and this Log Miner server will read the Redo or Archive Logs for the committed transactions.

Integrated Mode Benefits,

The following are some additional benefits of integrated capture:

• Because integrated capture is fully integrated with the database, no additional setup is required to work with Oracle RAC, ASM, and TDE.
• Integrated capture uses the database logmining server to access the Oracle redo stream, with the benefit of being able to automatically switch between different copies of archive logs or different mirrored versions of the online logs. Thus integrated capture can transparently handle the absence of a log file caused by disk corruption, hardware failure, or operator error, assuming that additional copies of the archived and online logs are available
• Integrated capture enables faster filtering of tables.
• Integrated capture handles point-in-time recovery and RAC integration more efficiently.
• Integrated capture features integrated log management. The Oracle Recovery Manager (RMAN) automatically retains the archive logs that are needed by Extract.
• Integrated capture is the only mode that supports capture from a multitenant container database. One Extract can mine multiple pluggable databases within a multitenant container database.

For more information, please check the below documentation,

https://docs.oracle.com/goldengate/1212/gg-winux/GIORA/process_mode.htm#GIORA212

Regards,

Veera