ORA-19504: failed to create file "" 一則案例

今天檢查自己測試庫的時候，發現日誌狂報ORA-19504: failed to create file ""
Thread 1 advanced to log sequence 156 (LGWR switch)
  Current log# 3 seq# 156 mem# 0: +DATA/netdata/onlinelog/group_3.261.882674015
Tue Jul 14 14:01:05 2015
Archiver process freed from errors. No longer stopped
Tue Jul 14 14:05:18 2015
Thread 1 cannot allocate new log, sequence 157
Checkpoint not complete
  Current log# 3 seq# 156 mem# 0: +DATA/netdata/onlinelog/group_3.261.882674015
ORACLE Instance netdata - Cannot allocate log, archival required
Thread 1 cannot allocate new log, sequence 157
All online logs need archiving
Examine archive trace files for archiving errors
  Current log# 3 seq# 156 mem# 0: +DATA/netdata/onlinelog/group_3.261.882674015
Tue Jul 14 14:06:03 2015
Unable to create archive log file '+FRA/pnetdata/archivelog/1_154_882661788.dbf'
ARC3: Error 19504 Creating archive log file to '+FRA/pnetdata/archivelog/1_154_882661788.dbf'
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance netdata - Archival Error
ORA-16038: log 1 sequence# 154 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 1 thread 1: '+DATA/netdata/onlinelog/group_1.269.882674261'
Tue Jul 14 14:06:03 2015
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance netdata - Archival Error
ORA-16014: log 1 sequence# 154 not archived, no available destinations
ORA-00312: online log 1 thread 1: '+DATA/netdata/onlinelog/group_1.269.882674261'
Tue Jul 14 14:11:03 2015
Unable to create archive log file '+FRA/pnetdata/archivelog/1_154_882661788.dbf'
ARC1: Error 19504 Creating archive log file to '+FRA/pnetdata/archivelog/1_154_882661788.dbf'
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance netdata - Archival Error
開始以為是ASM掛了
檢查asm
SQL> select status from v$instance;

STATUS
------------
STARTED

SQL>  select group_number,name,state from v$asm_diskgroup
  2  ;

GROUP_NUMBER NAME                STATE
------------ ------------------------------ -----------
       1 DATA                MOUNTED
       2 FRA                MOUNTED

正常的。查詢一下可用空間
ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576     10240     2938                0            2938              0             N  DATA/
MOUNTED  EXTERN  N         512   4096  1048576      5120       30                0              30              0             N  FRA/
歸檔已滿，直接清理歸檔
清理完歸檔做了一個完整備份。