Discussions
Categories
- 17.9K All Categories
- 3.3K Industry Applications
- 3.3K Intelligent Advisor
- 60 Insurance
- 534.8K On-Premises Infrastructure
- 137.8K Analytics Software
- 38.6K Application Development Software
- 5.4K Cloud Platform
- 109.2K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.9K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
Logdump
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
-
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
-
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
