/* 2008/07/03 星期四
*蒙昭良
*环境：windowsXP + Oracle10gR2
*ORA-00257: archiver error. Connect internal only, until freed.
*/

C:\>sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 7月 3 13:15:55 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> CONN scott/tiger
ERROR:
ORA-00257: archiver error. Connect internal only, until freed.

警告: 您不再连接到 ORACLE。

提示信息：归档错误，仅仅内部连接，直到释放。

检查$oracle_home\admin\risenet\bdump\alert_SID.log日志发现

Errors in file g:\oracle\product\10.2.0\admin\risenet\bdump\risenet_arc0_996.trc:
ORA-16014: log 3 sequence# 102 not archived, no available destinations
ORA-00312: online log 3 thread 1: 'G:\ORACLE\PRODUCT\10.2.0\ORADATA\RISENET\REDO03.LOG'

Thu Jul 03 13:18:40 2008
Errors in file g:\oracle\product\10.2.0\admin\risenet\bdump\risenet_arc1_3720.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.

归档默认的空间2G已经用完，删除掉日志或者扩大归档空间
1）命令>rman target/

2)命令>crosscheck archivelog all;

3)命令>delete archivelog all;

4)命令>exit

重新连接：
C:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 7月 3 13:27:59 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn scott/tiger
已连接。