RMAN深入解析之--BlockRecover恢复坏块(四)

2014-11-24 17:17:49 · 作者: · 浏览: 2
----------------------------------------------------


Extent Header:: spare1: 0 spare2: 0 #extents: 1 #blocks: 8


last map 0x00000000 #maps: 0 offset: 2716


Highwater:: 0x010000b0 ext#: 0 blk#: 8 ext size: 8


#blocks in seg. hdr's freelists: 0


#blocks below: 8


mapblk 0x00000000 offset: 0


Unlocked


--------------------------------------------------------


Low HighWater Mark :


Highwater:: 0x010000b0 ext#: 0 blk#: 8 ext size: 8


#blocks in seg. hdr's freelists: 0


#blocks below: 8


mapblk 0x00000000 offset: 0


Level 1 BMB for High HWM block: 0x010000a8


Level 1 BMB for Low HWM block: 0x010000a8


--------------------------------------------------------


Segment Type: 1 nl2: 1 blksz: 8192 fbsz: 0


L2 Array start offset: 0x00001434


First Level 3 BMB: 0x00000000


L2 Hint for inserts: 0x010000a9


Last Level 1 BMB: 0x010000a8


Last Level II BMB: 0x010000a9


Last Level III BMB: 0x00000000


Map Header:: next 0x00000000 #extents: 1 obj#: 75131 flag: 0x10000000


Inc # 0


Extent Map


-----------------------------------------------------------------


0x010000a8 length: 8



Auxillary Map


--------------------------------------------------------


Extent 0 : L1 dba: 0x010000a8 Data dba: 0x010000ab


--------------------------------------------------------



Second Level Bitmap block DBAs


--------------------------------------------------------


DBA 1: 0x010000a9



End dump data blocks tsn: 4 file#: 4 minblk 170 maxblk 170



2、将Uedit32(通过16进制编辑功能)编辑过的数据文件上传到数据库


13:59:58 SYS@ prod>alter system flush buffer_cache;


System altered.


读取数据出错:


14:00:05 SYS@ prod>select * from scott.emp1;


select * from scott.emp1


*


ERROR at line 1:


ORA-01578: ORACLE data block corrupted (file # 4, block # 170)


ORA-01110: data file 4: '/u01/app/oracle/oradata/prod/users01.dbf'



验证数据文件:


[oracle@rh6 ~]$ dbv file=/u01/app/oracle/oradata/prod/users01.dbf blocksize=8192



DBVERIFY: Release 11.2.0.1.0 - Production on Tue Jul 15 13:59:41 2014


Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.


DBVERIFY - Verification starting : FILE = /u01/app/oracle/oradata/prod/users01.dbf


Page 170 is marked corrupt


Corrupt block relative dba: 0x010000aa (file 4, block 170)


Bad check value found during dbv:


Data in bad block:


type: 35 format: 2 rdba: 0x010000aa


last change scn: 0x0000.001f891c seq: 0x2 flg: 0x04


spare1: 0x0 spare2: 0x0 spare3: 0x0


consistency value in tail: 0x891c2302


check value in block header: 0x8eee


computed block checksum: 0x2020


Page 171 is marked corrupt


Corrupt block relative dba: 0x010000ab (file 4, block 171)


Bad header found during dbv:


Data in bad block:


type: 6 format: 2 rdba: 0x012020ab


last change scn: 0x2020.201f890b seq: 0x2 flg: 0x04


spare1: 0x20 spare2: 0x20 spare3: 0x2020


consistency value in tail: 0x890b0602


check value in block header: 0xcf8b


computed block checksum: 0x2e00


Page 172 is marked corrupt


Corrupt block relative dba: 0x010000ac (file 4, block 172)


Bad header found during dbv:


Data in bad block:


type: 6 format: 2 rdba: 0x012020ac


last change scn: 0x2020.201f891c seq: 0x3 flg: 0x06


spare1: 0x20 spare2: 0x20 spare3: 0x2020


consistency value in tail: 0x891c0603


check value in block header: 0xa5b1


computed block checksum: 0x0


Page 173 is marked corrupt


Corrupt block relative dba: 0x010000ad (file 4, block 173)


Bad header found during dbv:


Data in bad block:


type: 6 format