今天一个客户的数据库突然出现问题，连接不上。登录操作系统（windows 2008R2）之后尝试启动数据，出现如下错误：
ORA-27102: out of memory

OSD-00026: ????????????
O/S-Error: (OS 1455) ????????????????????????????

查看告警日志，发现有如下错误：

Errors in file d:\app\administrator\diag\rdbms\hydee\hydee\trace\hydee_ora_1988.trc:
ORA-19815: 警告: db_recovery_file_dest_size 字节 (共 4102029312 字节) 已使用 100.00%, 尚有 0 字节可用。
************************************************************************
You have following choices to free up space from 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.
************************************************************************
Errors in file d:\app\administrator\diag\rdbms\hydee\hydee\trace\hydee_ora_1988.trc:
ORA-19809: 超出了恢复文件数的限制
ORA-19804: 无法回收 47347712 字节磁盘空间 (从 4102029312 限制中)
ARCH: Error 19809 Creating archive log file to 'D:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\HYDEE\ARCHIVELOG\2015_06_01\O1_MF_1_89_%U_.ARC'
Errors in file d:\app\administrator\diag\rdbms\hydee\hydee\trace\hydee_ora_1988.trc:
ORA-16038: 日志 2 sequence# 89 无法归档
ORA-19809: 超出了恢复文件数的限制
ORA-00312: 联机日志 2 线程 1: 'D:\APP\ADMINISTRATOR\ORADATA\HYDEE\ONLINELOG\O1_MF_2_B78B622M_.LOG'
ORA-00312: 联机日志 2 线程 1: 'D:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\HYDEE\ONLINELOG\O1_MF_2_B78B6333_.LOG'
USER (ospid: 1988): terminating the instance due to error 16038
ARC1: Archival started
Errors in file d:\app\administrator\diag\rdbms\hydee\hydee\trace\hydee_arc0_1192.trc:
ORA-01092: ORACLE 实例终止。强制断开连接

数据库版本信息：
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

尝试登录RMAN去删除归档日志，也依旧提示 ORA-27102: out of memory
请教了惜总运维群，重启了主机之后，可以将数据库启动至mount状态。

在RMAN下执行了：
delete noprompt archivelog until time 'sysdate - 3';

删除了归档日志（归档日志其实已经被物理删除）。

并关闭了数据库的归档模式之后，数据库恢复正常。关闭归档模式是因为用户数据库较小，且数据并非重要，
使用EXP/EXPDP进行备份已经足够了

ITPub博客

ORA-16038 ORA-19809 ORA-00312与ORA-27102: out of memory

最新文章