Oracle RMAN备份数据库时出现ORA-19809: limit exceeded for recovery files

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:1174

Oracle RMAN备份数据库时出现ORA-19809: limit exceeded for recovery files

用rman备份数据库时,
connect target sys/abcdefg@abcdefg;
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.备份放到别的文件系统中,不放到闪回区

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】