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 08/23/2014 03:20:55
ORA-19566: exceeded limit of 0 corrupt blocks for file /u01/sujeetdb/db/apps_st/data/system09.dbf


Solution:-

SQL> select * from V$DATABASE_BLOCK_CORRUPTION;

     FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO
---------- ---------- ---------- ------------------ ---------
       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:-

[orachintels@sujeet]$ dbv  file=/u01/sujeetdb/db/apps_st/data/system09.dbf

DBVERIFY - Verification complete

Total Pages Examined         : 192128
Total Pages Processed (Data) : 65567
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 30690
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 1880
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 67518
Total Pages Marked Corrupt   : 26473
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 3757655288 (1388.3757655288)



No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf&#...