idlegt;startu本文来源gaodaimacom搞#^代%!码&网(pOracle 例程已经启动。 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 归档日志过大导致无法存储的解决办法
，
转载请注明原文链接：ORA-19809ORA-03113
