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>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10455206/viewspace-1036426/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
深入分析Oracle字符集(转)
请登录后发表评论
登录
全部评论
