ORA-16038，ORA-19809，ORA-00312问题的解决方法

今天导数据由于数据量比较大，导了有一半不动了，关也关不掉。没办法，强制关闭数据库
SQL>shutdown abort
SQL>startup
ORACLE instance started.

Total System Global Area 436207616 bytes
Fixed Size                  1219832 bytes
Variable Size              96469768 bytes
Database Buffers          331350016 bytes
Redo Buffers                7168000 bytes
Database mounted.
ORA-16038: log 3 sequence# 52 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: '/oracle/oradata/orcl/redo03.log'
出现这样的错误
google了一下执行
SQL> alter database clear unarchived logfile '/oracle/oradata/orcl/redo03.log';

Database altered.

SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area  436207616 bytes
Fixed Size                  1219832 bytes
Variable Size              96469768 bytes
Database Buffers          331350016 bytes
Redo Buffers                7168000 bytes
Database mounted.
Database opened.
数据库正常打开，无法归档错误主要是因为数据库不正常关闭,SQL语句出错造成数据线程停止所因起。

同类问题： ORA-16038的解决
同样：ORA-16038: log 3 sequence# 52 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: '/oracle/oradata/orcl/redo03.log'
Flash Recovery Area空间不足导致数据库不能打开或hang住

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22741583/viewspace-683937/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22741583/viewspace-683937/