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.

重启数据库

原文地址:https://www.cnblogs.com/Andy-Li/p/8873056.html