ORA-19815: WARNING: db_recovery_file_dORA-00257: archiver error. Connect internal only, until freed.

前方工程师反映说登录系统报错,页面中的日志:

org.apache.tapestry5.runtime.ComponentEventException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection [at classpath:com/zte/eas/ui/pages/eas/Login.tml, line 27] at org.apache.tapestry5.internal.structure.ComponentPageElementImpl.triggerContextEvent(ComponentPageElementImpl.java:1105) at org.apache.tapestry5.internal.services.ComponentEventRequestHandlerImpl.handle(ComponentEventRequestHandlerImpl.java:75) at 


查看后台日志:

ERROR 09:14:15 {admin}ORA-00257: archiver error. Connect internal only, until freed.


ERROR 09:14:15 {admin}request path : /eas/Login.form, org.apache.tapestry5.runtime.ComponentEventException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection [at classpath:com/zte/eas/ui/pages/eas/Login.tml, line 27]^M
    at org.apache.tapestry5.internal.structure.ComponentPageElementImpl.triggerContextEvent(ComponentPageElementImpl.java:1105)^M
    at org.apache.tapestry5.internal.services.ComponentEventRequestHandlerImpl.handle(ComponentEventRequestHandlerImpl.java:75)^M


查看数据库alert日志:

Errors in file /bee/app/ora11/diag/rdbms/eas/EAS/trace/EAS_arc1_3450.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 4070572032 bytes is 100.00% used, and has 0 remaining bytes available.
************************************************************************
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 /bee/app/ora11/diag/rdbms/eas/EAS/trace/EAS_arc1_3450.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 35863040 bytes disk space from 4070572032 limit
ARC1: Error 19809 Creating archive log file to '/bee/app/ora11/flash_recovery_area/EAS/archivelog/2014_07_30/o1_mf_1_123_%u_.arc'

有以下处理方法:

1 alter system set db_recovery_file_dest_size=20G scope=both;
2 修改日志归档路径,指向另外的地方。
3 备份日志后删除之。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值