ORA-19809: limit exceeded for recovery files

     今天一個同事在客戶那用rman備份資料庫時,

connect target ;
connect catalog rman/rman@abcdefg
 run
 {
 allocate channel t1 type 'sbt_tape'
 parms 'ENV=(NSR_SERVER=backup_server)';

 set limit channel t1 kbytes = 10000000;  #limit file size to 10GB

 sql 'alter system archive log current';

#backup archivelog all
#backup archivelog from time 'sysdate-1'
 backup archivelog like '/Suplis/archive_sde/1_%'
 format 'arch_%t_%s_%p'
#skip inaccessible
 delete input;

 release channel t1;
}

報以下錯

channel ORA_DISK_1: starting piece 1 at 16-APR-09
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/16/2009 09:47:25
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 3031623680 bytes disk space from 2147483648 limit
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set

 

主要是ORA-19809: limit exceeded for recovery files錯誤

預設放在閃回區下,而且閃回區只有2G大小,而需要備份的資料庫有3G多大

有兩個解決方法:

1.增加閃回區大小

2.備份放到別的檔案系統中,不放到閃回區