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
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.
No comments:
Post a Comment