\u8be5\u7bc7\u6587\u7ae0\u6a21\u62df\u7528\u6237\u6d3b\u52a8\u4e8b\u7269\u4e0a\u7684UNDO\u5757\u635f\u574f\u6062\u590d<\/p>\n
\u6570\u636e\u5e93\u7248\u672c<\/p>\n
\r\nSQL> 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<\/pre>\n\u4f1a\u8bdd1\t\t <\/p>\n
\r\nSQL> sho user\r\nUSER is "YALLONKING"\r\nSQL> create table yallonking (\r\n 2 id number,\r\n 3 name varchar2(1000),\r\n 4 constraint yallonking_pk primary key (id)\r\n 5 )\r\n 6 ;\r\n\r\nTable created.\r\n\r\nSQL> insert into yallonking values(1,'yallonking');\r\n\r\n1 row created.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n<\/pre>\n\u4f1a\u8bdd2\uff08\u8be5\u4f1a\u8bdd\u4e0d\u63d0\u4ea4\uff09<\/p>\n
\r\nSQL> sho user\r\nUSER is "YALLONKING"\r\nSQL> update yallonking set name='ORAKING';\r\n\r\n1 row updated.\r\n<\/pre>\n\u4f1a\u8bdd3
\n\u67e5\u770b\u4e0e\u6d3b\u52a8\u4f1a\u8bdd2\u76f8\u5173\u7684UNDO\u4fe1\u606f<\/p>\n\r\nSQL> sho user\r\nUSER is "SYS"\r\nSQL> select XIDUSN,XIDSLOT,XIDSQN,UBAFIL,UBABLK,UBASQN,UBAREC,STATUS,START_SCNB from v$transaction;\r\n\r\n XIDUSN XIDSLOT XIDSQN UBAFIL UBABLK UBASQN UBAREC STATUS START_SCNB\r\n---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------------- ----------\r\n 5 9 713 3 14581 158 30 ACTIVE 810587\r\n<\/pre>\n\u6216\u8005<\/p>\n
\r\nSQL> select INDX,KTUXESTA,KTUXECFL,KTUXEPSQN,KTUXESCNW,KTUXESCNB,KTUXERDBF,KTUXERDBB,KTUXESIZ from x$ktuxe where KTUXESTA='ACTIVE';\r\n\r\n INDX KTUXESTA KTUXECFL KTUXEPSQN KTUXESCNW KTUXESCNB KTUXERDBF KTUXERDBB KTUXESIZ\r\n---------- ---------------- ------------------------ ---------- ---------- ---------- ---------- ---------- ----------\r\n 243 ACTIVE NONE 0 0 810587 3 14581 1\r\n\r\n<\/pre>\n\u8f6c\u50a8\u5bf9\u5e94UNDO\u5757<\/p>\n
\r\nSQL> oradebug setmypid\r\nStatement processed.\r\nSQL> alter system dump datafile 3 block 14581;\r\n\r\nSystem altered.\r\n\r\nSQL> oradebug tracefile_name\r\n\/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_12457.trc\r\n<\/pre>\ntrace\u6587\u4ef6\u90e8\u5206\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n
\r\nUNDO BLK:\r\nxid: 0x0005.009.000002c9 seq: 0x9e cnt: 0x1e irb: 0x1e icl: 0x0 flg: 0x0000\r\n\r\n Rec Offset Rec Offset Rec Offset Rec Offset Rec Offset\r\n---------------------------------------------------------------------------\r\n0x01 0x1fac 0x02 0x1f08 0x03 0x1ec0 0x04 0x1e90 0x05 0x1e50\r\n0x06 0x1e2c 0x07 0x1c9c 0x08 0x1b70 0x09 0x1ab0 0x0a 0x1a00\r\n0x0b 0x193c 0x0c 0x18d0 0x0d 0x1874 0x0e 0x17c0 0x0f 0x1764\r\n0x10 0x1708 0x11 0x1680 0x12 0x1620 0x13 0x1554 0x14 0x14a4\r\n0x15 0x1428 0x16 0x1378 0x17 0x12cc 0x18 0x121c 0x19 0x1148\r\n0x1a 0x10c0 0x1b 0x1054 0x1c 0x0f80 0x1d 0x0f1c 0x1e 0x0e8c\r\n\r\n\r\n*-----------------------------\r\n* Rec #0x1e slt: 0x09 objn: 71482(0x0001173a) objd: 71482 tblspc: 5(0x00000005)\r\n* Layer: 11 (Row) opc: 1 rci 0x00\r\nUndo type: Regular undo Begin trans Last buffer split: No\r\nTemp Object: No\r\nTablespace Undo: No\r\nrdba: 0x00000000Ext idx: 0\r\nflg2: 0\r\n*-----------------------------\r\nuba: 0x00c038f5.009e.1c ctl max scn: 0x0000.000c5504 prv tx scn: 0x0000.000c55ef\r\ntxn start scn: scn: 0x0000.000c5dec logon user: 80\r\n prev brb: 12597488 prev bcl: 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: 0x0140004f hdba: 0x0140004a\r\nitli: 2 ispac: 0 maxfr: 4858\r\ntabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 9\r\nncol: 2 nnew: 1 size: 3\r\ncol 1: [10] 79 61 6c 6c 6f 6e 6b 69 6e 67\r\n<\/pre>\n\u786e\u8ba4\u8be5UNDO\u5757<\/p>\n
\r\nSQL> set line 50\r\nSQL> select utl_raw.cast_to_varchar2('79616c6c6f6e6b696e67') from dual;\r\n\r\nUTL_RAW.CAST_TO_VARCHAR2('79616C6C6F6E6B696E67')\r\n--------------------------------------------------\r\nyallonking\r\n\r\n<\/pre>\n\u8f6c\u50a8UNDO\u6bb5\u5934<\/p>\n
\r\nSQL> oradebug setmypid\r\nStatement processed.\r\nSQL> alter system dump undo header '_SYSSMU5_1228822706$';\r\n\r\nSystem altered.\r\n\r\nSQL> oradebug tracefile_name\r\n\/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_16827.trc\r\nSQL> oradebug close_trace\r\nStatement processed.\r\n<\/pre>\ntrace\u6587\u4ef6\u4e2d\u4e5f\u53ef\u770b\u89c1\u6709\u4e00\u4e2a\u6d3b\u52a8\u4f1a\u8bdd\uff1a<\/p>\n
\r\n TRN TBL::\r\n \r\n index state cflags wrap# uel scn dba parent-xid nub stmt_num cmt\r\n ------------------------------------------------------------------------------------------------\r\n 0x00 9 0x00 0x02cc 0x0001 0x0000.000c59ea 0x00c038f3 0x0000.000.00000000 0x00000001 0x00000000 1387333397\r\n 0x01 9 0x00 0x02cf 0x0006 0x0000.000c5a25 0x00c038f3 0x0000.000.00000000 0x00000001 0x00000000 1387333533\r\n 0x02 9 0x00 0x02ce 0x0010 0x0000.000c578b 0x00c038f3 0x0000.000.00000000 0x00000001 0x00000000 1387332033\r\n 0x03 9 0x00 0x02cf 0xffff 0x0000.000c5df9 0x00c038f5 0x0000.000.00000000 0x00000001 0x00000000 1387335346\r\n 0x04 9 0x00 0x02ce 0x0007 0x0000.000c5890 0x00c038f3 0x0000.000.00000000 0x00000001 0x00000000 1387332632\r\n 0x05 9 0x00 0x02bf 0x0011 0x0000.000c5d3b 0x00c038f7 0x0000.000.00000000 0x00000003 0x00000000 1387335318\r\n 0x06 9 0x00 0x02ce 0x001b 0x0000.000c5a4e 0x00c038f3 0x0000.000.00000000 0x00000001 0x00000000 1387333623\r\n 0x07 9 0x00 0x02cf 0x0015 0x0000.000c5899 0x00c038f3 0x0000.000.00000000 0x00000001 0x00000000 1387332632\r\n 0x08 9 0x00 0x02ce 0x000f 0x0000.000c5833 0x00c038f3 0x0000.000.00000000 0x00000001 0x00000000 1387332415\r\n 0x09 10 0x90 0x02c9 0x0002 0x0000.000c5e5b 0x00c038f5 0x0000.000.00000000 0x00000001 0x00000000 0\r\n 0x0a 9 0x00 0x02ce 0x000d 0x0000.000c5c99 0x00c038ed 0x0000.000.00000000 0x00000001 0x00000000 1387335128\r\n 0x0b 9 0x00 0x02cd 0x0002 0x0000.000c5763 0x00c038f0 0x0000.000.00000000 0x00000001 0x00000000 1387332032\r\n 0x0c 9 0x00 0x02ce 0x0016 0x0000.000c58ab 0x00c038f3 0x0000.000.00000000 0x00000001 0x00000000 1387332632\r\n 0x0d 9 0x00 0x02ce 0x001d 0x0000.000c5ca2 0x00c038f5 0x0000.000.00000000 0x00000003 0x00000000 1387335128\r\n 0x0e 9 0x00 0x02cf 0x001c 0x0000.000c5d98 0x00c038f5 0x0000.000.00000000 0x00000001 0x00000000 1387335334\r\n 0x0f 9 0x00 0x02cd 0x0004 0x0000.000c5887 0x00c038f3 0x0000.000.00000000 0x00000001 0x00000000 1387332632\r\n 0x10 9 0x00 0x02ce 0x0008 0x0000.000c579f 0x00c038f3 0x0000.000.00000000 0x00000001 0x00000000 1387332033\r\n 0x11 9 0x00 0x02cb 0x0021 0x0000.000c5d65 0x00c038f5 0x0000.000.00000000 0x00000001 0x00000000 1387335334\r\n 0x12 9 0x00 0x02cf 0x000e 0x0000.000c5d8d 0x00c038f5 0x0000.000.00000000 0x00000001 0x00000000 1387335334\r\n 0x13 9 0x00 0x02ce 0x000a 0x0000.000c5c90 0x00c038ed 0x0000.000.00000000 0x00000001 0x00000000 1387335128\r\n 0x14 9 0x00 0x02cd 0x0012 0x0000.000c5d83 0x00c038f5 0x0000.000.00000000 0x00000001 0x00000000 1387335334\r\n 0x15 9 0x00 0x02cb 0x000c 0x0000.000c58a2 0x00c038f3 0x0000.000.00000000 0x00000001 0x00000000 1387332632\r\n 0x16 9 0x00 0x02cd 0x001e 0x0000.000c58b4 0x00c038f3 0x0000.000.00000000 0x00000001 0x00000000 1387332632\r\n 0x17 9 0x00 0x02ce 0x0013 0x0000.000c5bf0 0x00c038f3 0x0000.000.00000000 0x00000001 0x00000000 1387334732\r\n 0x18 9 0x00 0x02cb 0x0000 0x0000.000c58c6 0x00c038f3 0x0000.000.00000000 0x00000001 0x00000000 1387332632\r\n 0x19 9 0x00 0x02ce 0x0014 0x0000.000c5d79 0x00c038f5 0x0000.000.00000000 0x00000001 0x00000000 1387335334\r\n 0x1a 9 0x00 0x02ce 0x0003 0x0000.000c5ddc 0x00c038f5 0x0000.000.00000000 0x00000001 0x00000000 1387335345\r\n 0x1b 9 0x00 0x02cc 0x0017 0x0000.000c5be6 0x00c038f3 0x0000.000.00000000 0x00000001 0x00000000 1387334732\r\n 0x1c 9 0x00 0x02cc 0x001a 0x0000.000c5dcd 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1387335345\r\n 0x1d 9 0x00 0x02cd 0x0005 0x0000.000c5d31 0x00c038f5 0x0000.000.00000000 0x00000001 0x00000000 1387335318\r\n 0x1e 9 0x00 0x02cb 0x0018 0x0000.000c58bd 0x00c038f3 0x0000.000.00000000 0x00000001 0x00000000 1387332632\r\n 0x1f 9 0x00 0x02cc 0x0020 0x0000.000c56ce 0x00c038f0 0x0000.000.00000000 0x00000001 0x00000000 1387331730\r\n 0x20 9 0x00 0x02cd 0x000b 0x0000.000c56f6 0x00c038f0 0x0000.000.00000000 0x00000001 0x00000000 1387331815\r\n 0x21 9 0x00 0x02cd 0x0019 0x0000.000c5d6f 0x00c038f5 0x0000.000.00000000 0x00000001 0x00000000 1387335334\r\n<\/pre>\n\u6ce8\uff1a9-inactive\t10-active<\/p>\n
\u4e0b\u8fb9\u4f7f\u7528bbed\u5c06\u4f1a\u8bdd2\u4e2d\u672a\u63d0\u4ea4\u4e8b\u52a1\u4ea7\u751f\u7684UNDO\u4eba\u4e3a\u635f\u574f<\/p>\n
\r\nBBED> set dba 3,14581\r\n DBA 0x00c038f5 (12597493 3,14581)\r\n\r\nBBED> find \/c yallonking\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/undotbs01.dbf (3)\r\n Block: 14581 Offsets: 3876 to 4387 Dba:0x00c038f5\r\n------------------------------------------------------------------------\r\n 79616c6c 6f6e6b69 6e671835 0c001800 20001400 03000600 25180000 25180000 \r\n 00000000 00000000 0a16031c 0000cf02 040d0000 00000000 04000800 b9020000 \r\n 5603c000 c1000500 00800000 f75d0c00 05020100 b8324000 b9324000 00000000 \r\n 00000709 02c15430 004032b1 00000200 12004c00 20003100 02000200 0e000200 \r\n 020006c5 24180000 24180000 00000000 00000000 0b010300 080c0100 00000000 \r\n f538c000 9e001a00 f7540c00 00000000 04550c00 00000000 00000000 f85d0c00 \r\n 0000a50e f038c000 00000000 00000000 040d0000 00000000 02000b00 d9020000 \r\n 9300c000 d5001700 00800000 f55d0c00 b1324000 b0324000 ff120201 01000000 \r\n 2c000597 00000000 f02a3c97 00000000 01000000 01000000 1e000000 00600000 \r\n a84b2a63 c1542100 c10480ea 53595324 4241434b 47524f55 4e44c102 c1020e1d \r\n c1026302 0a001800 20001400 120006c5 fc190000 fc190000 01000000 00000000 \r\n 0a161a1a 0000ce02 040d1400 4c002000 06001600 62030000 fc0ac000 ae003100 \r\n 00800000 d99c0b00 0302018d ca198000 cb198000 00000000 00000000 06c50214 \r\n 352c5c02 c1020778 710c120b 382f06c5 08004c00 20001400 fb190000 fb190000 \r\n 01000000 00000000 0b011a00 080c0100 00000000 f838c000 9e000100 eb540c00 \r\n 00000000 f7540c00 00000000 00000000 db5d0c00 00000000 f038c000 00000000 \r\n\r\n <32 bytes per line>\r\n\r\nBBED> dump \/v dba 3,14581 offset 3876 count 10\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/undotbs01.dbf (3)\r\n Block: 14581 Offsets: 3876 to 3885 Dba:0x00c038f5\r\n-------------------------------------------------------\r\n 79616c6c 6f6e6b69 6e67 l yallonking\r\n\r\n <16 bytes per line>\r\n \r\nBBED> p kcbh \r\nstruct kcbh, 20 bytes @0 \r\n ub1 type_kcbh @0 0x02\r\n ub1 frmt_kcbh @1 0xa2\r\n ub1 spare1_kcbh @2 0x00\r\n ub1 spare2_kcbh @3 0x00\r\n ub4 rdba_kcbh @4 0x00c038f5\r\n ub4 bas_kcbh @8 0x000c5e5e\r\n ub2 wrp_kcbh @12 0x0000\r\n ub1 seq_kcbh @14 0x01\r\n ub1 flg_kcbh @15 0x04 (KCBHFCKV)\r\n ub2 chkval_kcbh @16 0xdb3b\r\n ub2 spare3_kcbh @18 0x0000\r\n\r\nBBED> set mode edit\r\n MODE Edit\r\n\r\nBBED> modify \/x ff dba 3,14581 offset 14\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/undotbs01.dbf (3)\r\n Block: 14581 Offsets: 14 to 23 Dba:0x00c038f5\r\n------------------------------------------------------------------------\r\n ff043bdb 00000500 0900 \r\n\r\n <32 bytes per line>\r\n\r\nBBED> sum dba 3,14581 apply;\r\nCheck value for File 3, Block 14581:\r\ncurrent = 0xdbc5, required = 0xdbc5\r\n<\/pre>\n\u9a8c\u8bc1\u574f\u5757<\/p>\n
\r\nBBED> VERIFY dba 3,14581\r\nDBVERIFY - Verification starting\r\nFILE = \/u01\/app\/oracle\/oradata\/ora11gr2\/undotbs01.dbf\r\nBLOCK = 14581\r\n\r\nBlock 14581 is corrupt\r\nCorrupt block relative dba: 0x00c038f5 (file 0, block 14581)\r\nFractured block found during verification\r\nData in bad block:\r\n type: 2 format: 2 rdba: 0x00c038f5\r\n last change scn: 0x0000.000c5e5e seq: 0xff flg: 0x04\r\n spare1: 0x0 spare2: 0x0 spare3: 0x0\r\n consistency value in tail: 0x5e5e0201\r\n check value in block header: 0xdbc5\r\n computed block checksum: 0x0\r\n\r\n\r\nDBVERIFY - Verification complete\r\n\r\nTotal Blocks Examined : 1\r\nTotal Blocks Processed (Data) : 0\r\nTotal Blocks Failing (Data) : 0\r\nTotal Blocks Processed (Index): 0\r\nTotal Blocks Failing (Index): 0\r\nTotal Blocks Empty : 0\r\nTotal Blocks Marked Corrupt : 1\r\nTotal Blocks Influx : 2\r\nMessage 531 not found; product=RDBMS; facility=BBED\r\n\r\n[oracle@rhl6 ~]$ dbv file='\/u01\/app\/oracle\/oradata\/ora11gr2\/undotbs01.dbf'\r\n\r\nDBVERIFY: Release 11.2.0.3.0 - Production on Wed Dec 18 11:46:53 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates. All rights reserved.\r\n\r\nDBVERIFY - Verification starting : FILE = \/u01\/app\/oracle\/oradata\/ora11gr2\/undotbs01.dbf\r\nPage 14581 is influx - most likely media corrupt\r\nCorrupt block relative dba: 0x00c038f5 (file 3, block 14581)\r\nFractured block found during dbv: \r\nData in bad block:\r\n type: 2 format: 2 rdba: 0x00c038f5\r\n last change scn: 0x0000.000c5e5e seq: 0xff flg: 0x04\r\n spare1: 0x0 spare2: 0x0 spare3: 0x0\r\n consistency value in tail: 0x5e5e0201\r\n check value in block header: 0xdbc5\r\n computed block checksum: 0x0\r\n\r\n\r\n\r\nDBVERIFY - Verification complete\r\n\r\nTotal Pages Examined : 39680\r\nTotal Pages Processed (Data) : 0\r\nTotal Pages Failing (Data) : 0\r\nTotal Pages Processed (Index): 0\r\nTotal Pages Failing (Index): 0\r\nTotal Pages Processed (Other): 39678\r\nTotal Pages Processed (Seg) : 10\r\nTotal Pages Failing (Seg) : 0\r\nTotal Pages Empty : 1\r\nTotal Pages Marked Corrupt : 1\r\nTotal Pages Influx : 1\r\nTotal Pages Encrypted : 0\r\nHighest block SCN : 812058 (0.812058)\r\n<\/pre>\n\u67e5\u770b\u62a5\u9519\u4fe1\u606f<\/p>\n
\r\nSQL> select * from yallonking;\r\nselect * from yallonking\r\n *\r\nERROR at line 1:\r\nORA-01578: ORACLE data block corrupted (file # 3, block # 14581)\r\nORA-01110: data file 3: '\/u01\/app\/oracle\/oradata\/ora11gr2\/undotbs01.dbf'\r\n<\/pre>\nALERT\u65e5\u5fd7\u4e2d\u62a5\u9519\uff1a(\u622a\u53d6\u90e8\u5206)<\/p>\n
\r\nORACLE Instance ora11gr2 (pid = 13) - Error 600 encountered while recovering transaction (5, 9).\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_smon_14261.trc:\r\nORA-00600: internal error code, arguments: [KSLFDNG2], [0x097892340], [0], [0x0968BBCD0], [0x000000000], [], [], [], [], [], [], []\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_mmon_14265.trc (incident=8554):\r\nORA-01578: ORACLE data block corrupted (file # 3, block # 14581)\r\nORA-01110: data file 3: '\/u01\/app\/oracle\/oradata\/ora11gr2\/undotbs01.dbf'\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_mmon_14265.trc (incident=9635):\r\nORA-01578: ORACLE data block corrupted (file # 3, block # 14581)\r\nORA-01110: data file 3: '\/u01\/app\/oracle\/oradata\/ora11gr2\/undotbs01.dbf'\r\nminact-scn: got error during useg scan e:1578 usn:5\r\nminact-scn: useg scan erroring out with error e:1578\r\nInstance terminated by PMON, pid = 14236\r\n<\/pre>\n\u968f\u540e\u6570\u636e\u5e93down\u6389<\/p>\n
\u4fee\u590d
\n\u5c1d\u8bd5_offline_rollback_segments\u548c_corrupted_rollback_segments\u6765\u8df3\u8fc7\u574f\u5757\uff0c\u5747\u5931\u8d25
\n\u4e0b\u8fb9\u7528bbed\u4fee\u6539\u56de\u539f\u6765\u72b6\u6001<\/p>\n\r\nBBED> set dba 1,512\r\n DBA 0x00400200 (4194816 1,512)\r\n\r\nBBED> p kcbh\r\nstruct kcbh, 20 bytes @0 \r\n ub1 type_kcbh @0 0x10\r\n ub1 frmt_kcbh @1 0xa2\r\n ub1 spare1_kcbh @2 0x00\r\n ub1 spare2_kcbh @3 0x00\r\n ub4 rdba_kcbh @4 0x00400200\r\n ub4 bas_kcbh @8 0x000add35\r\n ub2 wrp_kcbh @12 0x0000\r\n ub1 seq_kcbh @14 0x01\r\n ub1 flg_kcbh @15 0x04 (KCBHFCKV)\r\n ub2 chkval_kcbh @16 0xd217\r\n ub2 spare3_kcbh @18 0x0000\r\n\r\nBBED> set dba 3,14581\r\n DBA 0x00c038f5 (12597493 3,14581)\r\n\r\nBBED> p kcbh\r\nstruct kcbh, 20 bytes @0 \r\n ub1 type_kcbh @0 0x02\r\n ub1 frmt_kcbh @1 0xa2\r\n ub1 spare1_kcbh @2 0x00\r\n ub1 spare2_kcbh @3 0x00\r\n ub4 rdba_kcbh @4 0x00c038f5\r\n ub4 bas_kcbh @8 0x000c5e5e\r\n ub2 wrp_kcbh @12 0x0000\r\n ub1 seq_kcbh @14 0xff\r\n ub1 flg_kcbh @15 0x04 (KCBHFCKV)\r\n ub2 chkval_kcbh @16 0xdbc5\r\n ub2 spare3_kcbh @18 0x0000\r\n \r\nBBED> set mode edit\r\n MODE Edit\r\n\r\nBBED> modify \/x 01 dba 3,14581 offset 14\r\nWarning: contents of previous BIFILE will be lost. Proceed? (Y\/N) y\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/undotbs01.dbf (3)\r\n Block: 14581 Offsets: 14 to 525 Dba:0x00c038f5\r\n------------------------------------------------------------------------\r\n 0104c5db 00000500 0900c902 00009e00 1e1e0000 e81fac1f 081fc01e 901e501e \r\n 2c1e9c1c 701bb01a 001a3c19 d0187418 c0176417 08178016 20165415 a4142814 \r\n 7813cc12 1c124811 c0105410 800f1c0f 8c0e0500 1e00c402 0000f238 c0009b00 \r\n 03000100 00000000 00000500 0100c802 0000f438 c0009b00 06008c00 00000000 \r\n 00000e00 000077ea 80000224 80000001 85050100 0000f000 04020602 02000000 \r\n 00000000 000076ea 80000600 0000601f 0000411f 551c741c 931cb21c d11cf11c \r\n 111d311d 511d701d 8f1dae1d cd1dec1d 0b1e2a1e 491e681e 871ea61e c51ee41e \r\n 031f221f 25134413 63138313 a313c313 e3130314 23144314 62148114 a014bf14 \r\n df14ff14 1f153e15 5d157c15 9b15ba15 d915f915 19163916 59167916 9816b716 \r\n d616f516 14173317 52177217 9117b017 cf17ee17 0d182d18 4d186d18 8d18ac18 \r\n cb18ea18 09192819 47196619 8519a419 c319e319 031a231a 421a611a 801a9f1a \r\n be1add1a fc1a1c1b 3c1b5d1b 7c1b9b1b ba1bd91b f81b171c 361c0602 24024202 \r\n 60027f02 9d02bb02 d902f802 17033603 55037403 9303b203 d103f003 0f042f04 \r\n 4f046f04 8e04ad04 cc04eb04 0a052905 48056705 8605a505 c405e305 02062106 \r\n 40065f06 7e069d06 bc06db06 fa061a07 3a075907 79079807 b707d607 f5071408 \r\n 33085208 72089208 b108d008 ef080e09 2e094d09 6d098d09 ad09cd09 ec090b0a \r\n\r\n <32 bytes per line>\r\n\r\nBBED> p kcbh\r\nstruct kcbh, 20 bytes @0 \r\n ub1 type_kcbh @0 0x02\r\n ub1 frmt_kcbh @1 0xa2\r\n ub1 spare1_kcbh @2 0x00\r\n ub1 spare2_kcbh @3 0x00\r\n ub4 rdba_kcbh @4 0x00c038f5\r\n ub4 bas_kcbh @8 0x000c5e5e\r\n ub2 wrp_kcbh @12 0x0000\r\n ub1 seq_kcbh @14 0x01\r\n ub1 flg_kcbh @15 0x04 (KCBHFCKV)\r\n ub2 chkval_kcbh @16 0xdbc5\r\n ub2 spare3_kcbh @18 0x0000\r\n\r\nBBED> sum dba 3,14581 apply;\r\nCheck value for File 3, Block 14581:\r\ncurrent = 0xdb3b, required = 0xdb3b\r\n\r\nBBED> VERIFY dba 3,14581\r\nDBVERIFY - Verification starting\r\nFILE = \/u01\/app\/oracle\/oradata\/ora11gr2\/undotbs01.dbf\r\nBLOCK = 14581\r\n\r\n\r\nDBVERIFY - Verification complete\r\n\r\nTotal Blocks Examined : 1\r\nTotal Blocks Processed (Data) : 0\r\nTotal Blocks Failing (Data) : 0\r\nTotal Blocks Processed (Index): 0\r\nTotal Blocks Failing (Index): 0\r\nTotal Blocks Empty : 0\r\nTotal Blocks Marked Corrupt : 0\r\nTotal Blocks Influx : 0\r\nMessage 531 not found; product=RDBMS; facility=BBED\r\n\r\n \r\nSQL> startup\r\nORACLE instance started.\r\n\r\nTotal System Global Area 939495424 bytes\r\nFixed Size 2233960 bytes\r\nVariable Size 549456280 bytes\r\nDatabase Buffers 381681664 bytes\r\nRedo Buffers 6123520 bytes\r\nDatabase mounted.\r\nDatabase opened.\r\nSQL> col NAME for a30\r\nSQL> select * from yallonking.yallonking;\r\n\r\n ID NAME\r\n---------- ------------------------------\r\n 1 yallonking \r\n \r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"\u8be5\u7bc7\u6587\u7ae0\u6a21\u62df\u7528\u6237\u6d3b\u52a8\u4e8b\u7269\u4e0a\u7684UNDO\u5757\u635f\u574f\u6062\u590d \u6570\u636e\u5e93\u7248\u672c SQL> select * from gv$ […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[36],"tags":[249,248,247,124,227],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1166"}],"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=1166"}],"version-history":[{"count":1,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1166\/revisions"}],"predecessor-version":[{"id":1167,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1166\/revisions\/1167"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1166"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}