ORA-16014: log 1 sequence# 857 not archived, no available destinations

ORA-16014: log 1 sequence# 857 not archived, no available destinations[@more@]

SQL> conn / as sysdba
Connected.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16014: log 1 sequence# 857 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/u02/oradata/oratest/redo01.log'

SQL> alter database clear unarchived logfile group 1;

Database altered.

SQL> alter database open;

上述方法是將未歸檔的內容清除，但最好的辦法應該是如下處理：

SQL> alter system set db_recovery_file_dest_size=4G;

System altered.

SQL> alter database open;

Database altered.

SQL>