Wednesday, April 18, 2012

ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes



You cannot create backups on which you’ve used the keep option in the
FRA. If you want to create backups that have nonstandard retention criteria,
you will have to use a non-FRA location to create them. This often
requires the use of the format parameter, as shown in this example:

backup database format ’/data/backup/%U’ keep until time
”sysdate+300” ;


RMAN> backup database tag=keep_bkp keep until time 'sysdate+300';

Starting backup at 18-APR-12
current log archived

using channel ORA_DISK_1
backup will be obsolete on date 12-FEB-13
archived logs required to recover from this backup will be backed up
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/oratest/datafile/system.256.773672945
input datafile file number=00012 name=/data/tbs/idx_big_01.dbf
input datafile file number=00007 name=/data/tbs/tab_small_01.dbf
input datafile file number=00008 name=/data/tbs/tab_med_01.dbf
input datafile file number=00010 name=/data/tbs/idx_small_01.dbf
input datafile file number=00011 name=/data/tbs/idx_med_01.dbf
channel ORA_DISK_1: starting piece 1 at 18-APR-12
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/18/2012 15:12:27
ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/oratest/datafile/sysaux.257.773672955
channel ORA_DISK_1: starting piece 1 at 18-APR-12
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/18/2012 15:12:28
ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00009 name=/data/tbs/tab_big_01.dbf
input datafile file number=00003 name=+DATA/oratest/datafile/undotbs1.258.773672957
input datafile file number=00004 name=+DATA/oratest/datafile/users.259.773672963
input datafile file number=00006 name=+DATA/oratest/datafile/tab.267.774023547
channel ORA_DISK_1: starting piece 1 at 18-APR-12
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/18/2012 15:12:28
ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/oratest/datafile/example.265.773673233
channel ORA_DISK_1: starting piece 1 at 18-APR-12
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 04/18/2012 15:12:28
ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes

No comments:

Post a Comment