ORA-19809: limit exceeded for recovery files问题

【现象】

 

数据库突然死掉，startup报错：

 

ORA-16038: log 1 sequence# 1 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: '/u01/livedata/live/redo01.log'

 

 

【原因】

 

归档日志默认设置恢复区2G，空间被占满，无法再归档

 

【处理】

 

1，删除旧7日前归档日志

[oracle@DB-SERVER ~]$ rman

RMAN> connect target <dbuser>/<password>
RMAN> DELETE ARCHIVELOG UNTIL TIME 'SYSDATE-7';

 

2，扩容日志空间

SQL> alter system set db_recovery_file_dest_size=20G;
System altered.

SQL> alter database open;
Database altered.