Converting classic Extract to Integrated Extract #
Prereq's #
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.
Set "streams_pool_size" parameter for Integrated capture
Before Upgrading the extract into Integrated mode make sure prereq's completed on database #
Set "streams_pool_size" parameter for Integrated capture
Before Upgrading the extract into Integrated mode make sure prereq's completed on database #
If we are using Classic Extract, if we want to upgrade to Integrated follow the steps as follows
ggsci> dblogin userid ggsuser password oracle
ggsci> stop extract ext_int
ggsci> stop extract ext_int
ggsci> register extract ext_int database
ggsci> alter extract ext_int, upgrade Integrated tranlog
ggsci> start extract ext_int
you can see following message in report file, when you start extract in Integrated mode
ggsci > view report ext_int
you can see following message in report file, when you start extract in Integrated mode
ggsci > view report ext_int
2016-10-13 09:14:46 INFO OGG-02248 Logmining server DDL filtering enabled.
2016-10-13 09:14:47 INFO OGG-02068 Integrated capture successfully attached to logmining server OGG$CAP_EEMP u
sing OGGCapture API.
2016-10-13 09:14:47 INFO OGG-02089 Source redo compatibility version is: 11.2.0.4.0.
2016-10-13 09:14:47 INFO OGG-02086 Integrated Dictionary will be used.
Links Related to GoldenGate #
GoldenGate Daily Patrol scripts on Servers
Migrating Oracle database using Goldengate
Query’s to monitor Integrated Extract#
Keygen # GoldenGate Password Encryption
Remove DDL replication # GoldenGate
What is lag in OGG ?
GoldenGate Extract : Bounded Recovery
--Nikhil Tatineni--
--Oracle In Memory--
