Oracle redo log file analysis (insert)

Oracle redo log file analysis (insert)
Oracle redo log file analysis (insert) 1: record the current scnselect dbms_flashback.get_system_change_number from dual; GET_SYSTEM_CHANGE_NUMBER -------------------- 11595722: Create a table

CREATE TABLE team(  team_code    VARCHAR2(3),  team_name    VARCHAR2(30),  country_code VARCHAR2(3));INSERT INTO team VALUES ('MCL','McLaren','GBR');COMMIT;

2: record the current scnSQL> select dbms_flashback.get_system_change_number from dual; GET_SYSTEM_CHANGE_NUMBER -------------------- 1159601 3: dump alter system dump logfile '/u01/app/oracle/oradata/devdb/redo01.log' scn min 1159572 scn max 1159601 4: File Analysis redo record-Thread: 1 RBA: 0x000019. 00000fef. 0010 LEN: 0x01e8 VLD: 0x0dSCN: 0x0000. 0011b1a0 SUBSCN: 1 06/03/2016 15:18:11 THEREAD: thread number 1; RBA: Serial Number + block number + block byte number LEN: length VLD: SCN: Change Time select to_number ('1195a5 ', 'xxxxxx') from dual 16to10select to_char (scn_to_timestamp (1159584), 'yyyy-MM-DD HH24: MI: ss') from dual; select timestamp_to_scn (to_date ('2017-03-06 15:18:15 ', 'yyyy-MM-DD HH24: MI: ss') from dual;
CHANGE #1 TYP: 0 CLS: 1 AFN: 5 DBA: 0x014000a5 OBJ: 73445 SCN: 0x0000. 0011aa1f SEQ: 2 OP: 11.2 ENC: 0 RBL: 0KTB Redoop: 0x01 ver: 0x01compat bit: 4 (post-11) padding: 1op: F xid: 0x0006. 01a. 00000313 uba: 0x00c00a6a. 00a7. 39 KDO Op code: IRP row dependencies Disabled xtype: XA flags: 0x00000000 bdba: 0x014000a5 hdba: 0x014000a2itli: 1 ispac: 0 maxfr: 4858 tabn: 0 slot: 0 (0x0) size/delt: 19fb: -- H-FL -- lb: 0x1 cc: 3 null: --- col 0: [3] 4d 43 4 ccol 1: [7] 4d 63 4c 61 72 65 6 ecol 2: [3] 47 42 52 change #1 change count TYP: 0 change type CLS: 1 refer to X $ BH class 1 to indicate the data block AFN: absolute data file number 5DBA: change the data block address 14000a5 (5/165) OBJ: object id
SCN: 0x0000. 0011aa1fseq: 2: Serial Number OP: 11.2 Insert Row Piece KTB REDOop: 01 F xid: 0x0006. 01a. 00000313 transaction ID uba: 0x00c00a6a. 00a7. 39. The rollback segment changes the address, serial number, and block Record Number KDO: IRP (Insert Row Piece) row dependencies Disabled (default creation indicates non-dependent, startup feature, new feature of the pseudo column ORA_ROWSCN)
Bdba: block address
Hdba: segment header addressitli: Transaction slot 1 tabn: 0 indicates non-cluster Table slot: 0 (0x0) slot numbersize/delt: 19 blocks change the size, increase by 19 bytesfb: -- H-FL -- lb: 0x1 locked transaction itil 1 (same as above) cc: 3 Number of inserted Columns
Col 0: [3] 4d 43 4 ccol 1: [7] 4d 63 4c 61 72 65 6 ecol 2: [3] 47 42 52 and above insert values