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
由於此問題出現在備份過程中，並且報的空間不足，所以首先檢查備份空間設置
SQL> show parameter db_recovery_file_dest
NAME TYPE VALUE
----------------------------------------------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/fast_recovery_area
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
主要原因是因為DB_RECOVERY_FILE_DETS_SIZE=4122M但是這個目錄已經3550M了再備份大約2G的文件無法備份，所以我們要修改此限制即可
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 archived logthread=1 sequence=29 RECID=27 STAMP=877853741
input archived logthread=1 sequence=30 RECID=28 STAMP=877903227
input archived logthread=1 sequence=31 RECID=29 STAMP=877936609
input archived logthread=1 sequence=32 RECID=30 STAMP=877946863
input archived logthread=1 sequence=33 RECID=31 STAMP=878018408
input archived logthread=1 sequence=34 RECID=32 STAMP=878023071
input archived logthread=1 sequence=35 RECID=33 STAMP=878047701
input archived logthread=1 sequence=36 RECID=34 STAMP=878109519
input archived logthread=1 sequence=37 RECID=35 STAMP=878162579
input archived logthread=1 sequence=38 RECID=36 STAMP=878194931
input archived logthread=1 sequence=39 RECID=37 STAMP=878248841
input archived logthread=1 sequence=40 RECID=38 STAMP=878281394
input archived logthread=1 sequence=41 RECID=39 STAMP=878335209
input archived logthread=1 sequence=42 RECID=40 STAMP=878357413
input archived logthread=1 sequence=43 RECID=41 STAMP=878378428
input archived logthread=1 sequence=44 RECID=42 STAMP=878421646
input archived logthread=1 sequence=45 RECID=43 STAMP=878540967
input archived logthread=1 sequence=46 RECID=44 STAMP=878594428
input archived logthread=1 sequence=47 RECID=45 STAMP=878627427
input archived logthread=1 sequence=48 RECID=46 STAMP=878637664
input archived logthread=1 sequence=49 RECID=47 STAMP=878688020
input archived logthread=1 sequence=50 RECID=48 STAMP=878713890
input archived logthread=1 sequence=51 RECID=49 STAMP=878727648
input archived logthread=1 sequence=52 RECID=50 STAMP=878792434
input archived logthread=1 sequence=53 RECID=51 STAMP=878853632
input archived logthread=1 sequence=54 RECID=52 STAMP=878854392
input archived logthread=1 sequence=55 RECID=53 STAMP=878925105
input archived logthread=1 sequence=56 RECID=54 STAMP=878925252
input archived logthread=1 sequence=57 RECID=55 STAMP=878925853
input archived logthread=1 sequence=58 RECID=56 STAMP=878926991
channelORA_DISK_1: starting piece 1 at 05-MAY-15
channelORA_DISK_1: finished piece 1 at 05-MAY-15
piecehandle=/u01/app/oracle/fast_recovery_area/ORACLE007/backupset/2015_05_05/o1_mf_annnn_TAG20150505T191655_bnk9o8p0_.bkptag=TAG20150505T191655 comment=NONE
channelORA_DISK_1: backup set complete, elapsed time: 00:00:35
Finishedbackup at 05-MAY-15
1.使用CONFIGURE RETENTIONPOLICY TO RECOVERY WINDOW命令。
例如：RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 5 DAYS;
我現在的時間是6月11日16:42，如果我設置了上述備份保留策略並進行備份，則該備份在6月16日16:42之後會被標識為廢棄。
2.使用CONFIGURE RETENTION POLICYREDUNDANCY命令。
例如：RMAN>CONFIGURE RETENTION POLICYREDUNDANCY 3;
如果進行了上述設置，當完成三次備份後，在做完第四次備份的時候，第一次備份結果將被標識為廢棄。ORACLE11G默認的備份保留策略是用該方法設置的，且REDUNDANCY為1。可以使用命令CONFIGURE RETENTION POLICY CLEAR恢復策略為默認值。還可以用命令CONFIGURE RETENTION POLICY TO NONE進行策略設置，此時REPORT OBSOLETE和DELETE OBSOLETE將不把任何備份文件視為廢棄。
3.ORACLE備份目錄由db_recovery_file_dest參數設置
4.ORACLE備份目錄由db_recovery_file_dest_size參數設置
