环境
OS:oracle linux 6.5
db:oracle 11.2.0.4 asm存储
创建EM遇到归档Hang住ORA-19504
[grid@OLEASM1 ~]$ tail -f /u01/app/oracle/diag/rdbms/pnetdata/netdata/trace/alert_netdata.log
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance netdata - Archival Error
ORA-16038: log 2 sequence# 107 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 2 thread 1: '+DATA/netdata/onlinelog/group_2.267.882674055'
Fri Jun 26 07:24:26 2015
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance netdata - Archival Error
ORA-16014: log 2 sequence# 107 not archived, no available destinations
ORA-00312: online log 2 thread 1: '+DATA/netdata/onlinelog/group_2.267.882674055'
Fri Jun 26 07:29:26 2015
ARC0: LGWR is actively archiving destination LOG_ARCHIVE_DEST_1
Unable to create archive log file '+FRA'
ARC0: Error 19504 Creating archive log file to '+FRA'
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance netdata - Archival Error
ORA-16038: log 2 sequence# 107 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 2 thread 1: '+DATA/netdata/onlinelog/group_2.267.882674055'
Fri Jun 26 07:29:26 2015
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance netdata - Archival Error


连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> archive log list;
数据库日志模式            存档模式
自动存档             启用
存档终点            +FRA
最早的联机日志序列     107
下一个存档日志序列   107
当前日志序列           109
SQL> select file_type, percent_space_used as used,percent_space_reclaimable as reclaimable,number_of_files as "number" from v$flash_recovery_area_usage;

FILE_TYPE           USED RECLAIMABLE    number
-------------------- ---------- ----------- ----------
CONTROL FILE              0       0         0
REDO LOG              0       0         0
ARCHIVED LOG          16.41       16.41        21
BACKUP PIECE          62.63       62.63         5
IMAGE COPY              0       0         0
FLASHBACK LOG              0       0         0
FOREIGN ARCHIVED LOG          0       0         0

已选择7行。

查询已占用的空间
select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;

查询flash_recovery_area大小
SQL> show parameter db_recovery_file

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest             string     +FRA
db_recovery_file_dest_size         big integer 3912M
修改db_recovery_file_dest_size大小

ALTER SYSTEM SET db_recovery_file_dest_size='10G' SCOPE=BOTH;
再次查询日志归档已正常切换
Fri Jun 26 07:34:26 2015
ARC0: LGWR is actively archiving destination LOG_ARCHIVE_DEST_1
Fri Jun 26 07:34:27 2015
Archiver process freed from errors. No longer stopped
Archived Log entry 170 added for thread 1 sequence 107 ID 0x16797591 dest 1:
krse_arc_driver_core: Successful archiving of previously failed ORL
Fri Jun 26 07:34:30 2015
ARC1: LGWR is actively archiving destination LOG_ARCHIVE_DEST_1
Fri Jun 26 07:34:30 2015
LGWR: Standby redo logfile selected for thread 1 sequence 110 for destination LOG_ARCHIVE_DEST_2
Thread 1 advanced to log sequence 110 (LGWR switch)
  Current log# 2 seq# 110 mem# 0: +DATA/netdata/onlinelog/group_2.267.882674055
ARC3: LGWR is actively archiving destination LOG_ARCHIVE_DEST_1
Fri Jun 26 07:34:47 2015
Archived Log entry 172 added for thread 1 sequence 108 ID 0x16797591 dest 1:
Fri Jun 26 07:34:50 2015
Archived Log entry 173 added for thread 1 sequence 109 ID 0x16797591 dest 1:
Fri Jun 26 07:35:02 2015