Sunday, May 12, 2019

Find table in trail file using Goldengate logdump utility



Check TABLE (CUST.SALES) in Trail file using LOGDUMP

cd  $GG_HOME

$./logdump
Logdump 1 >ghdr on
Logdump 2 >detail on
Logdump 3 >detail data
Logdump 4 >open /goldengate/home/dirdat/xxxx/CS000023799
Current LogTrail is /goldengate/home/dirdat/xxxx/CS000023799

Logdump 6 >FILTER INCLUDE FILENAME CUST.sales
Logdump 7 >count
Scanned     10000 records, RBA    7356269, 2019/05/03 14:44:45.000.000
Scanned     20000 records, RBA   14846486, 2019/05/03 14:46:49.000.000
Scanned     30000 records, RBA   23290032, 2019/05/03 14:56:03.000.000
Scanned     40000 records, RBA   32171981, 2019/05/03 15:04:39.000.000
Scanned     50000 records, RBA   41262061, 2019/05/03 15:09:51.000.000
Partial record at RBA 46133384
Format 550 record, total len = 3268
LogTrail /goldengate/home/xxxx/hp000023799 has 0 records
Filtering matched            0 records
          suppressed     56004 records

 Logdump 8 >n

1 comments:

mohammed omer said...

Hi Chandu,

How do you filter a table in 21c with pluggable database? Do we have to use filter filename PDB.SCHEMA.TABLENAME or CDB.SCHEMA.TABLENAME

Post a Comment

Auto Scroll Stop Scroll