Oracle Log 的格式资料整理

0d: Operation Code 0x0e - 0x0f: Change # CLS 0x10 - 0x11: Change # AFN 0x12 - 0x13: Change # TYPE 0x14 - 0x17: Change # DBA 0x18 - 0x1d: Change # SCN 0x1e - ....: Redo Data } } 4, Operation Layer Operation Code Layer = 5 (Transaction Undo)

0d: Operation Code

0x0e - 0x0f: Change # CLS

0x10 - 0x11: Change # AFN

0x12 - 0x13: Change # TYPE

0x14 - 0x17: Change # DBA

0x18 - 0x1d: Change # SCN

0x1e - ....: Redo Data

}

}

4, Operation Layer & Operation Code

Layer = 5 (Transaction Undo)

Op Code = 3 (Rollout a transaction begin)

= 4 (Commit transaction/Transaction table update - no undo record)

= 7 (Begin transaction/Transaction table update)

= 8 (Mark transaction as dead)

Layer = 11 (Row Access)

Op Code = 1 Interpret Undo Record

= 2 Insert Row Piece

= 3 Drop Row Piece

= 4 Lock Row Piece

= 5 Update Row Piece

= 6 Overwrite Row Piece

= 7 Manipulate First Column

= 8 Change forward address

= 9 Change Cluster key index

= 10 Set key links

= 11 Quick Multi-Insert (Insert ... select ...)

= 12 Quick Multi-Delete

= 13 Toggle block header flags