备份遇到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


数据库备份成功了

0 0
原创粉丝点击