I have nothing to do at last weekend, so I decided to make some changes to the MyLOG utility, I had added the search by redo layer/opcode feature two weeks ago, so I tried my best to add the search by object id feature. However the search by object id can only be performed on redo record of layer 11, which is the table data operations. It's a big improve for me, for the MyLOG utility.
If I focus on the layer 11 and master all the details, I should be able to write a logical replication utility like Quest SharePlex or GoldenGate. The fact is that I have to spend a lot of time in making money for the whole family by doing something not relative to this subject. Following is the search command syntax :
SEARCH option value [option value]
TAIL option value [option value]
DUMP option value [option value]
OPTION
OP layer
SUBOP opcode
START start redo block
END end redo block
BLOCK in given block
OBJECT object id
Let's try each of these command with the enhanced search feature!
LOG> tail object 61 start 2
Start tailing redo operation ...
0x00005e30.00003eb8.0010 2006-08-23 19:08:58
[05.02] [Trans Undo ] Update rollback segment header - KTURDH
[05.01] [Trans Undo ] Undo block or under segment header - KTURDB
[11.05] [Row Access ] Update Row Piece
[05.19] [Trans Undo ] Transaction start audit log record
LOG> search object 61 start 2
Start search opcode = [00.00] ...
Seq=24112, Start=16056, Offset=0x0010=16, End=16057, Time=2006-08-23 19:08:58
LOG> dump object 61 start 2
Start dump redo operation ...
REDO RECORD -- RBA=0x00005e30.00003eb8.0010 LEN=0x0284 VLD=0x01 SCN=0x031f.05c0098c
CHANGE#=0x01 OP=5.2 SEQ=1 TYP=0 CLS=43 OFFS=0x000c LEN=0x003c DBA=0x6280b402 ...
PIECE#=2 OFFS=0x001c LEN=0x0020 SIZE=0x0020
ktudh redo: slt=0x0045 sqn=0x000daa80 flag=0x0412 siz=228 fbi=0
uba=0x3b41c2dd.3bce.00 pxid=0x0000.000.00000000
CHANGE#=0x02 OP=5.1 SEQ=8 TYP=0 CLS=44 OFFS=0x0048 LEN=0x0114 DBA=0x3b41c2dd ...
PIECE#=2 OFFS=0x0038 LEN=0x0014 SIZE=0x0014
ktudb redo: siz=0x00e4 spc=0x000000ac flag=0x0012 seq=0x00ce rec=0x00
xid=0x000e.045.000daa80
PIECE#=3 OFFS=0x004c LEN=0x0030 SIZE=0x0030
ktubu redo: slt=69 rci=0 opc=11.1 objn=61 objd=61 tns=0
PIECE#=4 OFFS=0x007c LEN=0x0020 SIZE=0x0020
......
With these powerful command, I can make more improvement in log format research, and more smoothly.