RMAN備份時出現ORA-19809: limit exceeded for recovery files

we6100發表於2014-04-04
MIT
RMAN>  backup database plus archivelog delete input; 
.
.
.
channel ORA_DISK_1: starting piece 1 at 04-APR-14
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/04/2014 14:53:41
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 2147483648 limit
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 04-APR-14
channel ORA_DISK_1: finished piece 1 at 04-APR-14
piece handle=/u01/app/oracle/flash_recovery_area/JIAGULUN/backupset/2014_04_04/o1_mf_ncsnf_TAG20140404T142449_9mwoqzjq_.bkp tag=TAG20140404T142449 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:09
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 04/04/2014 14:53:55

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/04/2014 14:53:41
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 2147483648 limit

原因：flash_recovery_area空間不足

檢查flash_recovery_area使用情況
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
------------------------ ---------- ----------- ----------
CONTROLFILE                     .33           0          1
ONLINELOG                      7.32           0          3
ARCHIVELOG                        0           0          0
BACKUPPIECE                    1.05           0          2
IMAGECOPY                         0           0          0
FLASHBACKLOG                      0           0          0
6 rows selected.

檢查db_recovery_file_dest_size引數
SQL> show parameter db_recovery_file_dest_size

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
db_recovery_file_dest_size           big integer            2G（預設）

將引數db_recovery_file_dest_size增大為10G
SQL> alter system set db_recovery_file_dest_size=10G scope=both;
System altered.

再次備份，成功
RMAN>  backup database plus archivelog delete input; 


Starting backup at 04-APR-14
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=98 recid=2 stamp=844012417
channel ORA_DISK_1: starting piece 1 at 04-APR-14
channel ORA_DISK_1: finished piece 1 at 04-APR-14
piece handle=/u01/app/oracle/flash_recovery_area/JIAGULUN/backupset/2014_04_04/o1_mf_annnn_TAG20140404T155339_9mws87oo_.bkp tag=TAG20140404T155339 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/home/oracle/arch/1_98_778070496.dbf recid=2 stamp=844012417
Finished backup at 04-APR-14

Starting backup at 04-APR-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00002 name=/u01/app/oracle/oradata/JIAGULUN/datafile/o1_mf_undotbs1_7p5b155m_.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/JIAGULUN/datafile/o1_mf_users_7p5b157q_.dbf
input datafile fno=00001 name=/u01/app/oracle/oradata/JIAGULUN/datafile/o1_mf_system_7p5b14xs_.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/JIAGULUN/datafile/o1_mf_sysaux_7p5b14yl_.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/JIAGULUN/datafile/o1_mf_example_7p5b3r36_.dbf
channel ORA_DISK_1: starting piece 1 at 04-APR-14
channel ORA_DISK_1: finished piece 1 at 04-APR-14
piece handle=/u01/app/oracle/flash_recovery_area/JIAGULUN/backupset/2014_04_04/o1_mf_nnndf_TAG20140404T155352_9mws8m8v_.bkp tag=TAG20140404T155352 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:29:58
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 04-APR-14
channel ORA_DISK_1: finished piece 1 at 04-APR-14
piece handle=/u01/app/oracle/flash_recovery_area/JIAGULUN/backupset/2014_04_04/o1_mf_ncsnf_TAG20140404T155352_9mwv12gj_.bkp tag=TAG20140404T155352 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 04-APR-14

Starting backup at 04-APR-14
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=99 recid=3 stamp=844014253
channel ORA_DISK_1: starting piece 1 at 04-APR-14
channel ORA_DISK_1: finished piece 1 at 04-APR-14
piece handle=/u01/app/oracle/flash_recovery_area/JIAGULUN/backupset/2014_04_04/o1_mf_annnn_TAG20140404T162415_9mwv1kbm_.bkp tag=TAG20140404T162415 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/home/oracle/arch/1_99_778070496.dbf recid=3 stamp=844014253
Finished backup at 04-APR-14


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/27500440/viewspace-1136208/，如需轉載，請註明出處，否則將追究法律責任。

相關文章