idlegt;startuporacle 例程已经启动。 total system global area 3407261696 bytesfixed size 2180504 bytesv
idle>startup
oracle 例程已经启动。
total system global area 3407261696 bytes
fixed size 2180504 bytes
variable size 2348812904 bytes
database buffers 1040187392 bytes
redo buffers 16080896 bytes
数据库装载完毕。
ora-03113: 通信通道的文件结尾
进程 id: 6416
会话 id: 5 序列号: 3
查看告警日志：
************************************************************************
errors in file d:\app\lenovo\diag\rdbms\orcl\orcl\trace\orcl_arc1_4252.trc:
ora-19809: limit exceeded for recovery files
ora-19804: cannot reclaim 14319616 bytes disk space from 4102029312 limit
arc1: error 19809 creating archive log file to 'd:\app\lenovo\flash_recovery_area\orcl\archivelog\2013_12_29\o1_mf_1_284_%u_.arc'
errors in file d:\app\lenovo\diag\rdbms\orcl\orcl\trace\orcl_ora_5368.trc:
ora-19815: : db_recovery_file_dest_size (? 4102029312 ) ? 100.00%, 0 ?
************************************************************************
官方给出的原因及解决方案：
ora-19809: limit exceeded for recovery files
cause: the limit for recovery files specified by the db_recovery_file_dest_size was exceeded.
action: there are five possible solutions: 1) take frequent backup of recovery area using rman. 2) consider changing rman retention policy. 3) consider changing rman archived log deletion policy. 4) add disk space and increase db_recovery_file_dest_size. 5) delete files from recovery area using rman.
这里采用第四种方案：
idle>startup nomount;
oracle 例程已经启动。
idle>alter system set db_recovery_file_dest_size=8g scope=both;
系统已更改。
idle>shutdown immediate;
ora-01507:
oracle 例程已经关闭。
idle>startup
oracle 例程已经启动。
total system global area 3407261696 bytes
fixed size 2180504 bytes
variable size 2348812904 bytes
database buffers 1040187392 bytes
redo buffers 16080896 bytes
数据库装载完毕。
数据库已经打开。
相关阅读：
oracle ora-01555 快照过旧 说明
ora-01078 和 lrm-00109 报错解决方法
ora-01555超长的query duration时间
ora-00471 处理方法笔记
ora-00314,redolog 损坏，或丢失处理方法
ora-00257 归档日志过大导致无法存储的解决办法
，