ora-19809: limit exceeded for recovery files

来源:互联网 发布:数据采集厂家 编辑:程序博客网 时间:2024/05/01 20:07

错误代码:

ora-19809: limit exceeded for recovery files

错误原因:

闪回恢复区flash_recovery_area目录容量已满


解决方法:

1. 设置归档到其他目录,修改alter system set log_archive_dest = 其他目录 

2. 转移或删除闪回恢复区里的归档日志 

3. 缩短备份保留时间,改为较小的保留期

change the backup retention policy to retain the backups for a smaller period of time

4. 增大闪回恢复区。alter system set db_recovery_file_dest_size = 5g

原创粉丝点击