Loading...

Configuring a List of Datafile IDs for Allowed Block Corruptions

You can configure a list of Oracle datafile IDs that you want to associate with the number of block corruptions that are allowed during a backup operation, restore operation, or duplication operation for Oracle. The value that you specify is used in the RMAN restore script for defining the list of datafile IDs in the SET MAXCORRUPT FOR DATAFILE command syntax.

You can set a MAXCORRUPT blocks value for backup operations for Oracle subclients by defining a value for the Max DB Block Corruption Threshold box, which is on the Oracle Options tab on the Advanced Backup Options dialog box. If you don't define the sSetMaxCorruptOnDataFiles additional setting, the value for MAXCORRUPT blocks applies to all datafiles of the database you are backing up. You can customize this behavior by setting the sSetMaxCorruptOnDataFiles value to a comma-separated list of datafile numbers. The MAXCORRUPT blocks value is then applied only to that list of datafiles during backup operations.

For restore operations and duplication operations, you can use the sSetMaxCorruptOnDataFiles additional setting in combination with the nMaxCorruptBlocksForRestore additional setting to set the MAXCORRUPT blocks value for a list of datafile IDs. If you don't define sSetMaxCorruptOnDataFiles, the value for MAXCORRUPT blocks applies to all datafiles of the database that you are restoring or duplicating. For more information about the nMaxCorruptBlocksForRestore additional setting, see Configuring the Number of Block Corruptions Allowed During a Restore Operation.

Procedure

Last modified: 10/30/2020 3:01:50 PM