RMAN-06183: datafile or datafile copy prod_data_01.dbf (file number 9) larger than MAXSETSIZE
Error:
Starting backup at 15-DEC-14
released channel: dev1
released channel: dev2
released channel: dev3
released channel: dev4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/15/2014 21:18:02
RMAN-06183: datafile or datafile copy prod_data_01.dbf (file number 9) larger than MAXSETSIZE
Action:
1) Verify the RMAN backup script and check the backup setsize set properly.
RMAN backup setsize should be more than the max(size) of datafiles in the database.
2) RMAN> show all;
CONFIGURE MAXSETSIZE TO 30720 M;
Here we go so we have the max file size limit of 30g where as my file size is around 32 g.
So to fiz this...
RMAN> CONFIGURE MAXSETSIZE clear;
run {
allocate channel dev1 type 'SBT_TAPE';
allocate channel dev2 type 'SBT_TAPE';
allocate channel dev3 type 'SBT_TAPE';
allocate channel dev4 type 'SBT_TAPE';
sql 'ALTER SYSTEM SWITCH LOGFILE';
backup
full
filesperset=30
setsize=20000000 ( make sure this value is more than the max datafile size in db).
format='fulldata_%d_%s_%p_%t'
database ;
}
2) RMAN> show all;
CONFIGURE MAXSETSIZE TO 30720 M;
Here we go so we have the max file size limit of 30g where as my file size is around 32 g.
So to fiz this...
RMAN> CONFIGURE MAXSETSIZE clear;