ORA-00257: archiver error. Connect internal only, until freed

/* 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
已連線。