RMAN备份时候文件坏块的处理

http://www.itpub.net/showthread.php?threadid=727648&pagenumber=

***
Corrupt block relative dba: 0x0280cab8 (file 10, block 51896)
Fractured block found during datafile copy
Data in bad block -
type: 0 format: 2 rdba: 0x0000cab8
last change scn: 0x0000.00000000 seq: 0x1 flg: 0x05
consistency value in tail: 0x00000000
check value in block header: 0xcdb8, computed block checksum: 0x1
spare1: 0x0, spare2: 0x0, spare3: 0x0
***

1. 開始報錯 /ocfs_data/intel/base_data01.dbf 有壞塊時候 , 根據 file#=10 , block=51896 找到有問題的
table: c_kanban_config_t 表, 重新建立這個table . 結果還是不報同樣的錯誤 .

2. 然後將 base_data01.dbf 從 /ocfs_data/intel 下轉移到 /ocfs_index/intel/ 下. 還是報同樣的錯誤 . 如上 .

3. 可以斷定不是物理磁盤上的壞塊, 而是在 base_data01.dbf 文件上的壞塊 .

查询坏块：

dmdii-node1$dbv file=base_data01.dbf blocksize=8192

DBVERIFY: Release 9.2.0.4.0 - Production on Sat Mar 3 16:17:21 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

DBVERIFY - Verification starting : FILE = base_data01.dbf
Page 51896 is influx - most likely media corrupt
***
Corrupt block relative dba: 0x0280cab8 (file 10, block 51896)
Fractured block found during dbv:
Data in bad block -
type: 0 format: 2 rdba: 0x0000cab8
last change scn: 0x0000.00000000 seq: 0x1 flg: 0x05
consistency value in tail: 0x00000000
check value in block header: 0xcdb8, computed block checksum: 0x1
spare1: 0x0, spare2: 0x0, spare3: 0x0
***

Page 51897 is marked corrupt
***
Corrupt block relative dba: 0x0280cab9 (file 10, block 51897)
Completely zero block found during dbv:

Page 51898 is marked corrupt
***
Corrupt block relative dba: 0x0280caba (file 10, block 51898)
Completely zero block found during dbv:

Page 51899 is marked corrupt
***
Corrupt block relative dba: 0x0280cabb (file 10, block 51899)
Completely zero block found during dbv:

Page 51900 is marked corrupt
***
Corrupt block relative dba: 0x0280cabc (file 10, block 51900)
Completely zero block found during dbv:

Page 51901 is marked corrupt
***
Corrupt block relative dba: 0x0280cabd (file 10, block 51901)
Completely zero block found during dbv:

Page 51902 is marked corrupt
***
Corrupt block relative dba: 0x0280cabe (file 10, block 51902)
Completely zero block found during dbv:

Page 51903 is marked corrupt
***
Corrupt block relative dba: 0x0280cabf (file 10, block 51903)
Completely zero block found during dbv:

Page 51904 is marked corrupt
***
Corrupt block relative dba: 0x0280cac0 (file 10, block 51904)
Completely zero block found during dbv:

Page 51905 is marked corrupt
***
Corrupt block relative dba: 0x0280cac1 (file 10, block 51905)
Completely zero block found during dbv:

Page 51906 is marked corrupt
***
Corrupt block relative dba: 0x0280cac2 (file 10, block 51906)
Completely zero block found during dbv:

Page 51907 is marked corrupt
***
Corrupt block relative dba: 0x0280cac3 (file 10, block 51907)
Completely zero block found during dbv:

Page 51908 is marked corrupt
***
Corrupt block relative dba: 0x0280cac4 (file 10, block 51908)
Completely zero block found during dbv:

Page 51909 is marked corrupt
***
Corrupt block relative dba: 0x0280cac5 (file 10, block 51909)
Completely zero block found during dbv:

