RMAN备份时出现ORA-19809: limit exceeded for recovery files?

RMAN备份时出现ORA-19809: limit exceeded for recovery files?

  报错：

RMAN> backup tablespace users format='/data/rman/users01.bak';

Starting backup at 2016-10-28 09:27:32

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=134 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=00004 name=/u01/oradata/timran11g/users01.dbf

channel ORA_DISK_1: starting piece 1 at 2016-10-28 09:27:38

channel ORA_DISK_1: finished piece 1 at 2016-10-28 09:27:39

piece handle=/data/rman/users01.bak tag=TAG20161028T092732 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 2016-10-28 09:27:39
 

Starting Control File and SPFILE Autobackup at 2016-10-28 09:27:39

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 10/28/2016 09:27:46

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 10928128 bytes disk space from 2147483648 limit

原因：flash_recovery_area空间不足

解决方法：

1）  检查flash_recovery_area使用情况：

SQL> select file_type, percent_space_used as used,percent_space_reclaimable as reclaimable,number_of_files as "number" from v$flash_recovery_area_usage;

FILE_TYPE               USED      RECLAIMABLE     number

--------------------     ----------       -----------       ----------

CONTROL FILE               0           0          0

REDO LOG                   0           0          0

ARCHIVED LOG           99.94           0         44

BACKUP PIECE                0          0          0

IMAGE COPY                 0           0          0

FLASHBACK LOG             0           0          0

FOREIGN ARCHIVED LOG     0           0          0

7 rows selected.

2）  检查db_recovery_file_dest_size参数

SQL> show parameter db_recovery_file_dest_size

NAME                           TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest_size        big integer    2G（默认）

3）  将参数db_recovery_file_dest_size增大为6G
SQL> alter system set db_recovery_file_dest_size=6G scope=both;
System altered.

4）  再次备份即可成功。

注释：在闪回恢复区中的空间使用超过 85% 的时候，数据库将会向 alert 文件中写入告警信息；而当超过 97% 的时候将会写入严重告警信息。当闪回恢复区空间不够的时候，
Oracle将报告如下类似的错误：
        ORA-19809: limit exceeded for recovery files

  ORA-19804: cannot reclaim 52428800 bytes disk space from 1258291200 limit.

提示：本文为个人学习过程中遇到问题的解决方法，仅供参考，如有任何问题，请指出。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31378892/viewspace-2128139/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31378892/viewspace-2128139/