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;





ORA-27211: Failed to load Media Management Library

ORA-27211: Failed to load Media Management Library


Error description:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on dev1 channel at 12/15/2014 21:14:14
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information: 2

Action:

Make sure media management libraries are installed and the library (libobk.so) is linked under $ORACLE_HOME/lib  to the netbackup library location. (/usr/openv/netbackup/bin/libobk.so64).