Oracle rman备份报错，提示数据文件有坏块，自己查看alert并无报错，说明还没有影响到业务。。
根据报错检查确认
[oracle@xx02 ~]$ dbv file='+DATAC1/xxxxdb/datafile/xx_tbs.3223.1044115207' blocksize=8192 userid=sys/xxxxxxx
DBVERIFY: Release 11.2.0.4.0 - Production on Mon Nov 22 09:45:59 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
DBVERIFY - Verification starting : FILE = +DATAC1/xxxxdb/datafile/xx_tbs.3223.1044115207
Page 8212 is marked corrupt
Corrupt block relative dba: 0xaa402014 (file 681, block 8212)
Bad header found during dbv:
Data in bad block:
type: 122 format: 2 rdba: 0xbadfda7a
last change scn: 0xda7a.badfda7a seq: 0xdf flg: 0xba
spare1: 0xdf spare2: 0xba spare3: 0xbadf
consistency value in tail: 0xbadfda7a
check value in block header: 0xda7a
block checksum disabled
DBVERIFY - Verification complete
Total Pages Examined : 655360
Total Pages Processed (Data) : 549193
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 91832
Total Pages Failing (Index): 0
Total Pages Processed (Other): 7163
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 7171
Total Pages Marked Corrupt : 1 >>>>Corrupt
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 0 (0.0)验证文件损坏
通过dbv检查发现数据文件确实存在坏块，进一步确认占用坏块的对象
backup validate datafile 681;
[oracle@xx02 ~]$ more /u01/app/oracle/diag/rdbms/xxxxdb/xxxxdb2/trace/xxxxdb2_ora_53650.trc
Trace file /u01/app/oracle/diag/rdbms/xxxxdb/xxxxdb2/trace/xxxxdb2_ora_53650.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1
System name: Linux
Node name: xx02
Release: 2.6.39-400.250.4.el6uek.x86_64
Version: #1 SMP Tue Jun 2 14:50:33 PDT 2015
Machine: x86_64
Instance name: xxxxdb2
Redo thread mounted by this instance: 2
Oracle process number: 1109
Unix process pid: 53650, image: oracle@xx02 (TNS V1-V3)
*** 2021-11-22 09:55:29.441
*** SESSION ID:(3113.16425) 2021-11-22 09:55:29.441
*** CLIENT ID:() 2021-11-22 09:55:29.441
*** SERVICE NAME:(SYS$USERS) 2021-11-22 09:55:29.441
*** MODULE NAME:(backup full datafile) 2021-11-22 09:55:29.441
*** ACTION NAME:(0000015 STARTED19) 2021-11-22 09:55:29.441
Hex dump of (file 681, block 8212)
Dump of memory from 0x00007FBE6DF54000 to 0x00007FBE6DF56000
7FBE6DF54000 BADFDA7A BADFDA7A BADFDA7A BADFDA7A [z...z...z...z...]
Repeat 511 times
Corrupt block relative dba: 0xaa402014 **(file 681, block 8212)** <<<< block 8212
Bad header found during validation
Data in bad block:
type: 122 format: 2 rdba: 0xbadfda7a
last change scn: 0xda7a.badfda7a seq: 0xdf flg: 0xba
spare1: 0xdf spare2: 0xba spare3: 0xbadf
consistency value in tail: 0xbadfda7a
check value in block header: 0xda7a
block checksum disabled
ksfdrfms:Mirror Read file=+DATAC1/xxxxdb/datafile/xx_tbs.3223.1044115207 fob=0x8b2909ad0 bufp=0x7fbe73460000 blkno=8212 nbytes=8192
ksfdrfms: Read success from mirror side=1 logical extent number=0 disk=DATAC1_CD_09_DM04CEL04 path=o/192.168.10.1;192.168.10.2/DATAC1_CD_dm1
Mirror I/O done from ASM disk o/192.168.10.1;192.168.10.2/DATAC1_CD_dm1
Trying mirror side DATAC1_CD_dm1.通过SQL确认对象信息
SELECT e.owner,
e.segment_type,
e.segment_name,
e.partition_name,
c.file#,
greatest(e.block_id, c.block#) corr_start_block#,
least(e.block_id + e.blocks - 1, c.block# + c.blocks - 1) corr_end_block#,
least(e.block_id + e.blocks - 1, c.block# + c.blocks - 1) -
greatest(e.block_id, c.block#) + 1 blocks_corrupted,
null description
FROM dba_extents e, v$database_block_corruption c
WHERE e.file_id = c.file#
AND e.block_id <= c.block# + c.blocks - 1
AND e.block_id + e.blocks - 1 >= c.block#
UNION
SELECT s.owner,
s.segment_type,
s.segment_name,
s.partition_name,
c.file#,
header_block corr_start_block#,
header_block corr_end_block#,
1 blocks_corrupted,
'Segment Header' description
FROM dba_segments s, v$database_block_corruption c
WHERE s.header_file = c.file#
AND s.header_block between c.block# and c.block# + c.blocks - 1
UNION
SELECT null owner,
null segment_type,
null segment_name,
null partition_name,
c.file#,
greatest(f.block_id, c.block#) corr_start_block#,
least(f.block_id + f.blocks - 1, c.block# + c.blocks - 1) corr_end_block#,
least(f.block_id + f.blocks - 1, c.block# + c.blocks - 1) -
greatest(f.block_id, c.block#) + 1 blocks_corrupted,
'Free Block' description
FROM dba_free_space f, v$database_block_corruption c
WHERE f.file_id = c.file#
AND f.block_id <= c.block# + c.blocks - 1
AND f.block_id + f.blocks - 1 >= c.block#
order by file#, corr_start_block#;确认坏块上的段
SQL> SELECT tablespace_name, segment_type, owner, segment_name
FROM dba_extents
WHERE file_id = &fileid
and &blockid between block_id AND block_id + blocks - 1; 2 3 4
Enter value for fileid: 681
old 3: WHERE file_id = &fileid
new 3: WHERE file_id = 681
Enter value for blockid: 8212
old 4: and &blockid between block_id AND block_id + blocks - 1
new 4: and 8212 between block_id AND block_id + blocks - 1
TABLESPACE_NAME SEGMENT_TYPE OWNER SEGMENT_NAME
------------------ ------------- ---------- -------------------
xx_tbs TABLE XXX xxx_GROUP_20200721通过rman恢复
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
send 'NB_ORA_CLIENT=db01-10g';
blockrecover datafile 681 block 8212;
RELEASE CHANNEL ch00;
}
