oracle 数据库坏块解析

最近在搭建同城灾备的过程中表空间sysaux经常出现如下报错：

RMAN-03009: failure of backup command on ch04 channel at 08/24/2020 18:09:30
ORA-19566: exceeded limit of 0 corrupt blocks for file /oradata/hjxt/sysaux.268.1024680419

 

以下为相关查询信息：

SQL> select * from v$database_block_corruption;

     FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTION_TYPE
---------- ---------- ---------- ------------------ ---------------------------
         2      77695          1                  0 CHECKSUM
         
         
[oracle@yzjf-hjxt-db0 sj]$ dbv file=/oradata/hjxt/sysaux.268.1024680419

DBVERIFY: Release 11.2.0.4.0 - Production on Tue Aug 25 08:59:08 2020

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

DBVERIFY - Verification starting : FILE = /oradata/hjxt/sysaux.268.1024680419
Page 77695 is marked corrupt
Corrupt block relative dba: 0x00812f7f (file 2, block 77695)
Bad check value found during dbv: 
Data in bad block:
 type: 6 format: 2 rdba: 0x00812f7f
 last change scn: 0x0000.18a75bb1 seq: 0x1 flg: 0x06
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0x5bb10601
 check value in block header: 0x1fe
 computed block checksum: 0xd00



DBVERIFY - Verification complete

Total Pages Examined         : 1280000
Total Pages Processed (Data) : 62043
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 55557
Total Pages Failing   (Index): 0
Total Pages Processed (Lob)  : 9354
Total Pages Failing   (Lob)  : 0
Total Pages Processed (Other): 23420
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 1129625
Total Pages Marked Corrupt   : 1
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 444388540 (0.444388540)

查询对应的出现坏块的对象：

SELECT tablespace_name, segment_type, owner, segment_name
          FROM dba_extents
         WHERE file_id = 2
           and 77695 between block_id AND block_id + blocks - 1;

 

 

 

 

参考文章：RMAN Reports an ORA-19566: Exceeded Limit Of 0 Corrupt Blocks From Backup And No Segment Associated (Doc ID 457422.1)