最近在搭建同城灾备的过程中表空间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;