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?.
Yes. This is from the Oracle documentation:
"MAXCORRUPT sets a limit on the number of previously undetected physical block corruptions that Oracle will allow in a specified datafile or list of datafiles. If a BACKUP or COPY command detects more than the specified number of corruptions, the command aborts. The default limit is zero, meaning that RMAN tolerates no corrupt blocks."
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?
Good question! Probably if you really need the backup and don't care about some corrupted blocks hoping possibly they they are index blocks. So that you can then drop and recreate the indexes. I really don't know :-)
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g