1、用户连接报错
SQL> conn scott/tiger@orcl;
ERROR:
ORA-00257: archiver error. Connect internal only, until freed. --归档错误（日志空间满）

RMAN以catalog的形式连接也报同样的错。

2、检查FLASH_RECOVERY_AREA_USAGE使用情况
SQL> conn / as sysdba;
Connected.

SQL> show parameter log_archive_dest;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
……

SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;

FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 99.6 .51 50
BACKUPPIECE .33 0 1
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0

6 rows selected.

3、清除部分日志---采用rman方式清除日志
[oracle@rusky ORCL]$ rman target sys/12345

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jan 5 14:51:36 2015

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

connected to target database: ORCL (DBID=1379778111)

RMAN> crosscheck archivelog all; ---先用该命令检查

RMAN> delete expired archivelog all;--删除过期日志

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=124 devtype=DISK
specification does not match any archive log in the recovery catalog --无过期日志

RMAN> delete archivelog until time "to_date(‘2015-01-01 23:00:00‘,‘yyyy-mm-dd hh24:mi:ss‘)"; --删除指定日志前的日志

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=124 devtype=DISK

List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
1 1 1209 A 24-DEC-14 /home/oracle/oracle/flash_recovery_area/ORCL/archivelog/2014_12_24/o1_mf_1_1209_b9o2yclz_.arc
……

4、查看flash_recovery_area_usage使用情况
SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 34.72 0 17
BACKUPPIECE .33 0 1
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0

6 rows selected.

5、再次连接SQLPLUS正常

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