Database Software

Hi all, i have 2 node RAC and i am trying to take rman backup of the database which is in ASM filesystem.

There is a corruption in SYSAUX file and rman is failing to take backup of the sysaux datafile and error thrown at the end like

piece handle=/home/oracle/orabackup/BLOOM_LVL0_20120627_1qnejueh_s58_p1 tag=TAG20120627T185538 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:56
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/27/2012 18:56:17
*ORA-19566: exceeded limit of 0 corrupt blocks for file +DATA/bloom/datafile/sysaux.257.775475317*

Then i tried to validate the backup in rman of the datafile sysaux nad fired the following query

SQL> SELECT * FROM v$database_block_corruption;

FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO
---------- ---------- ---------- ------------------ ---------
3 32011 1 0 ALL ZERO
3 32049 40 0 ALL ZERO
3 32034 1 0 ALL ZERO
3 28964 1 1399837 LOGICAL
3 32015 2 0 ALL ZERO

and found all the blocks in the table WRH$_SQL_PLAN.

Then dropped the table, and tried to take backup of the database and it is failing again with the same error..

ANY SOLUTION TO TAKE BACKUP OF THE DATABASE.

anyhow we can SET MAXCORRUPT FOR DATAFILE 3 to value, but does this works all time...

Thanks in advance,
TEJAS