ORA-19804: cannot reclaim string bytes disk space from string limit

Problem:

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/02/2013 03:01:58
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 139586437120 limit continuing other job steps, job failed will not be re-run
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_2 channel at 06/02/2013 03:01:58
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 139586437120 limit

Solution:

Increase your db_recovery_file_dest_size parameter.

SQL>alter system set db_recovery_file_dest_size=<size> scope=BOTH

'Both' means,parameter will change memory an spfile.This parameter dynamic parameter.So you can test backup now :)))

Happy Friday:))

ORA-19809: limit exceeded for recovery files

Problem:

Errors in file /home/oracle11g/diag/rdbms/necodb/trace/necodb_arc3_27348.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 790890496 bytes disk space from 4070572032 limit
ARC3: Error 19809 Creating archive log file to '/home/oracle11g/flash_recovery_area/ANKDB/archivelog/2012_09_07/o1_mf_1_9_%u_.arc'

Solution:

increase DB_RECOVERY_FILE_DEST_SIZE(Database recovery files size limit )

alter system set parameter DB_RECOVERY_FILE_DEST_SIZE=integer;

You don't need to restart the instance,this parameter is dynamic:))