备份遇到RMAN-03009,ORA-19809,ORA-19804

原创 2015年07月09日 17:26:06

今天做实验想备份全库,随手输入backup database发现RMAN居然报错


RMAN> backup database;

Starting backup at 09-JUL-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=47 instance=racdb0071 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=+DATA0/racdb007/datafile/sysaux.257.870219453
input datafile file number=00001 name=+DATA0/racdb007/datafile/system.256.870219453
input datafile file number=00003 name=+DATA0/racdb007/datafile/undotbs1.258.870219453
input datafile file number=00005 name=+DATA0/racdb007/datafile/undotbs2.261.870219715
input datafile file number=00006 name=+DATA/racdb007/datafile/mcontactbiz_data.289.870977391
input datafile file number=00007 name=+DATA/racdb007/datafile/t1.574.876421851
input datafile file number=00008 name=+DATA/racdb007/datafile/cat_tablespace.674.878856551
input datafile file number=00004 name=+DATA0/racdb007/datafile/users.259.870219453
channel ORA_DISK_1: starting piece 1 at 09-JUL-15
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/09/2015 23:46:14
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 68157440 bytes disk space from 4558159872 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 09-JUL-15
channel ORA_DISK_1: finished piece 1 at 09-JUL-15
piece handle=+DATA/racdb007/backupset/2015_07_09/ncsnf0_tag20150709t234428_0.893.884648779 tag=TAG20150709T234428 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================


RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/09/2015 23:46:14
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 68157440 bytes disk space from 4558159872 limit


后来经过三哥指点,原来ORACLE通过RMAN备份的时候不指定format会默认备份到db_recovery_file_dest中

然后果断使用


RMAN> backup database format '+DATA/racdb007/BACKUPSET/%u.bak';


Starting backup at 10-JUL-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=67 instance=racdb0071 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=+DATA0/racdb007/datafile/sysaux.257.870219453
input datafile file number=00001 name=+DATA0/racdb007/datafile/system.256.870219453
input datafile file number=00003 name=+DATA0/racdb007/datafile/undotbs1.258.870219453
input datafile file number=00005 name=+DATA0/racdb007/datafile/undotbs2.261.870219715
input datafile file number=00006 name=+DATA/racdb007/datafile/mcontactbiz_data.289.870977391
input datafile file number=00007 name=+DATA/racdb007/datafile/t1.574.876421851
input datafile file number=00008 name=+DATA/racdb007/datafile/cat_tablespace.674.878856551
input datafile file number=00004 name=+DATA0/racdb007/datafile/users.259.870219453
channel ORA_DISK_1: starting piece 1 at 10-JUL-15
channel ORA_DISK_1: finished piece 1 at 10-JUL-15
piece handle=+DATA/racdb007/backupset/0gqblc8v.bak tag=TAG20150710T001110 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:25
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 10-JUL-15
channel ORA_DISK_1: finished piece 1 at 10-JUL-15
piece handle=+DATA/racdb007/backupset/0hqblcdh.bak tag=TAG20150710T001110 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 10-JUL-15


数据库备份成功了

RMAN ORA-19804: cannot reclaim 3838464 bytes disk space from 2147483648 limit

在用rman 测试恢复的时候遇到 ORA-19804: cannot reclaim 3838464 bytes disk space from 2147483648 limit   原来是归档...
  • lwei_998
  • lwei_998
  • 2011年10月10日 19:14
  • 3538

ORA-19809: 超出了恢复文件数的限制

ORA-19809: 超出了恢复文件数的限制 一、故障现象: RMAN> backup database; 启动 backup 于 05-10月-14 使用目标数据库控制文件替代恢复目...
  • liu3348
  • liu3348
  • 2014年05月13日 00:12
  • 1288

ORA-19809: 超出了恢复文件数的限制解决

问题: ORACLE 10g数据库突然无法使用,报 “ORA-19809: 超出了恢复文件数的限制”错误。 分析: 经过查阅相关资料,该问题应为db_recovery_file_de...
  • hongweigg
  • hongweigg
  • 2016年06月16日 17:08
  • 765

RMAN-20039: 设置双工模式时格式中需要有 %c 解决办法

oracle数据库在做rman备份时,如果要产生多份拷贝备份集,我运行命令: RMAN>  BACKUP COPIES 3 DATABASE; RMAN> BACKUP COPIES 3 DA...
  • hufeng719
  • hufeng719
  • 2017年06月04日 11:05
  • 220

闪回恢复区大小不够。报ORA-19809、ORA-19804

问题: 闪回恢复区大小不够,rman默认备份路径报错。 RMAN> backup database; Starting backup at 01-DEC-14 using target datab...
  • zhang123456456
  • zhang123456456
  • 2017年01月01日 14:10
  • 231

ORA-19809: 超出了恢复文件数的限制 ORA-19804: 无法回收 42991616 字节磁盘空间 (从 314572800 限制中)

Rac环境下,启动数据库时候提示以下错误: [grid@RAC1 ~]$ srvctl  start database -d racdb PRCR-1079 : 无法启动资源 ora.racdb....
  • u013660039
  • u013660039
  • 2014年02月14日 13:28
  • 1843

oracle rman备份恢复报错处理10例

1.在生产数据库上执行,报RMAN-20004错: RMAN> list backup of datafile 41; RMAN-00571: ============================...
  • zengxuewen2045
  • zengxuewen2045
  • 2016年07月28日 13:50
  • 1735

ORA-19809 闪回区没空间导致数据库不能响应

在一台Windows上安装了一个测试
  • Neetgo
  • Neetgo
  • 2014年04月29日 17:19
  • 467

ORA-19809: 超出了恢复文件数的限制故障处理实例

SQL> startup ORACLE instance started. Total System Global Area  263049216 bytes Fixed Size       ...
  • fly43108622
  • fly43108622
  • 2015年12月23日 16:09
  • 270

rman创建备库报错问题处理记录

报错1: [oracle@dgcrm ~]$ rman target sys/123456@CRM auxiliary sys/123456@DGCRM Recovery Manager:...
  • techsupporter
  • techsupporter
  • 2017年02月24日 09:54
  • 1189
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:备份遇到RMAN-03009,ORA-19809,ORA-19804
举报原因:
原因补充:

(最多只允许输入30个字)