Forum Stats

  • 3,769,805 Users
  • 2,253,023 Discussions
  • 7,875,211 Comments

Discussions

Logdump

user10126973
user10126973 Member Posts: 126 Red Ribbon

Hi All,

I have update a record in the source, but it did not capture column 0 value (which is first column in the table) before and after image, please see the details below logdump details of the record.

update emp_tst set empno=305, ename='vig', create_dt=sysdate,update_dt=sysdate where empno=300;

commit;

Logdump 64 >n

___________________________________________________________________ 

Hdr-Ind  :   E (x45)   Partition :   . (x0c)  

UndoFlag  :   . (x00)   BeforeAfter:   A (x41)  

RecLength :  156 (x009c)  IO Time  : 2020/11/14 22:01:21.000.000  

IOType   :  135 (x87)   OrigNode  :  255 (xff) 

TransInd  :   . (x03)   FormatType :   R (x52) 

SyskeyLen :   0 (x00)   Incomplete :   . (x00) 

AuditRBA  :     25    AuditPos  : 45593104 

Continued :   N (x00)   RecCount  :   1 (x01) 

2020/11/14 22:01:21.000.000 GGSUnifiedPKUpdate  Len  156 RBA 8883 

Name: PDB1.APP_USER.EMP_TST (TDR Index: 1) 

After Image:                       Partition x0c  G s  

 4d00 0000 0000 0a00 0000 0000 0000 0000 012c 0100 | M................,..  

 0900 0000 0500 7265 6464 7902 0015 0000 0032 3032 | ......reddy......202  

 302d 3131 2d31 313a 3231 3a33 373a 3433 0300 1500 | 0-11-11:21:37:43....  

 0000 3230 3230 2d31 312d 3131 3a32 313a 3337 3a34 | ..2020-11-11:21:37:4  

 3300 000a 0000 0000 0000 0000 0001 3101 0007 0000 | 3.............1.....  

 0003 0076 6967 0200 1500 0000 3230 3230 2d31 312d | ...vig......2020-11-  

 3134 3a32 323a 3031 3a31 3603 0015 0000 0032 3032 | 14:22:01:16......202  

Before Image     Len  81 (x00000051) 

BeforeColumnLen   77 (x0000004d) 

Column   0 (x0000), Len  10 (x000a)  

 0000 0000 0000 0000 012c             | .........,  

Column   1 (x0001), Len   9 (x0009)  

 0000 0500 7265 6464 79              | ....reddy  

Column   2 (x0002), Len  21 (x0015)  

 0000 3230 3230 2d31 312d 3131 3a32 313a 3337 3a34 | ..2020-11-11:21:37:4  

 33                        | 3  

Column   3 (x0003), Len  21 (x0015)  

 0000 3230 3230 2d31 312d 3131 3a32 313a 3337 3a34 | ..2020-11-11:21:37:4  

 33                        | 3  


After Image      Len  75 (x0000004b) 

Column   0 (x0000), Len  10 (x000a)  

 0000 0000 0000 0000 0131             | .........1  

Column   1 (x0001), Len   7 (x0007)  

 0000 0300 7669 67                 | ....vig  

Column   2 (x0002), Len  21 (x0015)  

 0000 3230 3230 2d31 312d 3134 3a32 323a 3031 3a31 | ..2020-11-14:22:01:1  

 36                        | 6  

Column   3 (x0003), Len  21 (x0015)  

 0000 3230 3230 2d31 312d 3134 3a32 323a 3031 3a31 | ..2020-11-14:22:01:1  

 36                        | 6  

  GGS tokens: 

 5200 1400 4141 4152 3951 4141 4d41 4141 4143 6a41 | R...AAAR9QAAMAAAACjA  

 4164 0001 4c00 0700 3239 3839 3738 3736 0011 0032 | Ad..L...29897876...2  

 3035 3833 3930 3435 2e35 2e37 2e38 3836 6901 0200 | 05839045.5.7.886i...  

 0001                     

Please share your thoughts

regards,

DR

