ORA-19809/ORA-19809: limit exceeded for recovery files 问题处理
来源:互联网 发布:情侣定位软件 编辑:程序博客网 时间:2024/04/28 21:41
今天又遇到了这个问题,alert 日志中的报错信息如下:
其实问题的原因很简单,放归档的 fra 空间满了,导致无法归档,进而oracle挂起,注意这里db_recovery_file_dest 只是一个逻辑上的限制 ,可能放fra的目录还有空间剩余,但是oracle不会去用。平时还是要多多关注fra的使用情况。可以使用v$flash_recovery_area_usage 来查看fra的使用情况。
解决方法:
rman>crosscheck archivelog all;
rman>delete expired archivelog all;
alert.log:
************************************************************************
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_arc1_7088.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 13112320 bytes disk space from 4102029312 limit
ARC1: Error 19809 Creating archive log file to 'D:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2013_09_12\O1_MF_1_1750_%U_.ARC'
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_7072.trc:
ORA-19815: 警告: db_recovery_file_dest_size 字节 (共 4102029312 字节) 已使用 100.00%, 尚有 0 字节可用。
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_7072.trc:
ORA-19809: 超出了恢复文件数的限制
ORA-19804: 无法回收 13112320 字节磁盘空间 (从 4102029312 限制中)
ARCH: Error 19809 Creating archive log file to 'D:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2013_09_12\O1_MF_1_1750_%U_.ARC'
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_7072.trc:
ORA-16038: 日志 1 sequence# 1750 无法归档
ORA-19809: 超出了恢复文件数的限制
ORA-00312: 联机日志 1 线程 1: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG'
USER (ospid: 7072): terminating the instance due to error 16038
Thu Sep 12 10:43:03 2013
Instance terminated by USER, pid = 7072
- ORA-19809: limit exceeded for recovery files
- ORA-19809: limit exceeded for recovery files
- ora-19809: limit exceeded for recovery files
- ORA-19809/ORA-19809: limit exceeded for recovery files 问题处理
- ORA-19815,ORA-19809 :limit exceeded for recovery files
- ORA-19809: limit exceeded for recovery files问题解决
- DBCA出错:ORA-19809: limit exceeded for recovery files处理过程
- ora-02391:exceeded simultaneous sessions_per_user limit
- ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
- ORA-19566: exceeded limit of 0 corrupt blocks for file +DATA/datafile/undotbs2.260.842548839
- ORA-01536: space quota exceeded for tablespace
- ORA-01536: space quota exceeded for tablespace
- ORA-19566: exceeded limit of 0 corrupt blocks for file /u01/app/oracle/oradata/PROD1/example01.dbf
- ORA-16038、ORA-19809、ORA-00312问题的学习总结
- ORA-19809&&ORA-03113
- ORA-16038 问题处理
- ORA-16038 问题处理
- ORA-16038 问题处理
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- 2013.9.11 美团网面试题
- CodeIgniter自定义配置文件
- Android ListView的图片会不见
- Java菜鸟学习笔记--IDE篇(一):ubuntu下eclipse安装配置
- ORA-19809/ORA-19809: limit exceeded for recovery files 问题处理
- Kgdb And Qemu
- 25个增强iOS应用程序性能的提示和技巧(初级篇)
- js 实现清空table里的值但不改变table结构
- 单链表逆序详解
- Linux sqlite3基本命令
- Java的远程调用
- apt-get remove 与 apt-get autoremove、aptitude remove的不同
- 2013/9/13