造成的原因:
用户登录报
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.