ORA-19809&&ORA-03113

ORA-19809&&ORA-03113

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 归档日志过大导致无法存储的解决办法