ORA-00257: archiver error

1、问题描述远程连接定义：通过oracle net service连接过来的都叫远程连接比如plsql developer连接、sqlplus 用户名/密码@ORACLE_NET[dbadmin@test archivelog]$ sqlplus zxx/zxx@orclSQL*Plus: Release 10.2.0.4.0 - Production on Tue Dec 2 14:06:32 2014Copyright (c) 1982, 2007, Oracle. All Rights Reserved.ERROR:ORA-00257: archiver error. Connect internal only, until freed.

2、rman查看归档路径10和11g默认归档路径不一样，但是不管怎么样都可以通过rman查询到归档路径RMAN> crosscheck archivelog all;

3、查看归档目录存储上限[root@test archivelog]# pwd/home/dbadmin/oracle/product/10.2.0/db_1/flash_recovery_area/ORCL/archivelog[root@test archivelog]# du -sh ./ 查看当前目录大小2.0G ./SQL> show parameter db_recovery_file_dest_sizeNAME TYPE VALUE------------------------------------ ----------- ------------------------------db_recovery_file_dest_size big integer 2G可以发现，数据库设置归档上限为2G，而通过du -sh查看物理归档路径已经使用2G，在这里就可以说明归档路径已经用满了

5、rm -rf 归档路径中的归档如果不重要就全部删除

7、检查连接是否正常[dbadmin@test archivelog]铮喘饿怊$ sqlplus zxx/zxx@orcl 远程连接SQL*Plus: Release 10.2.0.桃轾庾殇4.0 - Production on Tue Dec 2 14:09:36 2014Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options