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 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
1.1.1.3 出现问题的原因
主要原因是因为DB_RECOVERY_FILE_DETS_SIZE=4122M但是这个目