Page 51910 is marked corrupt
***
Corrupt block relative dba: 0x0280cac6 (file 10, block 51910)
Completely zero block found during dbv:

Page 51911 is marked corrupt
***
Corrupt block relative dba: 0x0280cac7 (file 10, block 51911)
Completely zero block found during dbv:

Page 51912 is marked corrupt
***
Corrupt block relative dba: 0x0280cac8 (file 10, block 51912)
Completely zero block found during dbv:

Page 51913 is marked corrupt
***
Corrupt block relative dba: 0x0280cac9 (file 10, block 51913)
Completely zero block found during dbv:

Page 51914 is influx - most likely media corrupt
***
Corrupt block relative dba: 0x0280caca (file 10, block 51914)
Fractured block found during dbv:
Data in bad block -
type: 0 format: 0 rdba: 0x00000000
last change scn: 0x0000.00000000 seq: 0x0 flg: 0x00
consistency value in tail: 0x00000001
check value in block header: 0x0, block checksum disabled
spare1: 0x0, spare2: 0x0, spare3: 0x0
***

DBVERIFY - Verification complete

Total Pages Examined : 256008
Total Pages Processed (Data) : 15320
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 1
Total Pages Failing (Index): 0
Total Pages Processed (Other): 223
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 240445
Total Pages Marked Corrupt : 19
Total Pages Influx : 2
dmdii-node1$

SELECT tablespace_name, segment_type, owner, segment_name, partition_name
FROM dba_extents WHERE file_id = and between block_id AND block_id + blocks – 1；

-----------------------------------------------------------------
沒有辦法 : 只有使用 maxcorrupt 參數設值rman備份允許略過壞塊 .
------------------------------------------------------------------

file#=10 , 100 表示略過的corrupt塊最大數量 .

RUN {

set maxcorrupt for datafile 10 to 100;

ALLOCATE CHANNEL dmd2 DEVICE TYPE DISK ;

COPY
datafile '/ocfs_data/intel/system01.dbf' to '/backup/ocfs_data/intel/system01.dbf',
datafile '/ocfs_data/intel/undotbs01.dbf' to '/backup/ocfs_data/intel/undotbs01.dbf',
datafile '/ocfs_data/intel/cwmlite01.dbf' to '/backup/ocfs_data/intel/cwmlite01.dbf',
datafile '/ocfs_data/intel/drsys01.dbf' to '/backup/ocfs_data/intel/drsys01.dbf',
datafile '/ocfs_data/intel/indx01.dbf' to '/backup/ocfs_data/intel/indx01.dbf',
datafile '/ocfs_data/intel/tools01.dbf' to '/backup/ocfs_data/intel/tools01.dbf',
datafile '/ocfs_data/intel/users01.dbf' to '/backup/ocfs_data/intel/users01.dbf',
datafile '/ocfs_data/intel/xdb01.dbf' to '/backup/ocfs_data/intel/xdb01.dbf',
datafile '/ocfs_data/intel/undotbs02.dbf' to '/backup/ocfs_data/intel/undotbs02.dbf',
datafile '/ocfs_data/intel/base_data01.dbf' to '/backup/ocfs_data/intel/base_data01.dbf',
datafile '/ocfs_data/intel/base_data02.dbf' to '/backup/ocfs_data/intel/base_data02.dbf',

.....

datafile '/ocfs_index/intel/sn_idx35.dbf' to '/backup/ocfs_index/intel/sn_idx35.dbf',
datafile '/ocfs_data/intel/sn_data28.dbf' to '/backup/ocfs_data/intel/sn_data28.dbf',
datafile '/ocfs_index/intel/wiplog_idx16.dbf' to '/backup/ocfs_index/intel/wiplog_idx16.dbf',
datafile '/ocfs_index/intel/track_index10.dbf' to '/backup/ocfs_index/intel/track_index10.dbf';
RELEASE CHANNEL dmd2 ;
}

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

转载于:http://blog.itpub.net/35489/viewspace-84576/