Classic Vs. Integrated Extract process in Oracle Goldengate
Classic Extract
Classic Extract is a legacy, server-based mechanism, where it directly reads the change records from redo log or archived log files at the OS level using operating system calls and then construct the required DML and DDL statements and writes to he trail file. It operates outside the database engine, parsing raw log data to extract committed transactions. Classic extract is deprecated in 19c and de-supported in 21c.
Integrated Extract
In integrated extract process. it interacts directly with a database logmining server to receive data changes, from the redo log or archive log file, in the form of logical change records (LCR). Because integrated capture is fully integrated with the database, no additional setup is required to work with Oracle RAC, ASM, and TDE.
