登录  
 加关注
查看详情
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

li.angshan 的博客

关注数据计算领域

 
 
 

日志

 
 
 
 

闪回恢复区的维护  

2009-10-29 11:27:07|  分类: oracle 管理 |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.
Mon Jun 29 13:45:52 2009
************************************************************************
You have following choices to free up space from flash 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.
************************************************************************
Mon Jun 29 13:45:52 2009
Errors in file /u01/app/oracle/admin/devdb/bdump/devdb1_arc0_12377.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52426752 bytes disk space from 2147483648 limit
ARC0: Error 19809 Creating archive log file to '+RECOVERYDEST'
ARC0: Failed to archive thread 1 sequence 59 (19809)
ARCH: Archival stopped, error occurred. Will continue retrying
Mon Jun 29 13:45:53 2009
ORACLE Instance devdb1 - Archival Error
Mon Jun 29 13:45:53 2009
ORA-16038: log 2 sequence# 59 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: '+DG1/devdb/onlinelog/group_2.261.686141193'
ORA-00312: online log 2 thread 1: '+RECOVERYDEST/devdb/onlinelog/group_2.257.686141205'
Mon Jun 29 13:45:53 2009
Errors in file /u01/app/oracle/admin/devdb/bdump/devdb1_arc0_12377.trc:
ORA-16038: log 2 sequence# 59 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: '+DG1/devdb/onlinelog/group_2.261.686141193'
ORA-00312: online log 2 thread 1: '+RECOVERYDEST/devdb/onlinelog/group_2.257.686141205'

以上原因分析是由于flash_area空间不够,引起的归档失败,故数据库无法open,
解决办法:
1. export ORACLE_SID=+ASM1
   cd +RECOVERYDEST/devdb/archive
   rm -rf ./2009-06-26
2. export ORACLE_SID=devdb1
   rman target /
  
crosscheck archivelog all;
   delete expired archivelog all;
3. sqlplus '/ as sysdba '
   alter system archive log all;

其实主要是对flash_area空间的监控维护,避免出现这个错误。
  评论这张
 
阅读(260)| 评论(0)

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2018