ORA-19566: Exceeded limit of 0 corrupt blocks for file:

**ORA-19566: Exceeded limit of 0 corrupt blocks for file:                       
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on t3 channel at 01/21/2019 23:20:55
ORA-19566: exceeded limit of 0 corrupt blocks for file /u01/app/oracle/product/11.2.0.4/oradata/REDHAT/system01.dbf

Solution:-

SQL> select * from V$DATABASE_BLOCK_CORRUPTION;

     FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTION
———- ———- ———- —————— ———
       352     165657          1                  0             ALL ZERO
       352     165656          1                  0              CORRUPT

RMAN> blockrecover datafile 352 block 165656;

Retry…….i hope issue resolved……………

Check block corruption

[oracle@oracle REDHAT]$ dbv file=/u01/app/oracle/product/11.2.0.4/oradata/REDHAT/system01.dbf

DBVERIFY: Release 11.2.0.4.0 – Production on Mon Jan 21 23:34:45 2019

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

DBVERIFY – Verification starting : FILE = /u01/app/oracle/product/11.2.0.4/oradata/REDHAT/system01.dbf

DBVERIFY – Verification complete

Total Pages Examined         : 101120
Total Pages Processed (Data) : 64789
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 13790
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 8426
Total Pages Processed (Seg)  : 1
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 14115
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 6143140 (0.6143140)

  • January 23, 2019 | 17 views
  • Comments