1.1.1RMAN备份报错
1.1.1.1 问题及现象
channelORA_DISK_1: starting piece 1 at 05-MAY-15
RMAN-00571:===========================================================
RMAN-00569:=============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571:===========================================================
RMAN-03009:failure of backup command on ORA_DISK_1 channel at 05/05/2015 18:04:14
ORA-19809:limit exceeded for recovery files
ORA-19804:cannot reclaim 2104777216 bytes disk space from 4322230272 limit
1.1.1.2 检查思路
由于此问题出现在备份过程中，并且报的空间不足，所以首先检查备份空间设置
SQL> show parameter db_recovery_file_dest
NAME? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? TYPE? ? ? ? VALUE
----------------------------------------------- ------------------------------
db_recovery_file_dest_size? ? ? ? ? big integer 4122M
然后
[oracle@oracle ~]$ du -sm/u01/app/oracle/fast_recovery_area
3550? ? /u01/app/oracle/fast_recovery_area
1.1.1.3 出现问题的原因
主要原因是因为DB_RECOVERY_FILE_DETS_SIZE=4122M但是这个目录已经3550M了再备份大约2G的文件无法备份，所以我们要修改此限制即可
1.1.1.4 解决方法
RMAN> configure retention policy torecovery window of 7 days;
new RMANconfiguration parameters:
CONFIGURERETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMANconfiguration parameters are successfully stored
RMAN> configure retention policy toredundancy 3;
old RMANconfiguration parameters:
CONFIGURERETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMANconfiguration parameters:
CONFIGURERETENTION POLICY TO REDUNDANCY 3;
SQL> alter system setdb_recovery_file_dest_size=7g scope=both;
?
Systemaltered.
RMAN> backuparchivelog all;
?
Starting backup at05-MAY-15
using targetdatabase control file instead of recovery catalog
allocated channel:ORA_DISK_1
channelORA_DISK_1: SID=38 device type=DISK
channelORA_DISK_1: starting archived log backup set
channelORA_DISK_1: specifying archived log(s) in backup set
input archived logthread=1 sequence=5 RECID=3 STAMP=876780457
input archived logthread=1 sequence=6 RECID=4 STAMP=876789433
input archived logthread=1 sequence=7 RECID=5 STAMP=876830426
input archived logthread=1 sequence=8 RECID=6 STAMP=876866886
input archived logthread=1 sequence=9 RECID=7 STAMP=876950671
input archived logthread=1 sequence=10 RECID=8 STAMP=876992432
input archived logthread=1 sequence=11 RECID=9 STAMP=877039260
input archived logthread=1 sequence=12 RECID=10 STAMP=877168856
input archived logthread=1 sequence=13 RECID=11 STAMP=877212093
input archived logthread=1 sequence=14 RECID=12 STAMP=877298424
input archived logthread=1 sequence=15 RECID=13 STAMP=877316417
input archived logthread=1 sequence=16 RECID=14 STAMP=877356610
input archived logthread=1 sequence=17 RECID=15 STAMP=877406439
input archived logthread=1 sequence=18 RECID=16 STAMP=877428082
input archived logthread=1 sequence=19 RECID=17 STAMP=877471303
input archived logthread=1 sequence=20 RECID=18 STAMP=877504314
input archived logthread=1 sequence=21 RECID=19 STAMP=877557626
input archived logthread=1 sequence=22 RECID=20 STAMP=877590777
input archived logthread=1 sequence=23 RECID=21 STAMP=877644039
input archived logthread=1 sequence=24 RECID=22 STAMP=877676461
input archived logthread=1 sequence=25 RECID=23 STAMP=877701616
input archived logthread=1 sequence=26 RECID=24 STAMP=877730463
input archived logthread=1 sequence=27 RECID=25 STAMP=877770046
input archived logthread=1 sequence=28 RECID=26 STAMP=877816841
input archi