重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: ORA-19809：limit exceeded for recovery files [打印本页]
作者: ZhangQi    时间: 2025-6-27 19:13
标题: ORA-19809：limit exceeded for recovery files
本帖最后由 ZhangQi 于 2025-6-27 19:15 编辑

案例：
2025-05-24T22:18:37.827116+08:00 Errors in file /u01/app/oracle/diag/rdbms/lisdb/lisdb/trace/lisdb_tt00_3271.trc: ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim 2147483648 bytes disk space from 53687091200 bytes limit 2025-05-24T22:19:37.828647+08:00 Errors in file /u01/app/oracle/diag/rdbms/lisdb/lisdb/trace/lisdb_tt00_3271.trc: ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim 2147483648 bytes disk space from 53687091200 bytes limit
2025-05-24T22:20:37.829665+08:00 Errors in file /u01/app/oracle/diag/rdbms/lisdb/lisdb/trace/lisdb_tt00_3271.trc: ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim 2147483648 bytes disk space from 53687091200 bytes limit

分析：
ORA-19809: 恢复文件超出限制
ORA-19804: 无法从 53687091200 字节的限制中回收 2147483648 字节的磁盘空间


如果磁盘空间还够，原因很有可能是归档日志设置在快速恢复区导致的，即db_recovery_file_dest 这个参数是设置快速恢复区的，不是设置归档位置，建议对归档日志文件单独设置，否则容易出现实际文件系统有空间，但数据库挂起的问题，如下所示


17865685e7b894c8ea.png
登录/注册后可看大图