Friday, December 18, 2015

Fix RMAN-03002

If you face ORA-19804 error just increase db_recovery_file_dest_size value

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 12/18/2015 15:10:43

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 12/18/2015 15:10:40
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 214748364800 limit

SQL> set linesize 120  
 SQL> col name for a40  
 \SQL> col type for a40  
 SQL> show parameter db_re  
 NAME                       TYPE         VALUE  
 -------------------------  ---------    ----------------------------  
 db_recovery_file_dest      string       /u01/app/oracle/flash_recovery_area  
 db_recovery_file_dest_size big integer  200G  
 db_recycle_cache_size      big integer  0  

 SQL> alter system set db_recovery_file_dest_size=600G scope=both;  
 System altered.  
That`s all.