RMAN-03009 ORA-19809 ORA-19804

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/17/2014 05:14:13

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 53477376 bytes disk space from 4259315712 limit

解决：

这是flash_recovery_area空间不足的提示

SQL> show parameter db_recover

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
db_recovery_file_dest                string                 /u/oracle/product/recovery_are
                                                            a
db_recovery_file_dest_size           big integer            3882M

SQL> alter system set db_recovery_file_dest_size = 10g scope = both;

已更改系統.

SQL> show parameter db_recover

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/17/2014 05:14:13

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 53477376 bytes disk space from 4259315712 limit

解决：

这是flash_recovery_area空间不足的提示

SQL> show parameter db_recover

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
db_recovery_file_dest                string                 /u/oracle/product/recovery_are
                                                            a
db_recovery_file_dest_size           big integer            3882M

SQL> alter system set db_recovery_file_dest_size = 10g scope = both;

已更改系統.

SQL> show parameter db_recover