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

有个测试库，今天早上来发现登陆数据库失败；提示我归档错误。

1、查看数据库归档情况

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     5294
Next log sequence to archive   5294
Current log sequence           5303

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_11                  string
log_archive_dest_12                  string
log_archive_dest_13                  string
log_archive_dest_14                  string

2、查看归档路径

SQL> show parameter recovery


NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /opt/flash_recovery_area
db_recovery_file_dest_size           big integer 2G
recovery_parallelism                 integer     0

3、查看归档已使用空间大小

SQL> select * from v$flash_recovery_area_usage;


FILE_TYPE            PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE                          0                         0               0
REDO LOG                              0                         0               0
ARCHIVED LOG                      97.83                         0              24
BACKUP PIECE                          0                         0               0
IMAGE COPY                            0                         0               0
FLASHBACK LOG                      1.48                       .74               2
FOREIGN ARCHIVED LOG                  0                         0               0

4、清除无用的归档日志

删除过期的归档

RMAN> delete expired archivelog all;


released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=84 device type=DISK
specification does not match any archived log in the repository

删除系统时间前一天以前的归档
RMAN> delete archivelog until time 'sysdate-1';


released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=84 device type=DISK
List of Archived Log Copies for database with db_unique_name CMPS
=====================================================================


Key     Thrd Seq     S Low Time 
------- ---- ------- - ---------
5256    1    5294    A 21-AUG-12
        Name: /opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5294_83onngx9_.arc


5257    1    5295    A 22-AUG-12
        Name: /opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5295_83onnjlf_.arc


5258    1    5296    A 22-AUG-12
        Name: /opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5296_83onnjpc_.arc


5259    1    5297    A 23-AUG-12
        Name: /opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5297_83onnm40_.arc


5260    1    5298    A 23-AUG-12
        Name: /opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5298_83onnm75_.arc


5261    1    5299    A 23-AUG-12
        Name: /opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5299_83onnos7_.arc


5262    1    5300    A 24-AUG-12
        Name: /opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5300_83onnp05_.arc


5263    1    5301    A 24-AUG-12
        Name: /opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5301_83onnrw8_.arc


5264    1    5302    A 24-AUG-12
        Name: /opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5302_83onns14_.arc


5265    1    5303    A 25-AUG-12
        Name: /opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5303_83onnv6p_.arc




Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5294_83onngx9_.arc RECID=5256 STAMP=792409872
deleted archived log
archived log file name=/opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5295_83onnjlf_.arc RECID=5257 STAMP=792409874
deleted archived log............................................................................

5、查看归档日志所占用的空间十分释放

SQL> select * from v$flash_recovery_area_usage;


FILE_TYPE            PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE                          0                         0               0
REDO LOG                              0                         0               0
ARCHIVED LOG                          0                         0               0
BACKUP PIECE                          0                         0               0
IMAGE COPY                            0                         0               0
FLASHBACK LOG                      1.48                       .74               2
FOREIGN ARCHIVED LOG                  0                         0               0


7 rows selected

6、测试连接数据库正常

.