12c: Integrated GoldenGate Extract

In order to increase the performance of Goldengate capture process, we can enable the log mining server so that extract will capture the logical records from log mining server and writes to the local trail 

In order to configure and invoke log mining server and  addition to goldengate privileges to assign, we need additional privilege's to enable the integrated capture on database 

SQL> exec dbms_goldengate_auth.grant_admin_privilege('ggsuser');

PL/SQL procedure successfully completed.

perform dblogin using ggsuser and password & Initially register the extract from the goldengate command utility as shown below

GGSCI (tnc61.ffdc.com) 2> dblogin userid ggsuser, password oracle

Successfully logged into database.

GGSCI (tnc61.ffdc.com as ggsuser@oval007p) 3> register extract extnew, database 

Extract EXTNEW successfully registered with database at SCN 3305172.

GGSCI (tnc61.ffdc.com as ggsuser@oval007p) 4> add extract extnew, integrated tranlog, begin now

EXTRACT added.

ggsci>edit param <extnew>

-- add extract extnew, EXTTRAILSOURCE /u01/app/trails/ca, integrated tranlog, begin now
extract extnew

SETENV (ORACLE_SID=oval007p)

SETENV (ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1)

userid ggsuser, password oracle

exttrail /u01/app/trails/ca

nocompressupdates 

nocompressdeletes 

REPORTCOUNT EVERY 10 MINUTES, RATE

tranlogoptions integrated params (max_sga_size 200, parallelism 1) 

---Include the full record

table nspdba.symbol, getbeforecols(on update all, on delete all); 

--Nikhil Tatineni--
--12c: GoldenGate---