Error Message

Error message from RMAN Output:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command
RMAN-06183: datafile or datafile copy /FININDX07.DBF (file number 47) larger than MAXSETSIZE

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

Connect to RMAN to check the parameters set on the Oracle database.
Either increase the size of the MAXSETSIZE parameter to a value larger than the largest DBF file size or specify it as unlimited.
 

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.

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

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

The default value is normally set to UNLIMITTED
Example:  CONFIGURE MAXSETSIZE TO UNLIMITTED 
 

NOTE: It is recommended to consult the database administrator before updating the RMAN parameters.