Oracle backup job fails with error: RMAN-06183: datafile or datafile copy /xxxxxx.dbf (file number) larger than MAXSETSIZE

Problem

Oracle backup job fails with error: RMAN-06183: datafile or datafile copy <path>/xxxxxx.dbf (file number) larger than MAXSETSIZE

Error Message

Info bphdb (pid=27064) INF - RMAN-03002: failure of backup command
Info bphdb (pid=27064) INF - RMAN-06183: datafile or datafile copy <path>/sysaux01.dbf (file number 11) larger than MAXSETSIZE
Info bphdb (pid=27064) INF - Recovery Manager complete.

Cause

The MAXSETSIZE parameter in RMAN is set to a value which is lower than the size of the dbf file for the Oracle database.

Solution

1) Connect to RMAN to check the parameters set on the Oracle database.
Increase the size of the MAXSETSIZE parameter to a value larger than the largest dbf file size.

For example:
If the MAXSETSIZE is set to 15GB, but the dbf file size is 25GB, then increase the MAXSETSIZE to a value greater than 25GB or set it to UNLIMITED.

RMAN> show all;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO 15 G;
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

Change the value to 30GB or unlimited.

RMAN> CONFIGURE MAXSETSIZE TO 30G;
old RMAN configuration parameters:
CONFIGURE MAXSETSIZE TO 15 G;
new RMAN configuration parameters:
CONFIGURE MAXSETSIZE TO UNLIMITED;
new RMAN configuration parameters are successfully stored

2) Please go to Master server Java GUI and edit the affected oracle OIP policy and navigate to Oracle tab > Uncheck the 'specify size' check box from the left pane.

NOTE: Kindly contact the Database Administrator before you update RMAN parameters using the above command.