登入 Oracle 資料庫報錯，ORA-00257: archiver error

報錯的原因是歸檔滿了，無法進行歸檔。

查詢ASM盤的使用情況，可以看到存放歸檔日誌的 FRA 盤已經使用了 100%。

[oracle@PTFDB1 ~]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 11 18:21:22 2015


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




Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options

18:21:29 sys@PTFDB> SELECT NAME,TYPE,TOTAL_MB,FREE_MB,(TOTAL_MB-FREE_MB) USED_MB,100*round((TOTAL_MB-FREE_MB)/TOTAL_MB,4)||'%' "Used %" FROM V$ASM_DISKGROUP;
NAME       TYPE TOTAL_MB    FREE_MB    USED_MB Used %
------------------------------ ------ ---------- ---------- ---------- -----------------------------------------
DATA       EXTERN  614399     201069 413330 67.27%
FRA       EXTERN  204797      44827 159970 100.00%
OCR       NORMAL    3057       2131   926 30.29%
REDO1       EXTERN    5114       4776   338 6.61%
REDO2       EXTERN    5114       4776   338 6.61%
解決方法是刪除過期的歸檔檔案，釋放空間。

[oracle@PTFDB2 ~]$ rman target /


Recovery Manager: Release 11.2.0.3.0 - Production on Sat Dec 12 15:46:43 2015


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


connected to target database: PTFDB (DBID=4173298199)


RMAN> delete noprompt archivelog until time 'sysdate-7';