rman系列之BBED破坏，BlockRecover恢复的案例演示(二)
relative dba: 0x01000047 (file 0, block 71)
Bad header found during verification
Data in bad block:
type: 3 format: 0 rdba: 0x01000047
last change scn: 0x0000.00043ea6 seq: 0x4 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x3ea60604
check value in block header: 0x4c45
computed block checksum: 0x4a05
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 0
Total Blocks Failing (Index): 0
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 1
Total Blocks Influx : 0
③ SQLPLUS 检查
[sql]
u1@EMREP> conn / as sysdba
Connected.
sys@EMREP> startup force;
ORACLE instance started.
Total System Global Area 524288000 bytes
Fixed Size 1220384 bytes
Variable Size 247464160 bytes
Database Buffers 272629760 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
sys@EMREP> conn u1/u1
Connected.
u1@EMREP> select * from t2;
select * from t2
*
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 4, block # 71)
ORA-01110: data file 4: '/u01/app/oracle/oradata/emrep/users01.dbf'
④ DBV再次确认
[sql]
[oracle@localhost ~]$ dbv file=/u01/app/oracle/oradata/emrep/users01.dbf
DBVERIFY: Release 10.2.0.1.0 - Production on Mon Dec 17 21:00:48 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
DBVERIFY - Verification starting : FILE = /u01/app/oracle/oradata/emrep/users01.dbf
Page 63 is marked corrupt
Corrupt block relative dba: 0x0100003f (file 4, block 63)
Bad header found during dbv:
Data in bad block:
type: 3 format: 0 rdba: 0x0100003f
last change scn: 0x0000.00050c11 seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x0c110601
check value in block header: 0xd375
computed block checksum: 0x4a05
Page 71 is marked corrupt
Corrupt block relative dba: 0x01000047 (file 4, block 71)
Bad header found during dbv:
Data in bad block:
type: 3 format: 0 rdba: 0x01000047
last change scn: 0x0000.00043ea6 seq: 0x4 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x3ea60604
check value in block header: 0x4c45
computed block checksum: 0x4a05
DBVERIFY - Verification complete
Total Pages Examined : 640
Total Pages Processed (Data) : 39
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 6
Total Pages Failing (Index): 0
Total Pages Processed (Other): 45
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 548
Total Pages Marked Corrupt : 2
Total Pages Influx : 0
Highest block SCN : 330790 (0.330790)
⑤ RMAN修复
[sql]
RMAN> blockrecover datafile 4 block 71;
Starting blockrecover at 17-DEC-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=538 devtype=DISK
channel ORA_DISK_1: restoring block(s)
channel ORA_DISK_1: specifying block(s) to restore from backup set
resto