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