Comments

  • ORASCN
    ORASCN Member Posts: 1,825 Gold Trophy

    It is a  GGSUnifiedPKUpdate update. Could you please get the output again with below commands,

    Logdump> open <trail file name with full path>

    Logdump> ghdr on

    Logdump> detail data on

    Logdump> ggstoken detail

    Logdump> usertoken detail

    Logdump> pos 8883

    Logdump> n

    Also could you please provide the Extract parameter file.

    Regards,

    Veera

  • user10126973
    user10126973 Member Posts: 126 Red Ribbon

    Hi Veera,

    these are the details prm file

    [email protected] dirprm]$ cat ext2.prm

    extract ext2

    userid c##[email protected],password welcome1

    exttrail /u01/app/oracle/gg19/dirdat/et

    discardfile /u01/app/oracle/gg19/dirrpt/ext2.dsc

    --TABLE pdb1.aap_user.emp;

    TABLE pdb1.app_user.emp_tst;

    [[email protected] dirprm]$ cat pext2.prm

    extract pext2

    userid c##[email protected], password welcome1

    RMTHOST 192.168.56.104, MGRPORT 7809

    rmttrail /u01/app/oracle/gg19/dirdat/rr

    --TABLE pdb1.app_user.emp;

    TABLE pdb1.app_user.emp_tst;

    ========================================

    Logdump 66 >pos 0

    Reading forward from RBA 0 

    Logdump 67 >ghdr on

    Logdump 68 >detail data on

    Logdump 69 >ggstoken detail

    Logdump 70 >usertoken detail

    Logdump 71 >pos 8883

    Reading forward from RBA 8883 

    Logdump 72 >n

    ___________________________________________________________________ 

    Hdr-Ind  :   E (x45)   Partition :   . (x0c)  

    UndoFlag  :   . (x00)   BeforeAfter:   A (x41)  

    RecLength :  156 (x009c)  IO Time  : 2020/11/14 22:01:21.000.000  

    IOType   :  135 (x87)   OrigNode  :  255 (xff) 

    TransInd  :   . (x03)   FormatType :   R (x52) 

    SyskeyLen :   0 (x00)   Incomplete :   . (x00) 

    AuditRBA  :     25    AuditPos  : 45593104 

    Continued :   N (x00)   RecCount  :   1 (x01) 


    2020/11/14 22:01:21.000.000 GGSUnifiedPKUpdate  Len  156 RBA 8883 

    Name: PDB1.APP_USER.EMP_TST (TDR Index: 1) 

    After Image:                       Partition x0c  G s  

     4d00 0000 0000 0a00 0000 0000 0000 0000 012c 0100 | M................,..  

     0900 0000 0500 7265 6464 7902 0015 0000 0032 3032 | ......reddy......202  

     302d 3131 2d31 313a 3231 3a33 373a 3433 0300 1500 | 0-11-11:21:37:43....  

     0000 3230 3230 2d31 312d 3131 3a32 313a 3337 3a34 | ..2020-11-11:21:37:4  

     3300 000a 0000 0000 0000 0000 0001 3101 0007 0000 | 3.............1.....  

     0003 0076 6967 0200 1500 0000 3230 3230 2d31 312d | ...vig......2020-11-  

     3134 3a32 323a 3031 3a31 3603 0015 0000 0032 3032 | 14:22:01:16......202  

    Before Image     Len  81 (x00000051) 

    BeforeColumnLen   77 (x0000004d) 

    Column   0 (x0000), Len  10 (x000a)  

     0000 0000 0000 0000 012c             | .........,  

    Column   1 (x0001), Len   9 (x0009)  

     0000 0500 7265 6464 79              | ....reddy  

    Column   2 (x0002), Len  21 (x0015)  

     0000 3230 3230 2d31 312d 3131 3a32 313a 3337 3a34 | ..2020-11-11:21:37:4  

     33                        | 3  

    Column   3 (x0003), Len  21 (x0015)  

     0000 3230 3230 2d31 312d 3131 3a32 313a 3337 3a34 | ..2020-11-11:21:37:4  

     33                        | 3  


    After Image      Len  75 (x0000004b) 

    Column   0 (x0000), Len  10 (x000a)  

     0000 0000 0000 0000 0131             | .........1  

    Column   1 (x0001), Len   7 (x0007)  

     0000 0300 7669 67                 | ....vig  

    Column   2 (x0002), Len  21 (x0015)  

     0000 3230 3230 2d31 312d 3134 3a32 323a 3031 3a31 | ..2020-11-14:22:01:1  

     36                        | 6  

    Column   3 (x0003), Len  21 (x0015)  

     0000 3230 3230 2d31 312d 3134 3a32 323a 3031 3a31 | ..2020-11-14:22:01:1  

     36                        | 6  

      

    GGS tokens: 

    TokenID x52 'R' ORAROWID     Info x00 Length  20 

     4141 4152 3951 4141 4d41 4141 4143 6a41 4164 0001 | AAAR9QAAMAAAACjAAd..  

    TokenID x4c 'L' LOGCSN      Info x00 Length  7 

     3239 3839 3738 37                 | 2989787  

    TokenID x36 '6' TRANID      Info x00 Length  17 

     3230 3538 3339 3034 352e 352e 372e 3838 36    | 205839045.5.7.886  

    TokenID x69 'i' ORATHREADID   Info x01 Length  2 

     0001                       | ..  

      logdump 73 >

    Regards,

    DR