The Flash recovery area is not large enough. Newspaper ORA-19809, ORA-19804

Problem: The Flash recovery area is not large enough, rman default backup path error.
rman> backup Database;


Starting backup at 01-dec-14
Using target database control file instead of recovery catalog
Allocated Channel:ora_disk_1
Channel ora_disk_1:sid=39 Device Type=disk
Channel ora_disk_1:starting full DataFile backup set
Channel ora_disk_1:specifying DataFile (s) in backup set
Input datafile file number=00006 name=/home/oracle/app/oradata/orcl/ogg01.dbf
Input datafile file number=00001 name=/home/oracle/app/oradata/orcl/system01.dbf
Input datafile file number=00002 name=/home/oracle/app/oradata/orcl/sysaux01.dbf
Input datafile file number=00005 name=/home/oracle/app/oradata/orcl/tbtb01.dbf
Input datafile file number=00003 name=/home/oracle/app/oradata/orcl/undotbs01.dbf
Input datafile file number=00004 name=/home/oracle/app/oradata/orcl/users01.dbf
Channel ora_disk_1:starting piece 1 at 01-dec-14
Rman-03009:failure of Backup command on Ora_disk_1 channel at 12/01/2014 06:43:49
Ora-19809:limit exceeded for recovery files
Ora-19804:cannot Reclaim 52428800 bytes disk space from 2147483648 limit
Continuing other job steps, job failed won't be re-run
Channel ora_disk_1:starting full DataFile backup set
Channel ora_disk_1:specifying DataFile (s) in backup set
Including current control file in backup set
Including current SPFILE in backup set
Channel ora_disk_1:starting piece 1 at 01-dec-14
Channel ora_disk_1:finished piece 1 at 01-dec-14
Piece handle=/home/oracle/app/flash_recovery_area/orcl/backupset/2014_12_01/o1_mf_ncsnf_tag20141201t064122_ B7RO3PT5_.BKP tag=tag20141201t064122 Comment=none
Channel Ora_disk_1:backup set complete, elapsed time:00:00:02
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE, STACK follows ===============
RMAN-00571: ===========================================================


Rman-03009:failure of Backup command on Ora_disk_1 channel at 12/01/2014 06:43:49
Ora-19809:limit exceeded for recovery files
Ora-19804:cannot Reclaim 52428800 bytes disk space from 2147483648 limit


Cause: The flash recovery area is not large enough
oracle10g,11g by default, archived logs are saved in the Flashback recovery area, and if you use the default settings when you build the library,
The flashback recovery area should be 2G, not enough space, no backup. (Similarly, archived log storage may also encounter this problem, resulting in no more archiving)
Solve:
(1) Adjust the size of the Add flash back area
(2) Replace the backup directory with a different path.
If an error is archived, set the archive directory to a different directory, modify alter system set Log_archive_dest = Other path
Steps:


1. View Db_recovery_file_dest Size
Sql> Show parameter recover


NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
Db_recovery_file_dest String/home/oracle/app/flash_recover
Y_area
Db_recovery_file_dest_size Big Integer 2G
Recovery_parallelism Integer0


2. Check the Flash Recovery area usage
Sql> Select File_type, percent_space_used as used,percent_space_reclaimable as reclaimable, number_of_files as " Number "from V$flash_recovery_area_usage;


File_type used reclaimable number
-------------------- ---------- ----------- ----------
CONTROL FILE 0 0 0
REDO LOG 0 0 0
Archived LOG 46.76 0 23
BACKUP PIECE. 46 0 1
IMAGE COPY 0 0 0
FLASHBACK LOG 0 0 0
3. Extended Db_recovery_file_dest Size
Sql> alter system set DB_RECOVERY_FILE_DEST_SIZE=10G Scope=both;


System altered.


4. Use the Run batch script to specify the backup path to back up (we recommend that the archive be placed separately from the backup)
run{
Allocate channel CH1 type disk;
Allocate channel CH2 type disk;
Backup incremental Level 0 database plus Archivelog Delete input
Format '/home/oracle/rmanbak/db_%d_%u '
Tag=db_inc_0;
Release channel CH1;
Release channel CH2;
}


Allocated Channel:ch1
。。。。。。
Released Channel:ch1
Released CHANNEL:CH2

The Flash recovery area is not large enough. Newspaper ORA-19809, ORA-19804