{"id":1008,"date":"2013-07-21T17:04:48","date_gmt":"2013-07-21T09:04:48","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=1008"},"modified":"2013-07-23T12:29:50","modified_gmt":"2013-07-23T04:29:50","slug":"%e4%bd%bf%e7%94%a8bbed%e6%81%a2%e5%a4%8dcorrupt%e7%9a%84%e5%9d%97%e5%92%8c10231%e7%9a%84%e5%af%b9%e6%af%94","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=1008","title":{"rendered":"\u4f7f\u7528bbed\u6062\u590dcorrupt\u7684\u5757\u548c10231\u7684\u5bf9\u6bd4"},"content":{"rendered":"

\u5f53\u6211\u4eec\u67e5\u8be2\u4e00\u5f20\u8868\u7684\u65f6\u5019\uff0c\u5728\u626b\u63cf\u5230\u67d0\u4e9b\u8bb0\u5f55\u65f6\uff0c\u8be5\u8bb0\u5f55\u7684\u6570\u636e\u5757\u5df2\u7ecfcorruption\uff0c\u90a3\u4e48\u6211\u4eec\u53ef\u4ee5\u752810231\u4e8b\u4ef6\u8df3\u8fc7\u8be5\u574f\u5757\u8bfb\u53d6\u5176\u4ed6\u6570\u636e\u3002
\n\u6b64\u5904\u6211\u4f7f\u7528bbed\u6062\u590d\u8be5corruption\u7684\u5757\u3002\u5e76\u8bfb\u53d6\u5176\u4e2d\u7684\u6570\u636e\u3002
\n\u53c2\u8003\u6587\u6863\uff1adisassembling the oracle data block,writter by graham thornton 2005<\/p>\n

\u64cd\u4f5c\u7cfb\u7edf\u4fe1\u606f<\/p>\n

\r\n[oracle@rhl6 lib]$ uname -a\r\nLinux rhl6.0x64 2.6.32-71.el6.x86_64 #1 SMP Wed Sep 1 01:33:01 EDT 2010 x86_64 x86_64 x86_64 GNU\/Linux\r\n<\/pre>\n
\u6570\u636e\u5e93\u7248\u672c<\/p>\n
\r\nSQL> set line 400  \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
\u6d4b\u8bd5\u6570\u636e<\/p>\n
\r\nSQL> sho user\r\nUSER is "YALLONKING"\r\nSQL> alter session set nls_date_format='yyyy\/mm\/dd hh24:mi:ss';\r\n\r\nSession altered.\r\n\r\nSQL> select rowid,t.* from yallonking t;\r\n\r\nROWID                      ID NAME                 MY_DATE\r\n------------------ ---------- -------------------- -------------------\r\nAAARciAAFAAAACHAAA          1 yallonking           2013\/07\/22 09:44:53\r\nAAARciAAFAAAACHAAB          2 oraking              2013\/07\/22 09:45:07\r\nAAARciAAFAAAACHAAC          3 xiaolong             2013\/07\/22 09:50:09\r\n<\/pre>\n
\u4e0b\u8fb9\u6211\u4eec\u63d2\u5165\u5927\u91cf\u6570\u636e\uff0c\u4e3a\u4e86\u8ba9\u8be5\u8868\u7684\u6570\u636e\u5728\u4e0d\u540c\u7684\u5757\u4e2d<\/p>\n
\r\nSQL> insert into yallonking select rownum as id,'travel' as name,sysdate as mydate from dual connect by rownum<10000;\r\n\r\n9999 rows created.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL> select rowid,t.* from yallonking t where id=9999;\r\n\r\nROWID                      ID NAME                 MY_DATE\r\n------------------ ---------- -------------------- -------------------\r\nAAARciAAFAAAACkAAf       9999 travel               2013\/07\/23 10:33:53\r\n\r\nSQL> conn \/as sysdba\r\nConnected.\r\nSQL> select get_rowid('AAARciAAFAAAACHAAA') from dual;\r\n\r\nGET_ROWID('AAARCIAAFAAAACHAAA')\r\n--------------------------------------------------------------------------------\r\nRow_id type is  :1\r\nObject# is      :71458\r\nRelative_fno is :5\r\nBlock number is :135\r\nRow number is   :0\r\n\r\nSQL> select get_rowid('AAARciAAFAAAACkAAf') from dual;\r\n\r\nGET_ROWID('AAARCIAAFAAAACKAAF')\r\n--------------------------------------------------------------------------------\r\nRow_id type is  :1\r\nObject# is      :71458\r\nRelative_fno is :5\r\nBlock number is :164\r\nRow number is   :31\r\n\r\nSQL> select \/*+ full(t) *\/ count(*) from yallonking.yallonking t;\r\n\r\n  COUNT(*)\r\n----------\r\n     10002\r\n<\/pre>\n
\u9996\u5148\u6211\u4eec\u4f7f\u7528bbed\u628a\u7b2c\u4e09\u884c\u8bb0\u5f55\u6240\u5728\u7684\u5757\u6807\u8bb0\u4e3acorruption\uff0c\u4e5f\u5c31\u662f\u5c06135\u53f7\u5757\u4eba\u4e3a\u635f\u574f<\/p>\n
\r\nBBED> show all\r\n        FILE#           1\r\n        BLOCK#          1\r\n        OFFSET          0\r\n        DBA             0x00400001 (4194305 1,1)\r\n        FILENAME        \/u01\/app\/oracle\/oradata\/ora11gr2\/system01.dbf\r\n        BIFILE          bifile.bbd\r\n        LISTFILE        \/home\/oracle\/bbedfile.lst\r\n        BLOCKSIZE       8192\r\n        MODE            Edit\r\n        EDIT            Unrecoverable\r\n        IBASE           Dec\r\n        OBASE           Dec\r\n        WIDTH           80\r\n        COUNT           512\r\n        LOGFILE         log.bbd\r\n        SPOOL           No\r\n\r\nBBED> info all\r\n File#  Name                                                        Size(blks)\r\n -----  ----                                                        ----------\r\n     1  \/u01\/app\/oracle\/oradata\/ora11gr2\/system01.dbf                    89600\r\n     2  \/u01\/app\/oracle\/oradata\/ora11gr2\/sysaux01.dbf                    76800\r\n     3  \/u01\/app\/oracle\/oradata\/ora11gr2\/undotbs01.dbf                   39680\r\n     4  \/u01\/app\/oracle\/oradata\/ora11gr2\/users01.dbf                       640\r\n     5  \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf                  256\r\n\r\nBBED> set dba 5,135\r\n        DBA             0x01400087 (20971655 5,135)\r\n\r\nBBED> p kcbh\r\nstruct kcbh, 20 bytes                       @0       \r\n   ub1 type_kcbh                            @0        0x06\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        0x01400087\r\n   ub4 bas_kcbh                             @8        0x000b9935\r\n   ub2 wrp_kcbh                             @12       0x0000\r\n   ub1 seq_kcbh                             @14       0x01\r\n   ub1 flg_kcbh                             @15       0x06 (KCBHFDLC, KCBHFCKV)\r\n   ub2 chkval_kcbh                          @16       0xf127\r\n   ub2 spare3_kcbh                          @18       0x0000\r\n   \r\nBBED> modify \/x ff dba 5,135 offset 14                        \r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135              Offsets:   14 to  525           Dba:0x01400087\r\n------------------------------------------------------------------------\r\n ff060659 00000100 00002217 0100e19c 0b000000 000002f8 32008000 40010500 \r\n 1500a902 00002c34 c0009700 25000080 00003599 0b000200 0d00b602 00003403 \r\n c000b300 06002f21 0000e79c 0b000000 00000000 00000001 3201ffff 7602ae05 \r\n 38033803 00003201 7f1f691f 521fcd09 e209f709 0c0a210a 360a4b0a 600a750a \r\n 8a0a9f0a b40ac90a de0af30a 080b1d0b 320b470b 5c0b710b 860b9b0b b00bc50b \r\n da0bef0b 040c190c 2e0c430c 580c6d0c 820c970c ac0cc10c d60ceb0c 000d150d \r\n 2a0d3f0d 540d690d 7e0d930d a80dbd0d d20de70d fc0d110e 260e3b0e 500e650e \r\n 7a0e8f0e a40eb90e ce0ee30e f80e0d0f 220f370f 4c0f610f 760f8b0f a00fb50f \r\n ca0fdf0f f40f0910 1e103310 48105d10 72108710 9c10b110 c610db10 f0100511 \r\n 1a112f11 44115911 6e118311 9811ad11 c211d711 ec110112 17122d12 43125912 \r\n 6f128512 9b12b112 c712dd12 f3120913 1f133513 4b136113 77138d13 a313b913 \r\n cf13e513 fb131114 27143d14 53146914 7f149514 ab14c114 d714ed14 03151915 \r\n 2f154515 5b157115 87159d15 b315c915 df15f515 0b162116 37164d16 63167916 \r\n 8f16a516 bb16d116 e716fd16 13172917 3f175517 6b178117 9717ad17 c317d917 \r\n ef170518 1b183118 47185d18 73188918 9f18b518 cb18e118 f7180d19 23193919 \r\n 4f196519 7b199119 a719bd19 d319e919 ff19151a 2b1a411a 571a6d1a 831a981a \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        0x06\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        0x01400087\r\n   ub4 bas_kcbh                             @8        0x000b9ce7\r\n   ub2 wrp_kcbh                             @12       0x0000\r\n   ub1 seq_kcbh                             @14       0xff\r\n   ub1 flg_kcbh                             @15       0x06 (KCBHFDLC, KCBHFCKV)\r\n   ub2 chkval_kcbh                          @16       0x5906\r\n   ub2 spare3_kcbh                          @18       0x0000\r\n\r\nBBED> sum dba 5,135 apply;\r\nCheck value for File 5, Block 135:\r\ncurrent = 0x59f8, required = 0x59f8\r\n<\/pre>\n
\u4e0b\u8fb9\u6211\u4eec\u5c1d\u8bd5\u67e5\u770b\u8be5\u8868\u7684\u8bb0\u5f55<\/p>\n
\r\nSQL> alter system flush buffer_cache;\r\n\r\nSystem altered.\r\n\r\nSQL> select \/*+ full(t) *\/ count(*) from yallonking t;\r\nselect \/*+ full(t) *\/ count(*) from yallonking t\r\n                                    *\r\nERROR at line 1:\r\nORA-01578: ORACLE data block corrupted (file # 5, block # 135)\r\nORA-01110: data file 5: '\/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf'\r\n<\/pre>\n
\u6b64\u65f6\uff0c\u6211\u4eec\u770b\u5230\u7531\u4e8e\u4e00\u4e2a\u5757\u7684\u95ee\u9898\u5bfc\u81f4\u6574\u4e2a\u8868\u65e0\u6cd5\u8bbf\u95ee<\/p>\n
\u4e0b\u8fb9\u6211\u4eec\u5c1d\u8bd5\u8bbe\u7f6e10231\u4e8b\u4ef6\u8df3\u8fc7\u8be5\u95ee\u9898\u5757\uff0c\u5c1d\u8bd5\u8ffd\u56de\u90e8\u5206\u6570\u636e<\/p>\n
\r\nSQL> alter system set events '10231 trace name context forever,level 10';\r\n\r\nSystem altered.\r\n\r\nSQL> select \/*+ full(t) *\/ count(*) from yallonking t;\r\n\r\n  COUNT(*)\r\n----------\r\n      9696\r\n\r\nSQL> select 10002-9696 from dual;\r\n\r\n10002-9696\r\n----------\r\n       306\r\n\r\nSQL> alter system set events '10231 trace name context  off';\r\n\r\nSystem altered.\r\n\r\nSQL> select \/*+ full(t) *\/ count(*) from yallonking t;\r\nselect \/*+ full(t) *\/ count(*) from yallonking t\r\n                                    *\r\nERROR at line 1:\r\nORA-01578: ORACLE data block corrupted (file # 5, block # 135)\r\nORA-01110: data file 5: '\/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf'\r\n<\/pre>\n
\u6ce8\uff1a\u4ee5\u4e0a\u6211\u4eec\u4f7f\u752810231\u4e8b\u4ef6\u53ef\u4ee5\u8df3\u8fc7\u574f\u5757\u8bfb\u53d6\u5176\u4ed6\u5757\u4e0a\u7684\u8bb0\u5f55\uff0c\u4f46\u662f\u6211\u4eec\u4f1a\u4e22\u5931\u90e8\u5206\u6570\u636e\uff08\u6b64\u5904\u4e3a306\u6761\u8bb0\u5f55\uff09\u3002<\/p>\n
\u4e0b\u8fb9\u6211\u4eec\u4f7f\u7528bbed\u4fee\u590d\u95ee\u9898\u7684\u6570\u636e\u5757\uff08\u5f53\u7136\u548c\u4e4b\u524d\u4eba\u4e3a\u635f\u574f\u7684\u8fc7\u7a0b\u7c7b\u4f3c\uff09<\/p>\n
\r\nBBED> p kcbh\r\nstruct kcbh, 20 bytes                       @0       \r\n   ub1 type_kcbh                            @0        0x06\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        0x01400087\r\n   ub4 bas_kcbh                             @8        0x000b9ce7\r\n   ub2 wrp_kcbh                             @12       0x0000\r\n   ub1 seq_kcbh                             @14       0xff\r\n   ub1 flg_kcbh                             @15       0x06 (KCBHFDLC, KCBHFCKV)\r\n   ub2 chkval_kcbh                          @16       0x59f8\r\n   ub2 spare3_kcbh                          @18       0x0000\r\n\r\nBBED> m \/x 01 dba 5,135 offset 14\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135              Offsets:   14 to  525           Dba:0x01400087\r\n------------------------------------------------------------------------\r\n 0106f859 00000100 00002217 0100e19c 0b000000 000002f8 32008000 40010500 \r\n 1500a902 00002c34 c0009700 25000080 00003599 0b000200 0d00b602 00003403 \r\n c000b300 06002f21 0000e79c 0b000000 00000000 00000001 3201ffff 7602ae05 \r\n 38033803 00003201 7f1f691f 521fcd09 e209f709 0c0a210a 360a4b0a 600a750a \r\n 8a0a9f0a b40ac90a de0af30a 080b1d0b 320b470b 5c0b710b 860b9b0b b00bc50b \r\n da0bef0b 040c190c 2e0c430c 580c6d0c 820c970c ac0cc10c d60ceb0c 000d150d \r\n 2a0d3f0d 540d690d 7e0d930d a80dbd0d d20de70d fc0d110e 260e3b0e 500e650e \r\n 7a0e8f0e a40eb90e ce0ee30e f80e0d0f 220f370f 4c0f610f 760f8b0f a00fb50f \r\n ca0fdf0f f40f0910 1e103310 48105d10 72108710 9c10b110 c610db10 f0100511 \r\n 1a112f11 44115911 6e118311 9811ad11 c211d711 ec110112 17122d12 43125912 \r\n 6f128512 9b12b112 c712dd12 f3120913 1f133513 4b136113 77138d13 a313b913 \r\n cf13e513 fb131114 27143d14 53146914 7f149514 ab14c114 d714ed14 03151915 \r\n 2f154515 5b157115 87159d15 b315c915 df15f515 0b162116 37164d16 63167916 \r\n 8f16a516 bb16d116 e716fd16 13172917 3f175517 6b178117 9717ad17 c317d917 \r\n ef170518 1b183118 47185d18 73188918 9f18b518 cb18e118 f7180d19 23193919 \r\n 4f196519 7b199119 a719bd19 d319e919 ff19151a 2b1a411a 571a6d1a 831a981a \r\n\r\n <32 bytes per line>\r\n<\/pre>\n
\u6ce8\uff1a\u8fd9\u91cc\u4f4d\u4e8eoffest\u4e3a14\u7684\u53c2\u6570 seq_kcbh \u4e3a control file sequence number\uff0c\u6211\u4eec\u8fd9\u91cc\u662f\u5c06\u5176\u6539\u4e3a\u539f\u6765\u768401
\n\u5728\u540e\u8fb9\u7684\u5b9e\u9a8c\u4e2d\uff0c\u6211\u4eec\u5c06\u6d4b\u8bd5\u8be5\u503c\u6539\u4e3a\u5176\u4ed6\u975e0xff\u503c<\/p>\n
\r\nBBED> p kcbh\r\nstruct kcbh, 20 bytes                       @0       \r\n   ub1 type_kcbh                            @0        0x06\t\t\/\/\u5757\u7c7b\u578b\r\n   ub1 frmt_kcbh                            @1        0xa2\t\t\/\/\u5757\u683c\u5f0f\r\n   ub1 spare1_kcbh                          @2        0x00\t\t\r\n   ub1 spare2_kcbh                          @3        0x00\r\n   ub4 rdba_kcbh                            @4        0x01400087\t\/\/\u5757rdba\r\n   ub4 bas_kcbh                             @8        0x000b9ce7\t\/\/SCN base\r\n   ub2 wrp_kcbh                             @12       0x0000\t\t\/\/SCN wrap\r\n   ub1 seq_kcbh                             @14       0x01\t\t\t\/\/SCN sequence number\r\n   ub1 flg_kcbh                             @15       0x06 (KCBHFDLC, KCBHFCKV)\r\n   ub2 chkval_kcbh                          @16       0x59f8\r\n   ub2 spare3_kcbh                          @18       0x0000\r\n\r\nBBED> sum dba 5,132 apply\r\nCheck value for File 5, Block 132:\r\ncurrent = 0xcc08, required = 0xcc08\r\n\r\nBBED> sum dba 5,135\r\nCheck value for File 5, Block 135:\r\ncurrent = 0x59f8, required = 0x5906\r\n<\/pre>\n
\u90e8\u5206\u53c2\u6570\u63cf\u8ff0\u89c1\u4e0b\u56fe
\n\"bbed_map_output\"<\/a><\/p>\n
\u67e5\u770b\u5757\u7684tailchk
\n\u5173\u4e8etailchk\u7684\u8bf4\u660e\u5982\u4e0b
\ntailchk=lower order two bytes of the SCN base||block type||SCN sequence number<\/strong>
\n\u4e0b\u8fb9\u6211\u4eec\u67e5\u627e\u8be5\u5757\u4ee5\u4e0a\u8fd9\u4e09\u4e2a\u503c<\/p>\n
\r\nBBED> d \/v dba 5,135 offset 0 count 64\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135     Offsets:    0 to   63  Dba:0x01400087\r\n-------------------------------------------------------\r\n 06a20000 87004001 e79c0b00 00000106 l .\uffe0....@.?.......\r\n f8590000 01000000 22170100 e19c0b00 l ?Y......"...\u00e1...\r\n 00000000 02f83200 80004001 05001500 l .....?2...@.....\r\n a9020000 2c34c000 97002500 00800000 l ?...,4\u00e0...%.....\r\n\r\n <16 bytes per line>\r\n\r\ntype    format    unused    rdba        scn base    scn wrap    seq    flag\t \r\n06      a2        0000      87004001    e79c0b00    0000        01     06\r\n\r\n\u6240\u4ee5\uff0c\u8be5\u5757\u7684tailchk\u5e94\u8be5\u4e3a\uff1a(000b)9ce7||06||01,\u4e5f\u5c31\u662f 9ce70601\r\n<\/pre>\n
\u4e0b\u8fb9\u67e5\u770b\u8be5\u5757\u5f53\u524d\u7684tailchk\u503c<\/p>\n
\r\nBBED> p tailchk \r\nub4 tailchk                                 @8188     0x9ce70601\r\n\r\nBBED> d \/v dba 5,135 offset 8188\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135     Offsets: 8188 to 8191  Dba:0x01400087\r\n-------------------------------------------------------\r\n 0106e79c                            l ..?.\r\n\r\n <16 bytes per line>\r\n<\/pre>\n
\u6ce8\uff1a\u7531\u4e8e\u4e4b\u524d\u7684\u4eba\u4e3a\u505a\u7684\u4fee\u6539\uff0c\u6240\u4ee5\u8be5\u5904\u6b64\u65f6\u4e0d\u9700\u8981\u505a\u5176\u4ed6\u64cd\u4f5c\u3002<\/p>\n
\u9a8c\u8bc1\u8be5\u5757<\/p>\n
\r\nBBED> v dba 5,135\r\nDBVERIFY - Verification starting\r\nFILE = \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf\r\nBLOCK = 135\r\n\r\nBlock 135 is corrupt\r\nCorrupt block relative dba: 0x01400087 (file 0, block 135)\r\nBad check value found during verification\r\nData in bad block:\r\n type: 6 format: 2 rdba: 0x01400087\r\n last change scn: 0x0000.000b9ce7 seq: 0x1 flg: 0x06\r\n spare1: 0x0 spare2: 0x0 spare3: 0x0\r\n consistency value in tail: 0x9ce70601\r\n check value in block header: 0x59f8\r\n computed block checksum: 0xfe\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           : 0\r\nMessage 531 not found;  product=RDBMS; facility=BBED\r\n<\/pre>\n
\u6ce8\uff1a\u6bd4\u8f83\u5947\u602a\u7684\u662f\uff0c\u8be5\u5904\u53d1\u73b0\u8be5\u5757\u4f9d\u7136\u662fCorrupt\uff0c\u671f\u95f4\u4ec0\u4e48\u4fee\u6539\u64cd\u4f5c\u4e5f\u6ca1\u6709\u505a\uff0c\u5728\u5c06\u6570\u636e\u5e93\u91cd\u542f\u540e\u4fbf\u597d\u3002<\/p>\n
\u67e5\u770b\u6570\u636e<\/p>\n
\r\nSQL> alter system flush buffer_cache;\r\n\r\nSystem altered.\r\n\r\nSQL> select \/*+ full(t) *\/ count(*) from yallonking t;\r\n\r\n  COUNT(*)\r\n----------\r\n     10002\r\n<\/pre>\n
\u6ce8\uff1a\u901a\u8fc7\u8fd9\u79cd\u65b9\u5f0f\uff0c\u6211\u4eec\u53ef\u4ee5\u627e\u56de\u6240\u6709\u6570\u636e\uff0c\u800c\u4e0d\u662f\u90e8\u5206\u6570\u636e<\/p>\n
==============================================================================
\n\u4e0b\u8fb9\u6211\u4eec\u7ee7\u7eed\u8bd5\u9a8c\uff0c\u770b\u80fd\u5426\u5c06\u4e00\u4e2a\u5bf9\u8c61\u7684\u4e0d\u540c\u5757\u7684seq_kcbh\u6539\u4e3a\u4e0d\u540c\u503c<\/p>\n
\r\nBBED> m \/x 05 dba 5,135 offset 14\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135              Offsets:   14 to   77           Dba:0x01400087\r\n------------------------------------------------------------------------\r\n 05060659 00000100 00002217 0100e19c 0b000000 000002f8 32008000 40010500 \r\n 1500a902 00002c34 c0009700 25000080 00003599 0b000200 0d00b602 00003403 \r\n\r\n <32 bytes per line>\r\n\r\nBBED> sum apply;\r\nCheck value for File 5, Block 135:\r\ncurrent = 0x590a, required = 0x590a\r\n\r\nSQL> alter system flush buffer_cache;\r\n\r\nSystem altered.\r\n\r\nSQL> select \/*+ full(t) *\/ count(*) from yallonking t;\r\nselect \/*+ full(t) *\/ count(*) from yallonking t\r\n*\r\nERROR at line 1:\r\nORA-01578: ORACLE data block corrupted (file # 5, block # 135)\r\nORA-01110: data file 5: '\/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf'\r\n\r\nBBED> v\r\nDBVERIFY - Verification starting\r\nFILE = \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf\r\nBLOCK = 135\r\n\r\nBlock 135 is corrupt\r\nCorrupt block relative dba: 0x01400087 (file 0, block 135)\r\nFractured block found during verification\r\nData in bad block:\r\n type: 6 format: 2 rdba: 0x01400087\r\n last change scn: 0x0000.000b9ce7 seq: 0x5 flg: 0x06\r\n spare1: 0x0 spare2: 0x0 spare3: 0x0\r\n consistency value in tail: 0x9ce70609\r\n check value in block header: 0x590a\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\r\nBBED> p ckbh\r\nBBED-00207: invalid offset specifier (ckbh)\r\n\r\n\r\nBBED> p kcbh\r\nstruct kcbh, 20 bytes                       @0       \r\n   ub1 type_kcbh                            @0        0x06\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        0x01400087\r\n   ub4 bas_kcbh                             @8        0x000b9ce7\r\n   ub2 wrp_kcbh                             @12       0x0000\r\n   ub1 seq_kcbh                             @14       0x05\r\n   ub1 flg_kcbh                             @15       0x06 (KCBHFDLC, KCBHFCKV)\r\n   ub2 chkval_kcbh                          @16       0x590a\r\n   ub2 spare3_kcbh                          @18       0x0000\r\n\r\nBBED> p tailchk\r\nub4 tailchk                                 @8188     0x9ce70609\r\n\r\nBBED> m \/x 05 dba 5,135 offset 8188\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135              Offsets: 8188 to 8191           Dba:0x01400087\r\n------------------------------------------------------------------------\r\n 0506e79c \r\n\r\n <32 bytes per line>\r\n\r\nBBED> sum apply\r\nCheck value for File 5, Block 135:\r\ncurrent = 0x5906, required = 0x5906\r\n\r\nBBED> v\r\nDBVERIFY - Verification starting\r\nFILE = \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf\r\nBLOCK = 135\r\n\r\n\r\nDBVERIFY - Verification complete\r\n\r\nTotal Blocks Examined         : 1\r\nTotal Blocks Processed (Data) : 1\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\nSQL> alter system flush buffer_cache;\r\n\r\nSystem altered.\r\n\r\nSQL> select \/*+ full(t) *\/ count(*) from yallonking t;\r\n\r\n  COUNT(*)\r\n----------\r\n     10002\r\n<\/pre>\n
\u6211\u4eec\u7ee7\u7eed\u5c1d\u8bd5\u628a seq_kcbh \u503c\u6539\u4e3a ff <\/p>\n
\r\nBBED> m \/x ff dba 5,135 offset 14\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135              Offsets:   14 to   77           Dba:0x01400087\r\n------------------------------------------------------------------------\r\n ff060659 00000100 00002217 0100e19c 0b000000 000002f8 32008000 40010500 \r\n 1500a902 00002c34 c0009700 25000080 00003599 0b000200 0d00b602 00003403 \r\n\r\n <32 bytes per line>\r\n\r\nBBED> sum \r\nCheck value for File 5, Block 135:\r\ncurrent = 0x5906, required = 0x59fc\r\n\r\nBBED> v\r\nDBVERIFY - Verification starting\r\nFILE = \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf\r\nBLOCK = 135\r\n\r\nBlock 135 is corrupt\r\nCorrupt block relative dba: 0x01400087 (file 0, block 135)\r\nFractured block found during verification\r\nData in bad block:\r\n type: 6 format: 2 rdba: 0x01400087\r\n last change scn: 0x0000.000b9ce7 seq: 0xff flg: 0x06\r\n spare1: 0x0 spare2: 0x0 spare3: 0x0\r\n consistency value in tail: 0x9ce70605\r\n check value in block header: 0x5906\r\n computed block checksum: 0xfa\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\r\nBBED> m \/x ff dba 5,135 offset 8188\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135              Offsets: 8188 to 8191           Dba:0x01400087\r\n------------------------------------------------------------------------\r\n ff06e79c \r\n\r\n <32 bytes per line>\r\n\r\nBBED> sum\r\nCheck value for File 5, Block 135:\r\ncurrent = 0x5906, required = 0x5906\r\n\r\nBBED> v\r\nDBVERIFY - Verification starting\r\nFILE = \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf\r\nBLOCK = 135\r\n\r\nBlock Checking: DBA = 20971655, Block Type = KTB-managed data block\r\nFound block already marked corrupted\r\n\r\nDBVERIFY - Verification complete\r\n\r\nTotal Blocks Examined         : 1\r\nTotal Blocks Processed (Data) : 1\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\t\r\n<\/pre>\n
\u6ce8\uff1a\u6b64\u5904\u867d\u7136\u6821\u9a8c\u901a\u8fc7\uff0c\u4f46\u662f\u5728\u67e5\u8be2\u4e2d\u8fd8\u662f\u6709\u95ee\u9898<\/p>\n
\r\nSQL> alter system flush buffer_cache;\r\n\r\nSystem altered.\r\n\r\nSQL> select \/*+ full(t) *\/ count(*) from yallonking t;\r\nselect \/*+ full(t) *\/ count(*) from yallonking t\r\n*\r\nERROR at line 1:\r\nORA-01578: ORACLE data block corrupted (file # 5, block # 135)\r\nORA-01110: data file 5: '\/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf'\r\n<\/pre>\n
\u5c0f\u7ed3\uff1a
\n\u4e5f\u5c31\u662f\u8bf4\u5728\u51fa\u73b0\u5757\u635f\u574f\u7684\u60c5\u51b5\u4e0b\uff08\u5982\u4e0b\u7c7b\u4f3c\u9519\u8bef\uff09
\nERROR at line 1:
\nORA-01578: ORACLE data block corrupted (file # 5, block # 135)
\nORA-01110: data file 5: '\/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf'
\n\u6211\u4eec\u53ea\u9700\u8981\u628a\u5bf9\u5e94\u5757\u7684 tailchk \u503c\u4fee\u6539\u6b63\u786e\u5373\u53ef\uff0c\u800c\u8be5\u503c\u7684\u7ec4\u6210\u90e8\u5206\u4e2d\u7684 seq_kcbh \u503c\u53ef\u4ee5\u4e3a\u975e ff \u7684\u4efb\u610f\u503c.
\n\u8fd8\u8981\u6ce8\u610f\u7684\u662f\uff0c\u6211\u4eec\u5728\u6570\u636e\u5e93\u8fd0\u884c\u7684\u540c\u65f6\u4fee\u6539\u5b8c\uff0c\u53ef\u80fd\u9700\u8981\u91cd\u542f\u4e0b\u6570\u636e\u5e93\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5f53\u6211\u4eec\u67e5\u8be2\u4e00\u5f20\u8868\u7684\u65f6\u5019\uff0c\u5728\u626b\u63cf\u5230\u67d0\u4e9b\u8bb0\u5f55\u65f6\uff0c\u8be5\u8bb0\u5f55\u7684\u6570\u636e\u5757\u5df2\u7ecfcorruption\uff0c\u90a3\u4e48\u6211\u4eec\u53ef\u4ee5\u752810231\u4e8b […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[40],"tags":[228,222,227,226],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1008"}],"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=1008"}],"version-history":[{"count":9,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1008\/revisions"}],"predecessor-version":[{"id":1012,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1008\/revisions\/1012"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1008"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}