错误代码:
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