Oracle recovery manager failed to restore

解决办法:

1:清理过期失效的备份,

2:增加recovery_file_dest_size参数值即可;


SQL> show parameter db_recover

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /oracle/flash_recovery_area
db_recovery_file_dest_size           big integer 2G
SQL> alter system set db_recovery_file_dest_size=4G scope=spfile;

System altered.

重启数据库

posted @ 2018-04-18 11:24  Andy·Li  阅读(427)  评论(0编辑  收藏  举报