Differences

This shows you the differences between two versions of the page.

--- oracle_12_goldengate_conf_prepare_source [2020/10/26 19:19] – andonovj
+++ oracle_12_goldengate_conf_prepare_source [2020/11/09 19:50] (current) – andonovj
@@ Line 16: / Line 16: @@
-So let's get started:
+So let's get started. You can set supplemental logging in Oracle database in three levels:
+<Code:bash|Database Level>
+SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
+SQL> ALTER DATABASE FORCE LOGGING;
+</Code>
+<Code:bash|Schema Level>
+GGSCI> ADD SCHEMATRANDATA schema [ALLCOLS|NOSCHEDULINGCOLS]
+</Code>
+<Code:bash|Table Level>
+GGSCI> ADD TRANDATA [container.]schema.table[ALLCOLS|NOSCHEDULINGCOLS]
+</Code>
+The commands from the GGSCI are heterogenous, which means, if the database is DB2, it will enable the necessary logging for DB2.
 <Code:bash|Enable Supplemental Logging>
@@ Line 138: / Line 153: @@
 Successfully logged into database.
+---Add the Classical Extract
 GGSCI (sourceSRV.izb.local as ggate@DBNAME) 2> add extract EBKEXT1, TRANLOG, BEGIN NOW
 EXTRACT added.
+---Create Local Trail and associate it with the Classical Extract
 GGSCI (sourceSRV.izb.local as ggate@DBNAME) 5> add exttrail ./dirdat/lt, EXTRACT EBKEXT1
 EXTTRAIL added.
+---Create Data Pump process and associate it with the local trail
 GGSCI (sourceSRV.izb.local as ggate@DBNAME) 6> add EXTRACT EBKDMP1, EXTTRAILSOURCE ./dirdat/lt
 EXTRACT added.
+---Add Remote trail and associate it with the Data pump process
 GGSCI (sourceSRV.izb.local as ggate@DBNAME) 7> add RMTTRAIL ./dirdat/rt, EXTRACT EBKDMP1
 RMTTRAIL added.
+---Add Supplemental logging for the schema
 GGSCI (sourceSRV.izb.local as ggate@DBNAME) 8> ADD SCHEMATRANDATA SCHEMANAME1   <- Schema name
@@ Line 164: / Line 183: @@
 *****************************************************************************************
+---Add supplemental logging for 2nd schema
 GGSCI (sourceSRV.izb.local as ggate@DBNAME) 9> add schematrandata SCHEMANAME2