ORA-19809: limit exceeded for recovery files 處理

在做rman backup試驗的時候如下:
[oracle@croracle01 ~]$ rman target / Recovery Manager: Release 11.1.0.6.0 - Production on Tue Jun 23 18:26:39 2009 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: CRPROD (DBID=1130088604) RMAN> list backupset; using target database control file instead of recovery catalog RMAN> backup database; Starting backup at 23-JUN-09 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=142 instance=crprod1 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=00002 name=+CRPROD_DATA/crprod/datafile/sysaux.260.686193539 input datafile file number=00001 name=+CRPROD_DATA/crprod/datafile/system.259.686193501 input datafile file number=00003 name=+CRPROD_DATA/crprod/datafile/undotbs1.261.686193551 input datafile file number=00006 name=+CRPROD_DATA/crprod/datafile/undotbs3.268.686702841 input datafile file number=00007 name=+CRPROD_DATA/crprod/datafile/undotbs4.271.687230073 input datafile file number=00004 name=+CRPROD_DATA/crprod/datafile/undotbs2.263.686193591 input datafile file number=00005 name=+CRPROD_DATA/crprod/datafile/users.264.686193611 channel ORA_DISK_1: starting piece 1 at 23-JUN-09 RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/23/2009 18:41:44 ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim 53477376 bytes disk space from 2147483648 limit continuing other job steps, job failed will not 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 23-JUN-09 channel ORA_DISK_1: finished piece 1 at 23-JUN-09 piece handle=+FLASH_RECOVERY_AREA/crprod/backupset/2009_06_23/ncsnf0_tag20090623t182731_0.267.690316919 tag=TAG20090623T182731 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/23/2009 18:41:44 ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim 53477376 bytes disk space from 2147483648 limit
RMAN>

處理辦法:
SQL> show parameter db_recovery_file_dest

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +FLASH_RECOVERY_AREA
db_recovery_file_dest_size big integer 2G
SQL>

SQL> alter system set db_recovery_file_dest_size=4g;

System altered.

SQL> quit

[oracle@croracle01 ora_arch]$ rman target /

Recovery Manager: Release 11.1.0.6.0 - Production on Tue Jun 23 19:01:41 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: CRPROD (DBID=1130088604)

RMAN> backup database;

Starting backup at 23-JUN-09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=130 instance=crprod1 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=00002 name=+CRPROD_DATA/crprod/datafile/sysaux.260.686193539
input datafile file number=00001 name=+CRPROD_DATA/crprod/datafile/system.259.686193501
input datafile file number=00003 name=+CRPROD_DATA/crprod/datafile/undotbs1.261.686193551
input datafile file number=00006 name=+CRPROD_DATA/crprod/datafile/undotbs3.268.686702841
input datafile file number=00007 name=+CRPROD_DATA/crprod/datafile/undotbs4.271.687230073
input datafile file number=00004 name=+CRPROD_DATA/crprod/datafile/undotbs2.263.686193591
input datafile file number=00005 name=+CRPROD_DATA/crprod/datafile/users.264.686193611
channel ORA_DISK_1: starting piece 1 at 23-JUN-09
channel ORA_DISK_1: finished piece 1 at 23-JUN-09
piece handle=+FLASH_RECOVERY_AREA/crprod/backupset/2009_06_23/nnndf0_tag20090623t190153_0.268.690318119 tag=TAG20090623T190153 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:11:16
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 23-JUN-09
channel ORA_DISK_1: finished piece 1 at 23-JUN-09
piece handle=+FLASH_RECOVERY_AREA/crprod/backupset/2009_06_23/ncsnf0_tag20090623t190153_0.269.690318809 tag=TAG20090623T190153 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 23-JUN-09

RMAN>
SQL> show parameter recovery

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/ora_arch
db_recovery_file_dest_size big integer 4G
recovery_parallelism integer 0
SQL>