RMAN備份時ORA-19809錯誤

1、全量備份database，且備份類型指定為backupset

RMAN> backup as backupset database;

Starting backup at 13-FEB-14
using channel ORA_DISK_1
.....

2、再次備份users資料表空間，且備份類型指定為backupset

RMAN> backup as backupset device type disk  tablespace users;

Starting backup at 13-FEB-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/home/Oracle/app/oradata/ora11g/users01.dbf
channel ORA_DISK_1: starting piece 1 at 13-FEB-14
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/13/2014 14:01:16
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 2147483648 limit

3、分析如上報錯，超過恢複檔案限制

SQL> show parameter db_recovery
NAME        TYPE  VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest      string  /home/oracle/app/flash_recover
      y_area
db_recovery_file_dest_size      big integer 2G
檢查恢複檔案上限設定，當前為2G

4、再檢查恢複空間當前使用了多少
oracle@linux:~/app/flash_recovery_area> du -sm *
2010 ORA11G
已接近最大限制2G，故上述失敗可能是由於目標備份檔案產生的大小超過2048-2010,38M

5、重新指定retention策略，防止archivelog繼續增加
RMAN> configure retention policy to recovery window of 7 days;

old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMAN configuration parameters are successfully stored

RMAN> configure retention policy to redundancy 3;

old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
new RMAN configuration parameters are successfully stored

6、修改db_recovery_file_dest_size大小
SQL> alter system set db_recovery_file_dest_size=4g scope=both;

System altered.

7、再次備份users資料表空間
RMAN> backup as backupset device type disk  tablespace users;

Starting backup at 13-FEB-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/home/oracle/app/oradata/ora11g/users01.dbf
channel ORA_DISK_1: starting piece 1 at 13-FEB-14
......

推薦閱讀：

RMAN 配置歸檔日誌刪除策略

Oracle基礎教程之通過RMAN複製資料庫

RMAN備份策略制定參考內容

RMAN備份學習筆記

OracleDatabase Backup加密 RMAN加密