Friday, April 22, 2016

GoldenGate Tutorial : Record count using Oracle GoldenGate logdump| find record count in goldengate

login as: oracle
oracle@192.168.1.251's password:
Last login: Wed Apr 20 11:31:27 2016 from desktop-llop0gq.fios-router.home
[oracle@PrimeDG ~]$ . oraenv
ORACLE_SID = [oracle] ? PrimeDG
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 is /u01/app/oracle
[oracle@PrimeDG ~]$ cd /syed/gg_home
[oracle@PrimeDG gg_home]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.



GGSCI (PrimeDG) 1> exit
[oracle@PrimeDG gg_home]$ ls -al dirdat
total 16
drwxrwxr-x  2 oracle oinstall 4096 Apr 16 15:54 .
drwxrwxr-x 15 oracle oinstall 4096 Apr 20 19:33 ..
-rw-rw-rw-  1 oracle oinstall 1023 Apr 16 15:54 ex000000
-rw-rw-rw-  1 oracle oinstall 1480 Apr 16 17:32 ex000001
[oracle@PrimeDG gg_home]$ ./logdump

Oracle GoldenGate Log File Dump Utility for Oracle
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.



Logdump 1 >open ./dirdat/ex000001
Current LogTrail is /syed/gg_home/dirdat/ex000001
Logdump 2 >env
Version             : Linux, x64, 64bit (optimized) on Aug 23 2012 16:42:38

Current Directory   : /syed/gg_home
LogTrail            : /syed/gg_home/dirdat/ex000001
Trail Format        : New
End of File         : 1480
Current Position    : 0    Forward
Next Position       : 0
Last Modtime        : 2016/04/16 17:32:31.000.000
Display RecLen      : 140
Logtrail Filter     : On
Trans History       : 0 Transactions, Records 100, Bytes 100000
LargeBlock I/O      : On, Blocksize 57344
Local System        : LittleEndian
Logtrail Data       : BigEndian/ASCII
Logtrail Headers    : ASCII
Dump                : ASCII
Savefile comments   : Off
Timeoffset          : LOCAL
Scan Notify Interval: 10000 records, Scrolling On

Logdump 3 >count
LogTrail /syed/gg_home/dirdat/ex000001 has 5 records
Total Data Bytes              1116
  Avg Bytes/Record             223
Insert                           3
RestartAbend                     1
Others                           1
After Images                     4

Average of 3 Transactions
    Bytes/Trans .....        452
    Records/Trans ...          1
    Files/Trans .....          1

Logdump 4 >

No comments:

Post a Comment