{"id":989,"date":"2013-07-19T16:10:25","date_gmt":"2013-07-19T08:10:25","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=989"},"modified":"2013-07-19T16:43:01","modified_gmt":"2013-07-19T08:43:01","slug":"bbed%e7%9a%84%e5%b8%b8%e8%a7%81%e4%bd%bf%e7%94%a8%e5%8f%8a%e4%bf%ae%e6%94%b9%e5%ad%97%e7%ac%a6","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=989","title":{"rendered":"BBED\u7684\u5e38\u89c1\u4f7f\u7528\u547d\u4ee4\u53ca\u4fee\u6539\u5b57\u7b26"},"content":{"rendered":"

\u53c2\u8003\u6587\u6863\uff1adisassembling the oracle data block,writter by graham thornton 2005<\/strong>
\n\u6ce8\u610f\uff1a\u4e00\u822c\u5efa\u8bae\u5728\u6570\u636e\u5e93\u5173\u95ed\u7684\u60c5\u51b5\u4e0b\u4f7f\u7528bbed\u3002\u9632\u6b62\u6b63\u5e38\u7684checkpoint\u548cbbed\u7684sum apply\u51b2\u7a81\u5bfc\u81f4\u6570\u636e\u5757\u635f\u574f\u3002
\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> alter session set nls_date_format='yyyy\/mm\/dd hh24:mi:ss';\r\n\r\nSession altered.\r\n\r\nSQL> select * from yallonking;\r\n\r\n        ID NAME                 MY_DATE\r\n---------- -------------------- -------------------\r\n         1 yallonking           2013\/07\/19 09:36:25\r\n         2 oraking              2013\/07\/19 09:45:44\r\n<\/pre>\n
\u521b\u5efa\u51fd\u6570get_rowid<\/strong>
\n\u6ce8\uff1a\u8be5\u51fd\u6570\u4f5c\u7528\u4ecerowid\u5f97\u5230\u5757\u5bf9\u8c61\u7684\u4e00\u4e9b\u4fe1\u606f\u3002<\/p>\n
\r\nSQL> create or replace function get_rowid(l_rowid in varchar2) return varchar2 is\r\n  2       ls_my_rowid   varchar2(200);\r\n  3       rowid_type    number;\r\n  4       object_number number;\r\n  5       relative_fno  number;\r\n  6       block_number  number;\r\n  7       row_number    number;\r\n  8     begin\r\n  9       dbms_rowid.rowid_info(l_rowid,\r\n 10                             rowid_type,\r\n 11                             object_number,\r\n 12                             relative_fno,\r\n 13                             block_number,\r\n 14                             row_number);\r\n 15       ls_my_rowid := 'Row_id type is  :' || to_char(rowid_type) || chr(10) ||\r\n 16                      'Object# is      :' || to_char(object_number) || chr(10) ||\r\n 17                      'Relative_fno is :' || to_char(relative_fno) || chr(10) ||\r\n 18                      'Block number is :' || to_char(block_number) || chr(10) ||\r\n 19                      'Row number is   :' || to_char(row_number);\r\n 20       return ls_my_rowid;\r\n 21     end;\r\n 22  \/\r\n\r\nFunction created.\r\n<\/pre>\n
\uff08\u4e00\uff09\u4fee\u6539\u5b57\u7b26\u4e32<\/strong>
\n\u6b64\u5904\u5c06id=1\u7684yallonking\u4e3ayallonora\uff0c\u6ce8\u610f\uff1a\u5b57\u7b26\u957f\u5ea6\u4e0d\u4e00\u81f4<\/strong><\/p>\n
\u9996\u5148\u9700\u8981\u83b7\u53d6\u5f85\u4fee\u6539\u5217\u7684\u5757\u4fe1\u606f<\/p>\n
\r\nSQL> select rowid,t.* from yallonking t where t.id=1;\r\n\r\nROWID                      ID NAME                 MY_DATE\r\n------------------ ---------- -------------------- -------------------\r\nAAARciAAFAAAACHAAA          1 yallonking           2013\/07\/19 09:36:25\r\n\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<\/pre>\n
\u914d\u7f6ebbed<\/p>\n
\r\nSQL> set line 400\r\nSQL> col FILE_NAME for a50\r\nSQL> select a.OWNER,a.TABLE_NAME,b.file_name from dba_tables a,dba_data_files b\r\n  2  where a.TABLESPACE_NAME=b.TABLESPACE_NAME\r\n  3  and a.TABLE_NAME='YALLONKING';\r\n\r\nOWNER                          TABLE_NAME                     FILE_NAME\r\n------------------------------ ------------------------------ --------------------------------------------------\r\nYALLONKING                     YALLONKING                     \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf\r\n<\/pre>\n
\u4ee5\u4e0b\u4e3a\u6279\u91cf\u8fd9\u662fbbed\u5f85\u4fee\u6539\u7684\u6570\u636e\u6587\u4ef6<\/p>\n
\r\nSQL> select file#||' '||name||' '||bytes from v$datafile where name like '%yallonking%';\r\n\r\nFILE#||''||NAME||''||BYTES\r\n----------------------------------------------------------------------\r\n5 \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf 10485760\r\n\r\n[oracle@rhl6 ~]$ pwd\r\n\/home\/oracle\r\n[oracle@rhl6 ~]$ cat bbedfile.lst\r\n5 \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf 10485760\r\n\r\n<\/pre>\n
\u4ee5\u4e0b\u4e3a\u8bbe\u7f6ebbed\u7684\u53c2\u6570\u6587\u4ef6<\/p>\n
\r\n[oracle@rhl6 ~]$ cat bbed.par\r\nblocksize=8192\r\nlistfile=\/home\/oracle\/bbedfile.lst\r\nmode=edit\r\n<\/pre>\n
\u67e5\u770bBBED\u5e2e\u52a9<\/p>\n
\r\nBBED> help all\r\nSET DBA [ dba | file#, block# ]\r\nSET FILENAME 'filename'\r\nSET FILE file#\r\nSET BLOCK [+\/-]block#\r\nSET OFFSET [ [+\/-]byte offset | symbol | *symbol ]\r\nSET BLOCKSIZE bytes\r\nSET LIST[FILE] 'filename'\r\nSET WIDTH character_count\r\nSET COUNT bytes_to_display\r\nSET IBASE [ HEX | OCT | DEC ]\r\nSET OBASE [ HEX | OCT | DEC ]\r\nSET MODE  [ BROWSE | EDIT ]\r\nSET SPOOL [ Y | N ]\r\nSHOW [ <SET parameter> | ALL ]\r\nINFO\r\nMAP[\/v] [ DBA | FILENAME | FILE | BLOCK ]\r\nDUMP[\/v] [ DBA | FILENAME | FILE | BLOCK | OFFSET | COUNT ]\r\nPRINT[\/x|d|u|o|c] [ DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | *symbol ]\r\nEXAMINE[\/Nuf] [ DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | *symbol ]\r\n<\/Nuf>:\r\nN - a number which specifies a repeat count.\r\nu - a letter which specifies a unit size:\r\n  b - b1, ub1 (byte)\r\n  h - b2, ub2 (half-word)\r\n  w - b4, ub4(word)\r\n  r - Oracle table\/index row\r\nf - a letter which specifies a display format:\r\n  x - hexadecimal\r\n  d - decimal\r\n  u - unsigned decimal\r\n  o - octal\r\n  c - character (native)\r\n  n - Oracle number\r\n  t - Oracle date\r\n  i - Oracle rowid\r\nFIND[\/x|d|u|o|c] numeric\/character string [ TOP | CURR ]\r\nCOPY [ DBA | FILE | FILENAME | BLOCK ] TO [ DBA | FILE | FILENAME | BLOCK ]\r\nMODIFY[\/x|d|u|o|c] numeric\/character string\r\n      [ DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | *symbol ]\r\nASSIGN[\/x|d|u|o] <target spec>=<source spec>\r\n<target spec> : [ DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | *symbol ]\r\n<source spec> : [ value | <target spec options> ]\r\nSUM [ DBA | FILE | FILENAME | BLOCK ] [ APPLY ]\r\nPUSH [ DBA | FILE | FILENAME | BLOCK | OFFSET ]\r\nPOP [ALL]\r\nREVERT [ DBA | FILE | FILENAME | BLOCK ]\r\nUNDO\r\nHELP [ <bbed command> | ALL ]\r\nVERIFY [ DBA | FILE | FILENAME | BLOCK ]\r\nCORRUPT [ DBA | FILE | FILENAME | BLOCK ]\r\n<\/pre>\n
\u5b9a\u4f4d\u8bb0\u5f55\u7684\u5757\u4f4d\u7f6e<\/p>\n
\r\nBBED> set filename '\/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf'\r\n        FILENAME        \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf\r\n<\/pre>\n
\u6ce8\uff1a\u8be5\u547d\u4ee4\u662f\u5b9a\u4f4d\u6307\u5b9a\u6709\u6548\u7684oracle\u6570\u636e\u6587\u4ef6<\/p>\n
\r\nBBED> set dba 5,135\r\nBBED-00312: no LISTFILE specified\r\n<\/pre>\n
\u6ce8\uff1a\u8bbe\u5b9a\u6570\u636e\u5757\u4f4d\u7f6e\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u6587\u4ef6\u6587\u4ef6\u53f7\uff0c\u7b2c\u4e8c\u53c2\u6570\u4e3a\u5757\u4f4d\u7f6e<\/p>\n
\r\nBBED> set listfile '\/home\/oracle\/bbedfile.lst'\r\n        LISTFILE        \/home\/oracle\/bbedfile.lst\r\n<\/pre>\n
\u6ce8\uff1a\u8bbe\u5b9a\u4e00\u4e2a\u6587\u4ef6\u5217\u8868\u7684\u53c2\u6570\u6587\u4ef6<\/p>\n
\r\nBBED> set dba 5,135\r\n        DBA             0x01400087 (20971655 5,135)\r\n\r\nBBED> set blocksize 8192\r\n        BLOCKSIZE       8192\r\n<\/pre>\n
\u6ce8\uff1a\u6307\u5b9a\u6570\u636e\u5e93\u6807\u51c6\u5757\u5927\u5c0f<\/p>\n
\r\nBBED> set MODE edit\r\n        MODE            Edit\r\n<\/pre>\n
\u6ce8\uff1a\u8bbe\u5b9aBBED\u6a21\u5f0f\u4e3a\u4fee\u6539<\/p>\n
\r\nBBED> verify dba 5,135\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<\/pre>\n
\u6ce8\uff1a\u9a8c\u8bc1\u6307\u5b9a\u5757<\/p>\n
\r\nBBED> show all\r\n        FILE#           5\r\n        BLOCK#          135\r\n        OFFSET          8170\r\n        DBA             0x01400087 (20971655 5,135)\r\n        FILENAME        \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.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<\/pre>\n
\u6ce8\uff1a\u67e5\u770b\u5f53\u524dBBED\u7684\u8bbe\u7f6e<\/p>\n
\r\nBBED> find \/c yallonking\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135              Offsets: 8170 to 8191           Dba:0x01400087\r\n------------------------------------------------------------------------\r\n 79616c6c 6f6e6b69 6e670778 7107130a 251a0206 f099 \r\n\r\n <32 bytes per line>\r\n<\/pre>\n
\u6ce8\uff1a\u5b9a\u4f4d\u5b57\u7b26\u4f4d\u7f6e\uff08\/c \u6307\u5b57\u7b26\uff09<\/p>\n
\r\nBBED> dump \/v dba 5,135 offset 8170 count 10\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135     Offsets: 8170 to 8179  Dba:0x01400087\r\n-------------------------------------------------------\r\n 79616c6c 6f6e6b69 6e67              l yallonking\r\n\r\n <16 bytes per line>\r\n<\/pre>\n
\u6ce8\uff1a\u627e\u5230\u5f85\u4fee\u6539\u7684\u5b57\u7b26\uff08king\u6539\u4e3aora\uff09\u7684\u5177\u4f53\u504f\u79fb\u91cf\uff0c\u6b64\u5904\u504f\u79fb\u91cf\u4e3a8176<\/p>\n
\u518d\u6b21\u786e\u8ba4\u5982\u4e0b<\/p>\n
\r\nBBED> dump \/v dba 5,135 offset 8176\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135     Offsets: 8176 to 8185  Dba:0x01400087\r\n-------------------------------------------------------\r\n 6b696e67 07787107 130a              l king.xq...\r\n\r\n <16 bytes per line>\r\n\r\n<\/pre>\n
\u4fee\u6539\u6307\u5b9a\u5b57\u7b26<\/p>\n
\r\nBBED> modify \/c ora dba 5,135 offset 8176\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135              Offsets: 8176 to 8185           Dba:0x01400087\r\n------------------------------------------------------------------------\r\n 6f726167 07787107 130a \r\n\r\n <32 bytes per line>\r\n<\/pre>\n
\u6ce8\uff1a\u8be5\u547d\u4ee4\u4fee\u6539\u6307\u5b9a\u5757\u6307\u5b9a\u504f\u79fb\u91cf\u4e0a\u7684\u5b57\u7b26<\/p>\n
\u518d\u6b21\u786e\u8ba4\u4fee\u6539\u540e\u7684<\/p>\n
\r\nBBED> dump \/v dba 5,135 offset 8176\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135     Offsets: 8176 to 8185  Dba:0x01400087\r\n-------------------------------------------------------\r\n 6f726167 07787107 130a              l orag.xq...\r\n\r\n <16 bytes per line>\r\n<\/pre>\n
\u56de\u6eda\u4e0a\u4e00\u64cd\u4f5c<\/p>\n
\r\nBBED> undo    \r\nBBED> modify \/x 6B696E filename '\/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf' block 135. offset 8176.\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135              Offsets: 8176 to 8185           Dba:0x01400087\r\n------------------------------------------------------------------------\r\n 6b696e67 07787107 130a \r\n\r\n <32 bytes per line>\r\n<\/pre>\n
\u518d\u6b21\u786e\u8ba4\u56de\u6eda\u540e\u7684\u6570\u636e<\/p>\n
\r\nBBED> dump \/v dba 5,135 offset 8176\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135     Offsets: 8176 to 8185  Dba:0x01400087\r\n-------------------------------------------------------\r\n 6b696e67 07787107 130a              l king.xq...\r\n\r\n <16 bytes per line>\r\n<\/pre>\n
\u518d\u6b21\u4fee\u6539\u6307\u5b9a\u5b57\u7b26 <\/p>\n
\r\nBBED> modify \/c ora. dba 5,135 offset 8176\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135              Offsets: 8176 to 8185           Dba:0x01400087\r\n------------------------------------------------------------------------\r\n 6f72612e 07787107 130a \r\n\r\n <32 bytes per line>\r\n<\/pre>\n
\u518d\u6b21\u786e\u8ba4\u4fee\u6539\u540e\u7ed3\u679c<\/p>\n
\r\nBBED> dump \/v dba 5,135 offset 8176\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135     Offsets: 8176 to 8185  Dba:0x01400087\r\n-------------------------------------------------------\r\n 6f72612e 07787107 130a              l ora..xq...\r\n\r\n <16 bytes per line>\r\n<\/pre>\n
\u9a8c\u8bc1\u4fee\u6539\u540e\u7684\u5757 <\/p>\n
\r\nBBED> verify 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.000b99f0 seq: 0x2 flg: 0x06\r\n spare1: 0x0 spare2: 0x0 spare3: 0x0\r\n consistency value in tail: 0x99f00602\r\n check value in block header: 0xc0ab\r\n computed block checksum: 0x520b\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\u6b64\u5904\u5df2\u7ecf\u7834\u574f\u4e86\u5757\uff0c\u6240\u6709\u6821\u9a8c\u540e\u6807\u8bb0\u4e3aCorrupt<\/p>\n
\u91cd\u65b0\u8ba1\u7b97\u6821\u9a8c\u548c\u5e76\u63d0\u4ea4\u53d8\u5316<\/p>\n
\r\nBBED> sum dba 5,135 apply\r\nCheck value for File 5, Block 135:\r\ncurrent = 0x92a0, required = 0x92a0\r\n\r\n<\/pre>\n
\u518d\u6b21\u67e5\u770b\u5757\u6821\u9a8c\u7ed3\u679c<\/p>\n
\r\nBBED> verify dba 5,135\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\n<\/pre>\n
\u5728sql\u4e2d\u786e\u8ba4\u8be5\u8868\u8bb0\u5f55<\/p>\n
\r\nSQL> alter system flush BUFFER_CACHE;\r\n\r\nSystem altered.\r\n\r\nSQL> select t.*,length(name) from yallonking.yallonking t;\r\n\r\n        ID NAME                 MY_DATE             LENGTH(NAME)\r\n---------- -------------------- ------------------- ------------\r\n         1 yallonora.           2013\/07\/19 09:36:25           10\r\n         2 oraking              2013\/07\/19 09:45:44            7\r\n<\/pre>\n
\u6ce8\uff1a\u6b64\u5904\u53d1\u73b0\u540e\u8fb9\u7684\u5c0f\u6570\u70b9\u9700\u8981\u53bb\u6389<\/p>\n
\uff08\u4e8c\uff09BBED\u5220\u9664\u6307\u5b9a\u5b57\u7b26\uff08\u95f4\u63a5\uff09<\/strong>
\n\u6b64\u5904\u5220\u9664\u4e0a\u4f8b\u4e2d\u7684\u5c0f\u6570\u70b9\uff08\u7531\u4e8e\u4fee\u6539\u5b57\u7b26\u6570\u9700\u8981\u4e00\u81f4\uff0c\u6240\u4ee5\u53ea\u80fd\u7528\u7a7a\u683c\u5360\u4f4d\u95f4\u63a5\u7684\u8fdb\u884c\u4fee\u6539\uff09<\/strong><\/p>\n
\r\nBBED> show all\r\n        FILE#           5\r\n        BLOCK#          135\r\n        OFFSET          8170\r\n        DBA             0x01400087 (20971655 5,135)\r\n        FILENAME        \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.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> dump \/v dba 5,135 \r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135     Offsets: 8170 to 8191  Dba:0x01400087\r\n-------------------------------------------------------\r\n 79616c6c 6f6e6f72 612e0778 7107130a l yallonora..xq...\r\n 251a0206 f099                       l %...e.\r\n\r\n <16 bytes per line>\r\n\r\nBBED> dump \/v dba 5,135 \r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135     Offsets: 8170 to 8191  Dba:0x01400087\r\n-------------------------------------------------------\r\n 79616c6c 6f6e6f72 612e0778 7107130a l yallonora..xq...\r\n 251a0206 f099                       l %...e.\r\n\r\n <16 bytes per line>\r\n\r\nBBED> modify \/c 'yallonora ' dba 5,135 offset 8170\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135              Offsets: 8170 to 8191           Dba:0x01400087\r\n------------------------------------------------------------------------\r\n 79616c6c 6f6e6f72 61200778 7107130a 251a0206 f099 \r\n\r\n <32 bytes per line>\r\n<\/pre>\n
\u6ce8\uff1a\u6b64\u5904\u7684\u5b57\u7b26\u540e\u8fb9\u591a\u52a0\u4e86\u4e00\u4e2a\u7a7a\u683c\u6765\u5360\u4f4d<\/strong><\/p>\n
\r\nBBED> dump \/v dba 5,135\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 135     Offsets: 8170 to 8191  Dba:0x01400087\r\n-------------------------------------------------------\r\n 79616c6c 6f6e6f72 61200778 7107130a l yallonora .xq...\r\n 251a0206 f099                       l %...e.\r\n\r\n <16 bytes per line>\r\n\r\nBBED> sum dba 5,135 apply\r\nCheck value for File 5, Block 135:\r\ncurrent = 0x9ca0, required = 0x9ca0 \r\n\r\nSQL> alter system flush BUFFER_CACHE;\r\n\r\nSystem altered.\r\n\r\nSQL> select t.*,length(name) from yallonking.yallonking t;\r\n\r\n        ID NAME                 MY_DATE             LENGTH(NAME)\r\n---------- -------------------- ------------------- ------------\r\n         1 yallonora            2013\/07\/19 09:36:25           10\r\n         2 oraking              2013\/07\/19 09:45:44            7\r\n<\/pre>\n
\u6ce8\uff1a\u867d\u7136\u4fee\u6539\u4e86\u5b57\u7b26\uff0c\u4f46\u662f\u5b57\u7b26\u957f\u5ea6\u8fd8\u662f\u6ca1\u6709\u53d8\u3002\u53ea\u662f\u901a\u8fc7\u4fee\u6539\u95f4\u63a5\u7684\u5220\u9664\u4e86\u5b57\u7b26\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u53c2\u8003\u6587\u6863\uff1adisassembling the oracle data block,writter by gra […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[40],"tags":[222],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/989"}],"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=989"}],"version-history":[{"count":4,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/989\/revisions"}],"predecessor-version":[{"id":993,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/989\/revisions\/993"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=989"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=989"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=989"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}