ORA-19809ORA-03113

程序员文章站 2024-02-14 14:31:22

...

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
数据库装载完毕。
数据库已经打开。