Monday, December 15, 2014

RMAN-06183: datafile or datafile copy xxxx_data_01.dbf (file number 9) larger than MAXSETSIZE

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.

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;





No comments:

Post a Comment