ORA-16038:ORA-19809:ORA-00312:

造成的原因：

用户登录报
ORA-00257: archiver error. Connect internal only
日志归档空间不足，错误的去shutdown immediate 但是没有动静，然后shutdown abort

结果杯具了
造成的异常：
SQL> startup                                                                                                                       
ORACLE instance started.

Total System Global Area 2097152000 bytes
Fixed Size                  1220384 bytes
Variable Size            1291845856 bytes
Database Buffers          788529152 bytes
Redo Buffers               15556608 bytes
Database mounted.
ORA-16038: log 2 sequence# 1062 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/dcora/redo02.log'

 

尝试reset

SQL> alter database open resetlogs;                                                                                                
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery

 

recover了。。。

SQL> recover database until cancel;                                                                                                
Media recovery complete.
SQL> alter database open resetlogs;                                                                                                

Database altered.