\u8be5\u6587\u6863\u4eceinsert\uff0cupdate\uff0cdelete\u6240\u4ea7\u751f\u7684dump\u6587\u4ef6\u8fdb\u884c\u5206\u6790\u5e76\u505a\u7b80\u8981\u8bf4\u660e
\n\u6570\u636e\u5e93\u7248\u672c<\/p>\n
\r\nsys@ora11gr2> select * from gv$version;\r\n\r\n INST_ID BANNER\r\n---------- --------------------------------------------------------------------------------\r\n 1 Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\n 1 PL\/SQL Release 11.2.0.3.0 - Production\r\n 1 CORE 11.2.0.3.0 Production\r\n 1 TNS for Linux: Version 11.2.0.3.0 - Production\r\n 1 NLSRTL Version 11.2.0.3.0 - Production\r\n\r\n5 rows selected.\r\n\r\nsys@ora11gr2> @registry_history.sql\r\n\r\nACTION_TIME ACTION NAMESPACE VERSION ID COMMENTS BUNDLE_SER\r\n-------------------- -------------------- -------------------- ---------- ---------- ------------------------------ ----------\r\n25-DEC-2012 13:24:04 APPLY SERVER 11.2.0.3 4 PSU 11.2.0.3.4 PSU\r\n\r\n1 row selected.\r\n<\/pre>\n\uff08\u4e00\uff09\u5206\u6790insert\u4ea7\u751f\u7684redo
\n\u521b\u5efa\u6d4b\u8bd5\u6570\u636e<\/p>\n\r\nsys@ora11gr2> create table yallonking(id number,name varchar2(20));\r\n\r\nTable created.\r\n\r\nsys@ora11gr2> alter system checkpoint;\r\n\r\nSystem altered.\r\n\r\nsys@ora11gr2> @show_current_scn\r\n\r\nCURRENT_SCN\r\n-----------\r\n 1144520\r\n\r\n1 row selected.\r\n\r\nsys@ora11gr2> insert into yallonking values(1,'yallonking');\r\n\r\n1 row created.\r\n\r\nsys@ora11gr2> commit;\r\n\r\nCommit complete.\r\n\r\nsys@ora11gr2> alter system checkpoint;\r\n\r\nSystem altered.\r\n\r\nsys@ora11gr2> @show_current_scn\r\n\r\nCURRENT_SCN\r\n-----------\r\n 1144530\r\n\r\n1 row selected.\r\n\r\nsys@ora11gr2> @show_current_logfile;\r\n\r\nMEMBER\r\n----------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/oradata\/ora11gr2\/redo01.log\r\n\r\n1 row selected.\r\n\r\nsys@ora11gr2> @dump_logfile_by_min_max_scn \/u01\/app\/oracle\/oradata\/ora11gr2\/redo01.log 1144520 1144530\r\nold 1: alter system dump logfile '&&1' scn min '&&2' scn max '&&3'\r\nnew 1: alter system dump logfile '\/u01\/app\/oracle\/oradata\/ora11gr2\/redo01.log' scn min '1144520' scn max '1144530'\r\n\r\nSystem altered.\r\n\r\n\r\nTRACE_FILE_NAME\r\n----------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_21655.trc\r\n\r\n1 row selected.\r\n\r\n<\/pre>\n--\u76f8\u5173\u8bf4\u660e\uff1a<\/p>\n
\r\n--Thread - redo log thread number\r\n--RBA - redo byte address - address of redo record within redo log. Format is <sequence_number>.<block_number>.<offset>\r\n--LEN - length of redo record in bytes including header\r\n--VLD - see below\r\n--SCN - system change number of redo record\r\n--SUBSCN: Unknown\r\n--Timestamp e.g. 05\/07\/2009 21:53:48\r\n\r\n--VLD\u5217\u7684\u8bf4\u660e\uff1a\r\n--Mnemonic\tValue\tDescription\r\n--KCRVOID\t0\t\tThe contents are not valid\r\n--KCRVALID\t1\t\tIncludes change vectors\r\n--KCRDEPND\t2\t\tIncludes commit SCN\r\n--KCRVOID\t4\t\tIncludes dependent SCN\r\n--KCRNMARK\t8\t\tNew SCN mark record. SCN allocated exactly at this point in the redo log by this instance\r\n--KCROMARK\t16\t\tOld SCN mark record. SCN allocated at or before this point in the redo. May be allocated by another instance\r\n--KCRORDER\t32\t\tNew SCN was allocated to ensure redo for some block would be ordered by inc\/seq# when redo sorted by SCN\r\n\r\n--\u64cd\u4f5c\u7801\u8bf4\u660e\r\n--Level\tDescription\r\n--4\t\tBlock Cleanout\r\n--5 \tTransaction Layer (Undo)\r\n--10 \tIndex Operation\r\n--11 \tTable Operation (DML)\r\n--13\tBlock Allocation\r\n--14\tExtent Allocation\r\n--17\tBackup Management\r\n--18 \tOnline Backup\r\n--19\tDirect Load\r\n--20\tTransaction Metadata (LogMiner)\r\n--22\tSpace Management (ASSM)\r\n--23 \tBlock Write (DBWR)\r\n--24 \tDDL Statement\r\n<\/pre>\n\u67e5\u770bdump\u6587\u4ef6<\/p>\n
\r\n[oracle@rhl6 dba_scripts]$ cat \/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_21655.trc\r\nTrace file \/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_21655.trc\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0\/db_1\r\nSystem name: Linux\r\nNode name: rhl6.0x64\r\nRelease: 2.6.32-71.el6.x86_64\r\nVersion: #1 SMP Wed Sep 1 01:33:01 EDT 2010\r\nMachine: x86_64\r\nVM name: VMWare Version: 6\r\nInstance name: ora11gr2\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 26\r\nUnix process pid: 21655, image: oracle@rhl6.0x64 (TNS V1-V3)\r\n\r\n\r\n*** 2013-12-21 18:09:13.933\r\n*** SESSION ID:(35.39) 2013-12-21 18:09:13.933\r\n*** CLIENT ID:() 2013-12-21 18:09:13.933\r\n*** SERVICE NAME:(SYS$USERS) 2013-12-21 18:09:13.933\r\n*** MODULE NAME:(sqlplus@rhl6.0x64 (TNS V1-V3)) 2013-12-21 18:09:13.933\r\n*** ACTION NAME:() 2013-12-21 18:09:13.933\r\n \r\nInitial buffer sizes: read 1024K, overflow 832K, change 805K\r\nLog read is SYNCHRONOUS though disk_asynch_io is enabled!\r\n \r\nDUMP OF REDO FROM FILE '\/u01\/app\/oracle\/oradata\/ora11gr2\/redo01.log'\r\n Opcodes *.*\r\n RBAs: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff\r\n SCNs: scn: 0x0000.001176c8 (1144520) thru scn: 0x0000.001176d2 (1144530)\t\t-->dump\u7684scn\u8303\u56f4\r\n Times: creation thru eternity\r\n FILE HEADER:\r\n Compatibility Vsn = 186646528=0xb200000\r\n Db ID=119524391=0x71fcc27, Db Name='ORA11GR2'\t\t\t\t\t\t\t-->dbid\u548cdb_name\r\n Activation ID=119541799=0x7201027\r\n Control Seq=2793=0xae9, File size=102400=0x19000\r\n File Number=1, Blksiz=512, File Type=2 LOG\t\t\t\t\t\t\t\t-->log\u6587\u4ef6\u7684\u5927\u5c0f\r\n descrip:"Thread 0001, Seq# 0000000187, SCN 0x0000001151ab-0xffffffffffff"\r\n thread: 1 nab: 0xffffffff seq: 0x000000bb hws: 0x5 eot: 1 dis: 0\r\n resetlogs count: 0x2fdc16a7 scn: 0x0000.00000001 (1)\r\n prev resetlogs count: 0x0 scn: 0x0000.00000000\r\n Low scn: 0x0000.001151ab (1135019) 12\/21\/2013 04:22:12\t\t\t\t\t\t--\u8bb0\u5f55\u524d\u4e00\u4e2ascn\u7684\u65f6\u95f4\u70b9\r\n Next scn: 0xffff.ffffffff 01\/01\/1988 00:00:00\r\n Enabled scn: 0x0000.00000001 (1) 12\/25\/2012 10:28:49\r\n Thread closed scn: 0x0000.00115f5d (1138525) 12\/21\/2013 06:00:13\r\n Disk cksum: 0x551b Calc cksum: 0x551b\r\n Terminal recovery stop scn: 0x0000.00000000\r\n Terminal recovery 01\/01\/1988 00:00:00\r\n Most recent redo scn: 0x0000.00000000\r\n Largest LWN: 0 blocks\r\n End-of-redo stream : No\r\n Unprotected mode\r\n Miscellaneous flags: 0x800000\r\n Thread internal enable indicator: thr: 0, seq: 0 scn: 0x0000.00000000\r\n Zero blocks: 0\r\n Format ID is 2\r\n redo log key is 21456ab701e44ef1153cb3aa1444478\r\n redo log key flag is 5\r\n Enabled redo threads: 1 \r\n \r\nREDO RECORD - Thread:1 RBA: 0x0000bb.00003cc1.002c LEN: 0x00b8 VLD: 0x01\t\t-->\u5f00\u59cb\u8bb0\u5f55insert\u64cd\u4f5c\u7684redo\r\nSCN: 0x0000.001176c8 SUBSCN: 1 12\/21\/2013 18:08:17\t\t\t\t\t\t\t\t-->scn:001176c8(1144520)\r\n(LWN RBA: 0x0000bb.00003cc0.0010 LEN: 0002 NST: 0001 SCN: 0x0000.001176c5)\r\nCHANGE #1 TYP:0 CLS:27 AFN:3 DBA:0x00c000d0 OBJ:4294967295 SCN:0x0000.001176c3 SEQ:1 OP:5.4 ENC:0 RBL:0\r\nktucm redo: slt: 0x0001 sqn: 0x000003a7 srt: 0 sta: 9 flg: 0x2 ktucf redo: uba: 0x00c00281.00d1.3b ext: 5 spc: 676 fbi: 1 \r\n--OP:5.4\u6307\u7684\u662f\u66f4\u65b0\u4e8b\u52a1\u8868\uff0c\u53ef\u4ee5\u7406\u89e3\u4e3a\u4e8b\u52a1\u5f00\u59cb,\u901a\u8fc7uba\u53ef\u4ee5\u627e\u5230\u4e8b\u52a1\u76f8\u5173\u4fe1\u606f\r\n--\u4e0a\u8fb9OBJ:4294967295=2\u768432\u6b21\u65b9-1\uff0c\u662f\u4e00\u4e2a\u7279\u6b8a\u7684\u503c\uff0cAFN:3\u6307\u7684\u662f3\u53f7\u6587\u4ef6\u4e5f\u5c31\u662fundo\u6587\u4ef6\r\n \r\nCHANGE #2 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:17.28 ENC:0\r\nSTANDBY METADATA CACHE INVALIDATION\r\nKQR INFO:\r\n[f61c5d2b, 2, 0]\r\n[7d7929f7, 8, 6153]\r\nKGL INFO:\r\n[6af25f1f.e8a5bd88.6f5cabdc.efc9104d, 1]\r\n[6af25f1f.e8a5bd88.6f5cabdc.efc9104d, 1]\r\n--OP:17.28\uff1alevel-17\u662f\u548c\u5907\u4efd\u76f8\u5173\u7684\uff0c28\u4e0d\u8be6\uff0c\u731c\u6d4b\u662f\u548c\u5907\u5e93\u6062\u590d\u76f8\u5173\r\n\r\nREDO RECORD - Thread:1 RBA: 0x0000bb.00003cc2.0010 LEN: 0x0220 VLD: 0x06\r\nSCN: 0x0000.001176cb SUBSCN: 1 12\/21\/2013 18:08:25\r\n(LWN RBA: 0x0000bb.00003cc2.0010 LEN: 0002 NST: 0001 SCN: 0x0000.001176ca)\r\nCHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0\r\n Block Written - afn: 3 rdba: 0x00c00281 BFT:(1024,12583553) non-BFT:(3,641)\r\n scn: 0x0000.001176c7 seq: 0x01 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c00282 BFT:(1024,12583554) non-BFT:(3,642)\r\n scn: 0x0000.001176c2 seq: 0x05 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c00163 BFT:(1024,12583267) non-BFT:(3,355)\r\n scn: 0x0000.001176b2 seq: 0x01 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c00100 BFT:(1024,12583168) non-BFT:(3,256)\r\n scn: 0x0000.001176b3 seq: 0x01 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c000e6 BFT:(1024,12583142) non-BFT:(3,230)\r\n scn: 0x0000.001176b7 seq: 0x01 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c000e0 BFT:(1024,12583136) non-BFT:(3,224)\r\n scn: 0x0000.001176b8 seq: 0x01 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c000d0 BFT:(1024,12583120) non-BFT:(3,208)\r\n scn: 0x0000.001176c8 seq: 0x01 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c000b0 BFT:(1024,12583088) non-BFT:(3,176)\r\n scn: 0x0000.001176af seq: 0x01 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c000b1 BFT:(1024,12583089) non-BFT:(3,177)\r\n scn: 0x0000.001176ae seq: 0x01 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c000ac BFT:(1024,12583084) non-BFT:(3,172)\r\n scn: 0x0000.001176a4 seq: 0x01 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c000a0 BFT:(1024,12583072) non-BFT:(3,160)\r\n scn: 0x0000.001176a5 seq: 0x01 flg:0x04\r\n Block Written - afn: 1 rdba: 0x004138a8 BFT:(1024,4274344) non-BFT:(1,80040)\r\n scn: 0x0000.001176be seq: 0x02 flg:0x04\r\n Block Written - afn: 1 rdba: 0x004122b0 BFT:(1024,4268720) non-BFT:(1,74416)\r\n scn: 0x0000.001176c3 seq: 0x01 flg:0x06\r\n Block Written - afn: 1 rdba: 0x0041114f BFT:(1024,4264271) non-BFT:(1,69967)\r\n scn: 0x0000.001176c0 seq: 0x01 flg:0x06\r\n Block Written - afn: 1 rdba: 0x00411149 BFT:(1024,4264265) non-BFT:(1,69961)\r\n scn: 0x0000.001176c8 seq: 0x01 flg:0x06\r\n Block Written - afn: 1 rdba: 0x0041114a BFT:(1024,4264266) non-BFT:(1,69962)\r\n scn: 0x0000.001176c8 seq: 0x01 flg:0x06\r\n Block Written - afn: 1 rdba: 0x004108ec BFT:(1024,4262124) non-BFT:(1,67820)\r\n scn: 0x0000.001176c8 seq: 0x01 flg:0x06\r\n Block Written - afn: 1 rdba: 0x00410722 BFT:(1024,4261666) non-BFT:(1,67362)\r\n scn: 0x0000.001176c8 seq: 0x01 flg:0x06\r\n Block Written - afn: 1 rdba: 0x0040fd66 BFT:(1024,4259174) non-BFT:(1,64870)\r\n scn: 0x0000.001176c8 seq: 0x01 flg:0x06\r\n Block Written - afn: 1 rdba: 0x0040f5b5 BFT:(1024,4257205) non-BFT:(1,62901)\r\n scn: 0x0000.001176c8 seq: 0x01 flg:0x06\r\n Block Written - afn: 1 rdba: 0x0040c3c8 BFT:(1024,4244424) non-BFT:(1,50120)\r\n scn: 0x0000.001176c8 seq: 0x01 flg:0x06\r\n Block Written - afn: 1 rdba: 0x00407643 BFT:(1024,4224579) non-BFT:(1,30275)\r\n scn: 0x0000.001176c8 seq: 0x01 flg:0x06\r\n Block Written - afn: 1 rdba: 0x004059e0 BFT:(1024,4217312) non-BFT:(1,23008)\r\n scn: 0x0000.001176c8 seq: 0x01 flg:0x06\r\n Block Written - afn: 1 rdba: 0x00403437 BFT:(1024,4207671) non-BFT:(1,13367)\r\n scn: 0x0000.001176c8 seq: 0x01 flg:0x06\r\n Block Written - afn: 1 rdba: 0x0040342f BFT:(1024,4207663) non-BFT:(1,13359)\r\n scn: 0x0000.001176c8 seq: 0x01 flg:0x06\r\n Block Written - afn: 1 rdba: 0x00400090 BFT:(1024,4194448) non-BFT:(1,144)\r\n scn: 0x0000.001176c2 seq: 0x01 flg:0x04\r\n Block Written - afn: 1 rdba: 0x00400002 BFT:(1024,4194306) non-BFT:(1,2)\r\n scn: 0x0000.001176be seq: 0x02 flg:0x04\r\n Block Written - afn: 1 rdba: 0x00400003 BFT:(1024,4194307) non-BFT:(1,3)\r\n scn: 0x0000.001176be seq: 0x01 flg:0x04\r\n--OP:23.1\u6307\u7684\u662fdummy block written callback\r\n\r\nREDO RECORD - Thread:1 RBA: 0x0000bb.00003cc4.0010 LEN: 0x02b0 VLD: 0x0d\r\nSCN: 0x0000.001176d2 SUBSCN: 1 12\/21\/2013 18:08:41\r\n(LWN RBA: 0x0000bb.00003cc4.0010 LEN: 0002 NST: 0001 SCN: 0x0000.001176d1)\r\nCHANGE #1 TYP:1 CLS:1 AFN:1 DBA:0x004138a9 OBJ:71689 SCN:0x0000.001176cf SEQ:1 OP:13.5 ENC:0 RBL:0\r\nKTSFRBFMT (block format) redo: Segobjd: 0x00011809 type: 1 itls: 2 cscn: 0x0000.001176cf\r\n--OP:13.5\u6307\u7684\u662fnew block\u683c\u5f0f\u5316\u4e00\u4e2a\u65b0\u7684segment head\r\n\r\nCHANGE #2 TYP:0 CLS:1 AFN:1 DBA:0x004138a9 OBJ:71689 SCN:0x0000.001176d2 SEQ:1 OP:13.6 ENC:0 RBL:0\r\nKTSFRBLNK (block link modify) redo: Opcode: LSET (lock set)\r\nNext dba: 0x004138aa itli: 0\r\nCHANGE #3 TYP:0 CLS:1 AFN:1 DBA:0x004138a9 OBJ:71689 SCN:0x0000.001176d2 SEQ:2 OP:13.6 ENC:0 RBL:0\r\nKTSFRBLNK (block link modify) redo: Opcode: LWRT (lock write)\r\nNext dba: 0x00000000 itli: 0\r\n--OP:13.6\u6307\u7684\u662fformat block\u683c\u5f0f\u5316\u4e00\u4e2a\u6570\u636e\u5757\r\n\r\nCHANGE #4 TYP:0 CLS:4 AFN:1 DBA:0x004138a8 OBJ:71689 SCN:0x0000.001176be SEQ:2 OP:13.7 ENC:0 RBL:0\r\nKTSFRGRP (fgb\/shdr modify freelist) redo:\r\n Opcode: HWMMV (move hwm)\r\nNBK: 1\r\n Opcode: LUPD_LLIST (link a list)\r\nSlot no: 0, Count: 1\r\nFlag: = 1 xid or slot0 ccnt: 0x0000.000.00000001 Head: 0x004138a9 Tail: 0x004138a9 \r\n--OP:13.7\u6307\u7684\u662f\u4fee\u6539\u7a7a\u95f2\u5217\u8868\uff0c\u53ef\u4ee5\u7406\u89e3\u4e3a\u8bbe\u7f6e\u9ad8\u6c34\u4f4d\u7ebf\r\n\r\nCHANGE #5 TYP:0 CLS:1 AFN:1 DBA:0x004138a9 OBJ:71689 SCN:0x0000.001176d2 SEQ:3 OP:11.2 ENC:0 RBL:0\r\nKTB Redo \r\nop: 0x01 ver: 0x01 \r\ncompat bit: 4 (post-11) padding: 1\r\nop: F xid: 0x0008.002.00000303 uba: 0x00c0039c.00ea.1a\r\nKDO Op code: IRP row dependencies Disabled\r\n xtype: XA flags: 0x00000000 bdba: 0x004138a9 hdba: 0x004138a8\r\nitli: 1 ispac: 0 maxfr: 4863\r\ntabn: 0 slot: 0(0x0) size\/delt: 17\r\nfb: --H-FL-- lb: 0x1 cc: 2\r\nnull: --\r\ncol 0: [ 2] c1 02\t\t\t\t\t\t\t\t\t-->1\r\ncol 1: [10] 79 61 6c 6c 6f 6e 6b 69 6e 67\t\t\t-->'yallonking'\r\n<\/pre>\n--OP:11.2\u6307\u7684\u662f\u63d2\u5165\u884c\u8bb0\u5f55\uff0c\u5982\u4e0b\uff1a<\/p>\n
\r\n--sys@ora11gr2> select utl_raw.cast_to_varchar2('79616c6c6f6e6b696e67') from dual;\r\n--\r\n--UTL_RAW.CAST_TO_VARCHAR2('79616C6C6F6E6B696E67')\r\n------------------------------------------------------------------------------------------------------\r\n--yallonking\r\n--\r\n--1 row selected.\r\n--\r\n--sys@ora11gr2> select dump(1,16) from dual;\r\n--\r\n--DUMP(1,16)\r\n-------------------\r\n--Typ=2 Len=2: c1,2\r\n--\r\n--1 row selected.\r\n<\/pre>\n\r\nCHANGE #6 TYP:0 CLS:31 AFN:3 DBA:0x00c000f0 OBJ:4294967295 SCN:0x0000.00117681 SEQ:1 OP:5.2 ENC:0 RBL:0\r\nktudh redo: slt: 0x0002 sqn: 0x00000303 flg: 0x0012 siz: 112 fbi: 0\r\n uba: 0x00c0039c.00ea.1a pxid: 0x0000.000.00000000\r\n--OP:5.2\u6307\u7684\u662f\u66f4\u65b0\u56de\u6eda\u6bb5\u5934\r\n\r\nCHANGE #7 TYP:0 CLS:31 AFN:3 DBA:0x00c000f0 OBJ:4294967295 SCN:0x0000.001176d2 SEQ:1 OP:5.4 ENC:0 RBL:0\r\nktucm redo: slt: 0x0002 sqn: 0x00000303 srt: 0 sta: 9 flg: 0x2 ktucf redo: uba: 0x00c0039c.00ea.1a ext: 2 spc: 4822 fbi: 0 \r\n--OP:5.4\u6307\u7684\u662f\u8ddf\u65b0\u4e8b\u52a1\u8868\u5934\r\n\r\nCHANGE #8 TYP:0 CLS:32 AFN:3 DBA:0x00c0039c OBJ:4294967295 SCN:0x0000.00117680 SEQ:2 OP:5.1 ENC:0 RBL:0\r\nktudb redo: siz: 112 spc: 4936 flg: 0x0012 seq: 0x00ea rec: 0x1a\r\n xid: 0x0008.002.00000303 \r\nktubl redo: slt: 2 rci: 0 opc: 11.1 [objn: 71689 objd: 71689 tsn: 0]\r\nUndo type: Regular undo Begin trans Last buffer split: No \r\nTemp Object: No \r\nTablespace Undo: No \r\n 0x00000000 prev ctl uba: 0x00c0039c.00ea.0a \r\nprev ctl max cmt scn: 0x0000.00116a74 prev tx cmt scn: 0x0000.00116a83 \r\ntxn start scn: 0x0000.001176c8 logon user: 0 prev brb: 12583832 prev bcl: 0 BuExt idx: 0 flg2: 0\r\nKDO undo record:\r\nKTB Redo \r\nop: 0x03 ver: 0x01 \r\ncompat bit: 4 (post-11) padding: 1\r\nop: Z\r\nKDO Op code: DRP row dependencies Disabled\r\n xtype: XA flags: 0x00000000 bdba: 0x004138a9 hdba: 0x004138a8\r\nitli: 1 ispac: 0 maxfr: 4863\r\ntabn: 0 slot: 0(0x0)\r\n--OP:5.1\u6307\u7684\u662f\u751f\u6210undo\u6570\u636e\r\n\r\nEND OF REDO DUMP\r\n----- Redo read statistics for thread 1 -----\r\nRead rate (SYNC): 7779Kb in 0.23s => 33.03 Mb\/sec\r\nTotal redo bytes: 8191Kb Longest record: 13Kb, moves: 6\/14115 moved: 0Mb (0%)\r\nLongest LWN: 471Kb, reads: 1173 \r\nLast redo scn: 0x0000.001176d2 (1144530)\r\nChange vector header moves = 1610\/25720 (6%)\r\n----------------------------------------------\r\n<\/pre>\n\uff08\u4e8c\uff09\u5206\u6790update\u4ea7\u751f\u7684redo<\/p>\n
\r\nsys@ora11gr2> alter system checkpoint;\r\n\r\nSystem altered.\r\n\r\nsys@ora11gr2> @show_current_scn\r\n\r\nCURRENT_SCN\r\n-----------\r\n 1145537\r\n\r\n1 row selected.\r\n\r\nsys@ora11gr2> update yallonking set name='oraking' where id=1;\r\n\r\n1 row updated.\r\n\r\nsys@ora11gr2> commit;\r\n\r\nCommit complete.\r\n\r\nsys@ora11gr2> alter system checkpoint;\r\n\r\nSystem altered.\r\n\r\nsys@ora11gr2> @show_current_scn\r\n\r\nCURRENT_SCN\r\n-----------\r\n 1145611\r\n\r\n1 row selected.\r\n\r\nsys@ora11gr2> @show_current_logfile;\r\n\r\nMEMBER\r\n----------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/oradata\/ora11gr2\/redo01.log\r\n\r\n1 row selected.\r\n\r\nsys@ora11gr2> @dump_logfile_by_min_max_scn \/u01\/app\/oracle\/oradata\/ora11gr2\/redo01.log 1145537 1145611\r\nold 1: alter system dump logfile '&&1' scn min '&&2' scn max '&&3'\r\nnew 1: alter system dump logfile '\/u01\/app\/oracle\/oradata\/ora11gr2\/redo01.log' scn min '1145537' scn max '1145611'\r\n\r\nSystem altered.\r\n\r\n\r\nTRACE_FILE_NAME\r\n----------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_21785.trc\r\n\r\n1 row selected.\r\n\r\n\u5f00\u59cb\u5206\u6790trace\u6587\u4ef6\r\n[oracle@rhl6 dba_scripts]$ cat \/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_21785.trc\r\nTrace file \/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_21785.trc\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0\/db_1\r\nSystem name: Linux\r\nNode name: rhl6.0x64\r\nRelease: 2.6.32-71.el6.x86_64\r\nVersion: #1 SMP Wed Sep 1 01:33:01 EDT 2010\r\nMachine: x86_64\r\nVM name: VMWare Version: 6\r\nInstance name: ora11gr2\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 26\r\nUnix process pid: 21785, image: oracle@rhl6.0x64 (TNS V1-V3)\r\n\r\n\r\n*** 2013-12-21 18:49:53.630\r\n*** SESSION ID:(35.41) 2013-12-21 18:49:53.630\r\n*** CLIENT ID:() 2013-12-21 18:49:53.630\r\n*** SERVICE NAME:(SYS$USERS) 2013-12-21 18:49:53.630\r\n*** MODULE NAME:(sqlplus@rhl6.0x64 (TNS V1-V3)) 2013-12-21 18:49:53.630\r\n*** ACTION NAME:() 2013-12-21 18:49:53.630\r\n \r\nInitial buffer sizes: read 1024K, overflow 832K, change 805K\r\nLog read is SYNCHRONOUS though disk_asynch_io is enabled!\r\n \r\nDUMP OF REDO FROM FILE '\/u01\/app\/oracle\/oradata\/ora11gr2\/redo01.log'\r\n Opcodes *.*\r\n RBAs: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff\r\n SCNs: scn: 0x0000.00117ac1 (1145537) thru scn: 0x0000.00117b0b (1145611)\r\n Times: creation thru eternity\r\n FILE HEADER:\r\n Compatibility Vsn = 186646528=0xb200000\r\n Db ID=119524391=0x71fcc27, Db Name='ORA11GR2'\r\n Activation ID=119541799=0x7201027\r\n Control Seq=2793=0xae9, File size=102400=0x19000\r\n File Number=1, Blksiz=512, File Type=2 LOG\r\n descrip:"Thread 0001, Seq# 0000000187, SCN 0x0000001151ab-0xffffffffffff"\r\n thread: 1 nab: 0xffffffff seq: 0x000000bb hws: 0x5 eot: 1 dis: 0\r\n resetlogs count: 0x2fdc16a7 scn: 0x0000.00000001 (1)\r\n prev resetlogs count: 0x0 scn: 0x0000.00000000\r\n Low scn: 0x0000.001151ab (1135019) 12\/21\/2013 04:22:12\r\n Next scn: 0xffff.ffffffff 01\/01\/1988 00:00:00\r\n Enabled scn: 0x0000.00000001 (1) 12\/25\/2012 10:28:49\r\n Thread closed scn: 0x0000.00115f5d (1138525) 12\/21\/2013 06:00:13\r\n Disk cksum: 0x551b Calc cksum: 0x551b\r\n Terminal recovery stop scn: 0x0000.00000000\r\n Terminal recovery 01\/01\/1988 00:00:00\r\n Most recent redo scn: 0x0000.00000000\r\n Largest LWN: 0 blocks\r\n End-of-redo stream : No\r\n Unprotected mode\r\n Miscellaneous flags: 0x800000\r\n Thread internal enable indicator: thr: 0, seq: 0 scn: 0x0000.00000000\r\n Zero blocks: 0\r\n Format ID is 2\r\n redo log key is 21456ab701e44ef1153cb3aa1444478\r\n redo log key flag is 5\r\n Enabled redo threads: 1 \r\n \r\nREDO RECORD - Thread:1 RBA: 0x0000bb.00003df0.0038 LEN: 0x00b0 VLD: 0x01\r\nSCN: 0x0000.00117ac1 SUBSCN: 1 12\/21\/2013 18:46:12\r\n(LWN RBA: 0x0000bb.00003dea.0010 LEN: 0007 NST: 0001 SCN: 0x0000.00117ac0)\r\nCHANGE #1 TYP:0 CLS:33 AFN:3 DBA:0x00c00100 OBJ:4294967295 SCN:0x0000.00117ac0 SEQ:2 OP:5.4 ENC:0 RBL:0\r\nktucm redo: slt: 0x0001 sqn: 0x00000301 srt: 0 sta: 9 flg: 0x2 ktucf redo: uba: 0x00c00164.0109.03 ext: 2 spc: 7768 fbi: 0 \r\nCHANGE #2 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:17.28 ENC:0\r\nSTANDBY METADATA CACHE INVALIDATION\r\nKQR INFO:\r\n[4c5c20f7, 8, 58867]\r\nKGL INFO:\r\n[e63270d7.f6f06449.1d077b12.c9b8539e, 1]\r\n[e63270d7.f6f06449.1d077b12.c9b8539e, 1]\r\n \r\nREDO RECORD - Thread:1 RBA: 0x0000bb.00003df1.0010 LEN: 0x0070 VLD: 0x06\r\nSCN: 0x0000.00117acd SUBSCN: 1 12\/21\/2013 18:46:49\r\n(LWN RBA: 0x0000bb.00003df1.0010 LEN: 0002 NST: 0001 SCN: 0x0000.00117acd)\r\nCHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0\r\n Block Written - afn: 3 rdba: 0x00c00100 BFT:(1024,12583168) non-BFT:(3,256)\r\n scn: 0x0000.00117ac1 seq: 0x01 flg:0x04\r\n \r\nREDO RECORD - Thread:1 RBA: 0x0000bb.00003df1.0080 LEN: 0x0044 VLD: 0x02\r\nSCN: 0x0000.00117acd SUBSCN: 1 12\/21\/2013 18:46:49\r\nCHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0\r\n Block Written - afn: 1 rdba: 0x00402fe9 BFT:(1024,4206569) non-BFT:(1,12265)\r\n scn: 0x0000.00117ac1 seq: 0x01 flg:0x06\r\n \r\nREDO RECORD - Thread:1 RBA: 0x0000bb.00003df1.00c4 LEN: 0x0054 VLD: 0x02\r\nSCN: 0x0000.00117acd SUBSCN: 1 12\/21\/2013 18:46:49\r\nCHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0\r\n Block Written - afn: 3 rdba: 0x00c00163 BFT:(1024,12583267) non-BFT:(3,355)\r\n scn: 0x0000.00117ac0 seq: 0x05 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c00164 BFT:(1024,12583268) non-BFT:(3,356)\r\n scn: 0x0000.00117ac0 seq: 0x04 flg:0x04\r\n \r\nREDO RECORD - Thread:1 RBA: 0x0000bb.00003df1.0118 LEN: 0x0044 VLD: 0x02\r\nSCN: 0x0000.00117acd SUBSCN: 1 12\/21\/2013 18:46:49\r\nCHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0\r\n Block Written - afn: 2 rdba: 0x00800ecb BFT:(1024,8392395) non-BFT:(2,3787)\r\n scn: 0x0000.00117ac1 seq: 0x01 flg:0x06\r\n \r\nREDO RECORD - Thread:1 RBA: 0x0000bb.00003df1.015c LEN: 0x0044 VLD: 0x02\r\nSCN: 0x0000.00117acd SUBSCN: 1 12\/21\/2013 18:46:49\r\nCHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0\r\n Block Written - afn: 1 rdba: 0x00402fc2 BFT:(1024,4206530) non-BFT:(1,12226)\r\n scn: 0x0000.00117ac1 seq: 0x01 flg:0x06\r\n \r\nREDO RECORD - Thread:1 RBA: 0x0000bb.00003df1.01a0 LEN: 0x0044 VLD: 0x02\r\nSCN: 0x0000.00117acd SUBSCN: 1 12\/21\/2013 18:46:49\r\nCHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0\r\n Block Written - afn: 2 rdba: 0x00800edb BFT:(1024,8392411) non-BFT:(2,3803)\r\n scn: 0x0000.00117ac1 seq: 0x01 flg:0x06\r\n \r\nREDO RECORD - Thread:1 RBA: 0x0000bb.00003df1.01e4 LEN: 0x0044 VLD: 0x02\r\nSCN: 0x0000.00117acd SUBSCN: 1 12\/21\/2013 18:46:49\r\nCHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0\r\n Block Written - afn: 3 rdba: 0x00c000e0 BFT:(1024,12583136) non-BFT:(3,224)\r\n scn: 0x0000.00117a48 seq: 0x01 flg:0x04\r\n \r\nREDO RECORD - Thread:1 RBA: 0x0000bb.00003df2.0038 LEN: 0x0044 VLD: 0x02\r\nSCN: 0x0000.00117acd SUBSCN: 1 12\/21\/2013 18:46:49\r\nCHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0\r\n Block Written - afn: 1 rdba: 0x00402ff1 BFT:(1024,4206577) non-BFT:(1,12273)\r\n scn: 0x0000.00117abf seq: 0x01 flg:0x06\r\n \r\nREDO RECORD - Thread:1 RBA: 0x0000bb.00003df2.007c LEN: 0x0044 VLD: 0x02\r\nSCN: 0x0000.00117acd SUBSCN: 1 12\/21\/2013 18:46:49\r\nCHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0\r\n Block Written - afn: 3 rdba: 0x00c000e7 BFT:(1024,12583143) non-BFT:(3,231)\r\n scn: 0x0000.00117a47 seq: 0x0a flg:0x04\r\n \r\nREDO RECORD - Thread:1 RBA: 0x0000bb.00003df2.00c0 LEN: 0x0044 VLD: 0x02\r\nSCN: 0x0000.00117acd SUBSCN: 1 12\/21\/2013 18:46:49\r\nCHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0\r\n Block Written - afn: 1 rdba: 0x0040d24d BFT:(1024,4248141) non-BFT:(1,53837)\r\n scn: 0x0000.00117ac1 seq: 0x01 flg:0x06\r\n \r\nREDO RECORD - Thread:1 RBA: 0x0000bb.00003df2.0104 LEN: 0x0044 VLD: 0x02\r\nSCN: 0x0000.00117acd SUBSCN: 1 12\/21\/2013 18:46:49\r\nCHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0\r\n Block Written - afn: 2 rdba: 0x0080f9df BFT:(1024,8452575) non-BFT:(2,63967)\r\n scn: 0x0000.00117ac1 seq: 0x01 flg:0x06\r\n \r\nREDO RECORD - Thread:1 RBA: 0x0000bb.00003df2.0148 LEN: 0x0044 VLD: 0x02\r\nSCN: 0x0000.00117acd SUBSCN: 1 12\/21\/2013 18:46:49\r\nCHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0\r\n Block Written - afn: 2 rdba: 0x00800ed4 BFT:(1024,8392404) non-BFT:(2,3796)\r\n scn: 0x0000.00117ac1 seq: 0x01 flg:0x06\r\n \r\nREDO RECORD - Thread:1 RBA: 0x0000bb.00003df3.0010 LEN: 0x0084 VLD: 0x05\r\nSCN: 0x0000.00117aea SUBSCN: 1 12\/21\/2013 18:48:09\r\n(LWN RBA: 0x0000bb.00003df3.0010 LEN: 0001 NST: 0001 SCN: 0x0000.00117ae8)\r\nCHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:24.4 ENC:0\r\n \r\nREDO RECORD - Thread:1 RBA: 0x0000bb.00003df4.0010 LEN: 0x01d0 VLD: 0x06\r\nSCN: 0x0000.00117b01 SUBSCN: 1 12\/21\/2013 18:49:07\r\n(LWN RBA: 0x0000bb.00003df4.0010 LEN: 0001 NST: 0001 SCN: 0x0000.00117b00)\r\nCHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0\r\n Block Written - afn: 3 rdba: 0x00c005bf BFT:(1024,12584383) non-BFT:(3,1471)\r\n scn: 0x0000.00117ab3 seq: 0x02 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c0039c BFT:(1024,12583836) non-BFT:(3,924)\r\n scn: 0x0000.00117ab1 seq: 0x01 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c0029b BFT:(1024,12583579) non-BFT:(3,667)\r\n scn: 0x0000.00117ab5 seq: 0x03 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c00282 BFT:(1024,12583554) non-BFT:(3,642)\r\n scn: 0x0000.00117a8e seq: 0x06 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c0019f BFT:(1024,12583327) non-BFT:(3,415)\r\n scn: 0x0000.00117aba seq: 0x04 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c00110 BFT:(1024,12583184) non-BFT:(3,272)\r\n scn: 0x0000.00117ab9 seq: 0x01 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c000fe BFT:(1024,12583166) non-BFT:(3,254)\r\n scn: 0x0000.00117ab8 seq: 0x03 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c000f0 BFT:(1024,12583152) non-BFT:(3,240)\r\n scn: 0x0000.00117ab1 seq: 0x02 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c000d0 BFT:(1024,12583120) non-BFT:(3,208)\r\n scn: 0x0000.00117a8f seq: 0x01 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c000c0 BFT:(1024,12583104) non-BFT:(3,192)\r\n scn: 0x0000.00117ab5 seq: 0x02 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c000b2 BFT:(1024,12583090) non-BFT:(3,178)\r\n scn: 0x0000.00117abe seq: 0x06 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c000b0 BFT:(1024,12583088) non-BFT:(3,176)\r\n scn: 0x0000.00117abf seq: 0x01 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c000ac BFT:(1024,12583084) non-BFT:(3,172)\r\n scn: 0x0000.00117abc seq: 0x02 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c000a0 BFT:(1024,12583072) non-BFT:(3,160)\r\n scn: 0x0000.00117abd seq: 0x01 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c00090 BFT:(1024,12583056) non-BFT:(3,144)\r\n scn: 0x0000.00117abb seq: 0x01 flg:0x04\r\n Block Written - afn: 3 rdba: 0x00c00080 BFT:(1024,12583040) non-BFT:(3,128)\r\n scn: 0x0000.00117ab3 seq: 0x02 flg:0x04\r\n Block Written - afn: 2 rdba: 0x0080f6a4 BFT:(1024,8451748) non-BFT:(2,63140)\r\n scn: 0x0000.00117a8f seq: 0x01 flg:0x06\r\n Block Written - afn: 2 rdba: 0x0080f680 BFT:(1024,8451712) non-BFT:(2,63104)\r\n scn: 0x0000.00117a8e seq: 0x01 flg:0x04\r\n Block Written - afn: 2 rdba: 0x008001a6 BFT:(1024,8389030) non-BFT:(2,422)\r\n scn: 0x0000.00117a8f seq: 0x01 flg:0x06\r\n Block Written - afn: 2 rdba: 0x0080019e BFT:(1024,8389022) non-BFT:(2,414)\r\n scn: 0x0000.00117a8f seq: 0x01 flg:0x06\r\n Block Written - afn: 1 rdba: 0x00405971 BFT:(1024,4217201) non-BFT:(1,22897)\r\n scn: 0x0000.00117ab3 seq: 0x03 flg:0x06\r\n Block Written - afn: 1 rdba: 0x004007f1 BFT:(1024,4196337) non-BFT:(1,2033)\r\n scn: 0x0000.00117ab5 seq: 0x03 flg:0x06\r\n Block Written - afn: 1 rdba: 0x004007e1 BFT:(1024,4196321) non-BFT:(1,2017)\r\n scn: 0x0000.00117ab5 seq: 0x02 flg:0x06\r\n--\u4ee5\u4e0a\u548cinsert\u4e00\u81f4\uff0c\u4e0d\u518d\u8d58\u8ff0\r\n\r\n\r\nREDO RECORD - Thread:1 RBA: 0x0000bb.00003df5.0010 LEN: 0x0234 VLD: 0x0d\r\nSCN: 0x0000.00117b0b SUBSCN: 1 12\/21\/2013 18:49:30\r\n(LWN RBA: 0x0000bb.00003df5.0010 LEN: 0002 NST: 0001 SCN: 0x0000.00117b0a)\r\nCHANGE #1 TYP:2 CLS:1 AFN:1 DBA:0x004138a9 OBJ:71689 SCN:0x0000.001176d2 SEQ:5 OP:11.5 ENC:0 RBL:0\r\nKTB Redo \r\nop: 0x11 ver: 0x01 \r\ncompat bit: 4 (post-11) padding: 1\r\nop: F xid: 0x0007.01f.000002f7 uba: 0x00c000e7.00ac.17\r\nBlock cleanout record, scn: 0x0000.00117b09 ver: 0x01 opt: 0x02, entries follow...\r\n itli: 1 flg: 2 scn: 0x0000.001176d2\r\nKDO Op code: URP row dependencies Disabled\r\n xtype: XA flags: 0x00000000 bdba: 0x004138a9 hdba: 0x004138a8\r\nitli: 2 ispac: 0 maxfr: 4863\r\ntabn: 0 slot: 0(0x0) flag: 0x2c lock: 2 ckix: 0\r\nncol: 2 nnew: 1 size: -3\t\t\t\t-->\u65b0\u5217\u503c\u6bd4\u4e4b\u524d\u7684\u5bbd\u5ea6\u5c11\u4e863\u4e2a\r\ncol 1: [ 7] 6f 72 61 6b 69 6e 67\t\t-->'oraking'\r\n--OP:11.5\u6307\u7684update row piece\r\n\r\nCHANGE #2 TYP:0 CLS:29 AFN:3 DBA:0x00c000e0 OBJ:4294967295 SCN:0x0000.00117a48 SEQ:1 OP:5.2 ENC:0 RBL:0\r\nktudh redo: slt: 0x001f sqn: 0x000002f7 flg: 0x0012 siz: 144 fbi: 0\r\n uba: 0x00c000e7.00ac.17 pxid: 0x0000.000.00000000\r\n--\u66f4\u65b0\u56de\u6eda\u6bb5\u5934\r\n\t\t\t\r\nCHANGE #3 TYP:0 CLS:29 AFN:3 DBA:0x00c000e0 OBJ:4294967295 SCN:0x0000.00117b0b SEQ:1 OP:5.4 ENC:0 RBL:0\r\nktucm redo: slt: 0x001f sqn: 0x000002f7 srt: 0 sta: 9 flg: 0x12 ktucf redo: uba: 0x00c000e7.00ac.17 ext: 0 spc: 4756 fbi: 0 \r\n--\u66f4\u65b0\u4e8b\u52a1\u8868\r\n\r\nCHANGE #4 TYP:0 CLS:30 AFN:3 DBA:0x00c000e7 OBJ:4294967295 SCN:0x0000.00117a47 SEQ:10 OP:5.1 ENC:0 RBL:0\r\nktudb redo: siz: 144 spc: 4902 flg: 0x0012 seq: 0x00ac rec: 0x17\r\n xid: 0x0007.01f.000002f7 \r\nktubl redo: slt: 31 rci: 0 opc: 11.1 [objn: 71689 objd: 71689 tsn: 0]\r\nUndo type: Regular undo Begin trans Last buffer split: No \r\nTemp Object: No \r\nTablespace Undo: No \r\n 0x00000000 prev ctl uba: 0x00c000e7.00ac.0d \r\nprev ctl max cmt scn: 0x0000.00116fce prev tx cmt scn: 0x0000.00117048 \r\ntxn start scn: 0x0000.00000000 logon user: 0 prev brb: 12583142 prev bcl: 0 BuExt idx: 0 flg2: 0\r\nKDO undo record:\r\nKTB Redo \r\nop: 0x03 ver: 0x01 \r\ncompat bit: 4 (post-11) padding: 1\r\nop: Z\r\nKDO Op code: URP row dependencies Disabled\r\n xtype: XA flags: 0x00000000 bdba: 0x004138a9 hdba: 0x004138a8\r\nitli: 2 ispac: 0 maxfr: 4863\r\ntabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 0\r\nncol: 2 nnew: 1 size: 3\t\t\t\t\t\t\t\t-->\u589e\u52a03\u4e2a\u5bbd\u5ea6\r\ncol 1: [10] 79 61 6c 6c 6f 6e 6b 69 6e 67\t\t\t-->'yallonking'\r\n--\u66f4\u65b0undo\u6bb5\r\n\r\nEND OF REDO DUMP\r\n----- Redo read statistics for thread 1 -----\r\nRead rate (SYNC): 7931Kb in 0.02s => 387.26 Mb\/sec\r\nTotal redo bytes: 8191Kb Longest record: 13Kb, moves: 6\/14559 moved: 0Mb (0%)\r\nLongest LWN: 471Kb, reads: 1280 \r\nLast redo scn: 0x0000.00117b0b (1145611)\r\nChange vector header moves = 1656\/26537 (6%)\r\n----------------------------------------------\r\n<\/pre>\n\uff08\u4e09\uff09\u5206\u6790delete\u4ea7\u751f\u7684redo<\/p>\n
\r\nsys@ora11gr2> alter system checkpoint;\r\n\r\nSystem altered.\r\n\r\nsys@ora11gr2> @show_current_scn\r\n\r\nCURRENT_SCN\r\n-----------\r\n 1145930\r\n\r\n1 row selected.\r\n\r\nsys@ora11gr2> delete from yallonking where id=1;\r\n\r\n1 row deleted.\r\n\r\nsys@ora11gr2> commit;\r\n\r\nCommit complete.\r\n\r\nsys@ora11gr2> alter system checkpoint;\r\n\r\nSystem altered.\r\n\r\nsys@ora11gr2> @show_current_scn\r\n\r\nCURRENT_SCN\r\n-----------\r\n 1145970\r\n\r\n1 row selected.\r\n\r\nsys@ora11gr2> @show_current_logfile;\r\n\r\nMEMBER\r\n----------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/oradata\/ora11gr2\/redo01.log\r\n\r\n1 row selected.\r\n\r\nsys@ora11gr2> @dump_logfile_by_min_max_scn \/u01\/app\/oracle\/oradata\/ora11gr2\/redo01.log 1145930 1145970\r\nold 1: alter system dump logfile '&&1' scn min '&&2' scn max '&&3'\r\nnew 1: alter system dump logfile '\/u01\/app\/oracle\/oradata\/ora11gr2\/redo01.log' scn min '1145930' scn max '1145970'\r\n\r\nSystem altered.\r\n\r\n\r\nTRACE_FILE_NAME\r\n----------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_21858.trc\r\n\r\n1 row selected.\r\n\r\n\r\n\u5f00\u59cb\u5206\u6790trace\u6587\u4ef6\r\n\u622a\u53d6\u6709\u7528\u7684\u90e8\u5206\r\nREDO RECORD - Thread:1 RBA: 0x0000bb.00004720.0010 LEN: 0x0224 VLD: 0x0d\r\nSCN: 0x0000.00117c72 SUBSCN: 1 12\/21\/2013 19:02:08\r\n(LWN RBA: 0x0000bb.00004720.0010 LEN: 0002 NST: 0001 SCN: 0x0000.00117c70)\r\nCHANGE #1 TYP:2 CLS:1 AFN:1 DBA:0x004138a9 OBJ:71689 SCN:0x0000.00117b0b SEQ:2 OP:11.3 ENC:0 RBL:0\r\nKTB Redo \r\nop: 0x11 ver: 0x01 \r\ncompat bit: 4 (post-11) padding: 1\r\nop: F xid: 0x0005.012.000002ff uba: 0x00c0029b.00b0.3a\r\nBlock cleanout record, scn: 0x0000.00117c71 ver: 0x01 opt: 0x02, entries follow...\r\n itli: 2 flg: 2 scn: 0x0000.00117b0b\r\nKDO Op code: DRP row dependencies Disabled\r\n xtype: XA flags: 0x00000000 bdba: 0x004138a9 hdba: 0x004138a8\r\nitli: 1 ispac: 0 maxfr: 4863\r\ntabn: 0 slot: 0(0x0)\r\n--OP:11.3\u6307\u7684\u662fdrop row piece\r\n\r\nCHANGE #2 TYP:0 CLS:25 AFN:3 DBA:0x00c000c0 OBJ:4294967295 SCN:0x0000.00117c3d SEQ:2 OP:5.2 ENC:0 RBL:0\r\nktudh redo: slt: 0x0012 sqn: 0x000002ff flg: 0x0012 siz: 184 fbi: 0\r\n uba: 0x00c0029b.00b0.3a pxid: 0x0000.000.00000000\r\n--\u66f4\u65b0\u56de\u6eda\u6bb5\u5934\r\n\t\t\t\r\nCHANGE #3 TYP:0 CLS:25 AFN:3 DBA:0x00c000c0 OBJ:4294967295 SCN:0x0000.00117c72 SEQ:1 OP:5.4 ENC:0 RBL:0\r\nktucm redo: slt: 0x0012 sqn: 0x000002ff srt: 0 sta: 9 flg: 0x2 ktucf redo: uba: 0x00c0029b.00b0.3a ext: 4 spc: 850 fbi: 0 \r\n--\u66f4\u65b0\u4e8b\u52a1\u8868\r\n\r\nCHANGE #4 TYP:0 CLS:26 AFN:3 DBA:0x00c0029b OBJ:4294967295 SCN:0x0000.00117c3d SEQ:2 OP:5.1 ENC:0 RBL:0\r\nktudb redo: siz: 184 spc: 1036 flg: 0x0012 seq: 0x00b0 rec: 0x3a\r\n xid: 0x0005.012.000002ff \r\nktubl redo: slt: 18 rci: 0 opc: 11.1 [objn: 71689 objd: 71689 tsn: 0]\r\nUndo type: Regular undo Begin trans Last buffer split: No \r\nTemp Object: No \r\nTablespace Undo: No \r\n 0x00000000 prev ctl uba: 0x00c0029b.00b0.38 \r\nprev ctl max cmt scn: 0x0000.0011754c prev tx cmt scn: 0x0000.0011754d \r\ntxn start scn: 0x0000.00000000 logon user: 0 prev brb: 12583230 prev bcl: 0 BuExt idx: 0 flg2: 0\r\nKDO undo record:\r\nKTB Redo \r\nop: 0x04 ver: 0x01 \r\ncompat bit: 4 (post-11) padding: 1\r\nop: L itl: xid: 0x0008.002.00000303 uba: 0x00c0039c.00ea.1a\r\n flg: C--- lkc: 0 scn: 0x0000.001176d2\r\nKDO Op code: IRP row dependencies Disabled\r\n xtype: XA flags: 0x00000000 bdba: 0x004138a9 hdba: 0x004138a8\r\nitli: 1 ispac: 0 maxfr: 4863\r\ntabn: 0 slot: 0(0x0) size\/delt: 14\r\nfb: --H-FL-- lb: 0x0 cc: 2\r\nnull: --\r\ncol 0: [ 2] c1 02\t\t\t\t\t-->1\r\ncol 1: [ 7] 6f 72 61 6b 69 6e 67\t-->'oraking'\r\n--\u5199undo\u6570\u636e\r\n\r\nEND OF REDO DUMP\r\n----- Redo read statistics for thread 1 -----\r\nRead rate (SYNC): 9104Kb in 0.06s => 148.19 Mb\/sec\r\nTotal redo bytes: 9215Kb Longest record: 23Kb, moves: 7\/15608 moved: 0Mb (0%)\r\nLongest LWN: 471Kb, reads: 1309 \r\nLast redo scn: 0x0000.00117c72 (1145970)\r\nChange vector header moves = 1800\/28764 (6%)\r\n----------------------------------------------\r\n<\/pre>\n\u6bd4\u8f83\u5404\u4e2a\u64cd\u4f5c\u4ea7\u751fredo\u60c5\u51b5<\/p>\n
\r\n\u63d2\u5165\uff1a\r\n----- Redo read statistics for thread 1 -----\r\nRead rate (SYNC): 7779Kb in 0.23s => 33.03 Mb\/sec\r\nTotal redo bytes: 8191Kb Longest record: 13Kb, moves: 6\/14115 moved: 0Mb (0%)\r\nLongest LWN: 471Kb, reads: 1173 \r\nLast redo scn: 0x0000.001176d2 (1144530)\r\nChange vector header moves = 1610\/25720 (6%)\r\n----------------------------------------------\r\n\r\n\u66f4\u65b0\uff1a\r\n----- Redo read statistics for thread 1 -----\r\nRead rate (SYNC): 7931Kb in 0.02s => 387.26 Mb\/sec\r\nTotal redo bytes: 8191Kb Longest record: 13Kb, moves: 6\/14559 moved: 0Mb (0%)\r\nLongest LWN: 471Kb, reads: 1280 \r\nLast redo scn: 0x0000.00117b0b (1145611)\r\nChange vector header moves = 1656\/26537 (6%)\r\n----------------------------------------------\r\n\r\n\u5220\u9664\uff1a\r\n----- Redo read statistics for thread 1 -----\r\nRead rate (SYNC): 9104Kb in 0.06s => 148.19 Mb\/sec\r\nTotal redo bytes: 9215Kb Longest record: 23Kb, moves: 7\/15608 moved: 0Mb (0%)\r\nLongest LWN: 471Kb, reads: 1309 \r\nLast redo scn: 0x0000.00117c72 (1145970)\r\nChange vector header moves = 1800\/28764 (6%)\r\n----------------------------------------------\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"\u8be5\u6587\u6863\u4eceinsert\uff0cupdate\uff0cdelete\u6240\u4ea7\u751f\u7684dump\u6587\u4ef6\u8fdb\u884c\u5206\u6790\u5e76\u505a\u7b80\u8981\u8bf4\u660e \u6570\u636e\u5e93\u7248\u672c sys@ […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[87],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1286"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1286"}],"version-history":[{"count":2,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1286\/revisions"}],"predecessor-version":[{"id":1293,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1286\/revisions\/1293"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1286"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}