Originally posted by julian
I think that the default for MAXCORRUPT is 0. So you do not have to set it explicitely in the script.
Then i guess it means that i will always have a corruption free backups (copies) if i leave the default value as it is, right?.

Does that mean that i will query v$backup_corruption, and v$copy_corruption only if i set maxcorrupt to a number > 0?

One more thing i need to clarify please, why would anyone set the maxcorrupt to a number > 0?

the block media recovery (BMR) feature in 9i is meaningless unless i set the value of maxcorrupt to a number > 0 (which i don't know why would anyone want to do), right?

Thanks Julian.