corrupt blocks & blockrecover

错误现象：
1>
snapshot refresh error
Fri Feb 15 16:24:35 2008
     Errors in file /srpt/app/oracle/admin/srpt/bdump/srpt_j002_2449.trc:
     ORA-00600: internal error code, arguments: [kcbrls_1], [], [], [], [], [], [], []
Fri Feb 15 16:24:36 2008
     Errors in file /srpt/app/oracle/admin/srpt/bdump/srpt_j002_2449.trc:
     ORA-12012: error on auto execute of job 16
     ORA-12008: error in materialized view refresh path
     ORA-00600: internal error code, arguments: [kcbrls_1], [], [], [], [], [], [], []
     ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803
     ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860
     ORA-06512: at "SYS.DBMS_IREFRESH", line 683
     ORA-06512: at "SYS.DBMS_REFRESH", line 195
     ORA-06512: at line 1
srpt_j002_2449.trc 文件中：
Corrupt block relative dba: 0x08400002 (file 33, block 2 Bad header found during buffer read
Data in bad block -
 type: 48 format: 0 rdba: 0x373a3536
 last change scn: 0x205b.2e323837 seq: 0x31 flg: 0x39
 consistency value in tail: 0x6d951d02
 check value in block header: 0x3134, block checksum disabled
 spare1: 0x3a, spare2: 0x31, spare3: 0x315d
2>
rman backup error
ORA-19566: exceeded limit of 0 corrupt blocks for file /srpt/srpt/srpt_data02.dbf
3>
run  SELECT *　FROM DBA_DATA_FILES; show error
ORA-00600: internal error code, arguments: [kcbrls_1], [], [], [], [], [], [], []
4>
dbv file=/srpt/srpt/srpt_data02.dbf blocksize=16384 start=1 end=100
DBVERIFY: Release 9.2.0.6.0 - Production on Fri Feb 15 16:05:06 2008
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
DBVERIFY - Verification starting : FILE = srpt_data02.dbf
Page 2 is marked corrupt
***
Corrupt block relative dba: 0x08400002 (file 33, block 2)
Bad header found during dbv:
Data in bad block -
 type: 48 format: 0 rdba: 0x373a3536
 last change scn: 0x205b.2e323837 seq: 0x31 flg: 0x39
 consistency value in tail: 0x6d951d02
 check value in block header: 0x3134, block checksum disabled
 spare1: 0x3a, spare2: 0x31, spare3: 0x315d
***
 
 
 
DBVERIFY - Verification complete
 
Total Pages Examined         : 100
Total Pages Processed (Data) : 94
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 5
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 0
Total Pages Marked Corrupt   : 1
Total Pages Influx           : 0
Highest block SCN            : 48044192834 (11.799552578)

5>确定此file& block　的segment
SELECT tablespace_name, segment_type, owner, segment_name
          FROM dba_extents
         WHERE file_id = 33
           and 2 between block_id AND block_id + blocks - 1
;
显示为空
DBA_EXTENTS does not include blocks which are used
  for local space management in locally managed tablespaces.

在线做block级别的恢复：
相关scripts & log:
RMAN> run{
2> allocate channel ch1 device type 'sbt_tape';
3> blockrecover datafile 33 block 2 from backupset;
4> release channel ch1;
5> }
 
released channel: ORA_DISK_1
allocated channel: ch1
channel ch1: sid=100 devtype=SBT_TAPE
channel ch1: VERITAS NetBackup for Oracle - Release 5.1 (2004043014)
 
Starting blockrecover at 15-FEB-08
 
 
channel ch1: restoring block(s)
channel ch1: specifying block(s) to restore from backup set
restoring blocks of datafile 00033
channel ch1: restored block(s) from backup piece 1
piece handle=bk_5956_1_645481117 tag=HOT_DB_BK_LEVEL0 params=NULL
channel ch1: block restore complete
 
starting media recovery
 
archive log thread 1 sequence 33542 is already on disk as file /sarch/srpt/archive/1_33542.arc
......
archive log thread 1 sequence 33632 is already on disk as file /sarch/srpt/archive/1_33632.arc
channel ch1: starting archive log restore to default destination
channel ch1: restoring archive log
......
archive log thread=1 sequence=33541
channel ch1: restored backup piece 1
piece handle=al_6090_1_646531263 tag=TAG20080212T221817 params=NULL
channel ch1: restore complete
media recovery complete
Finished blockrecover at 15-FEB-08
 
released channel: ch1

OK ,解决问题。

参考：
metalink:Note:144911.1
RMAN 9i: Block-Level Media Recovery - Concept & Example
metalink:Note:28814.1
Handling Oracle Block Corruptions in Oracle7/8/8i/9i/10g

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/308563/viewspace-172015/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/308563/viewspace-172015/