备份遇到RMAN-03009,ORA-19809,ORA-19804
来源:互联网 发布:熊猫主播真实收入算法 编辑:程序博客网 时间:2024/05/22 15:58
今天做实验想备份全库,随手输入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-03009,ORA-19809,ORA-19804
- RMAN-03009 ORA-19809 ORA-19804
- oracle rman备份与ORA-19504&ORA-27040&RMAN-03009
- RMAN备份时ORA-19809错误
- 恢复RMAN备份时遇到ORA-01180错误
- oracle数据库备份出现错误:RMAN-03002 ORA-19809 ORA-19804
- RMAN备份遭遇ORA-235
- rman备份出现ORA-19625
- rman备份出现ORA-19625
- rman备份出现ORA-19625
- rman 备份出现ORA-00245/RMAN-08132
- RMAN备份失败 RMAN-06059 ORA-19625
- RMAN备份控制文件错误,RMAN-03009,ORA-19504,ORA-27040
- ORACLE rman备份报错之RMAN-03009&ORA-19587&ORA-27072
- RMAN备份时遇到要求重建standard包的错误 ORA-06554 RMAN-04015
- RMAN-03009 & ORA-17628
- RMAN-03009,ORA-00230
- RMAN-03009 ORA-15028
- 在函数后面加 const
- Android小知识8
- Unix网络编程学习笔记之第12章 IPv4与IPv6的互操作性
- Bootstrap.initClassLoaders
- IOS ARC 和 非ARC 之间的转换方法
- 备份遇到RMAN-03009,ORA-19809,ORA-19804
- Android中的Thread与AsyncTask的区别
- Android 布局之GridLayout
- 检索android是否安装某个APP
- MySQL INTO OUTFILE导出导入数据|mysqldump
- Redis与Memcached的区别
- mPDF中文乱码的解决方式 php
- Android----SpannableString
- Android中获取不同语言目录下的字符串