Database altered.
Elapsed: 00:00:06.89
再次归档：
17:26:02 SYS@ prod>alter system switch logfile;
再次hang。。。。。
查看日志：
ORACLE Instance prod - Can not allocate log, archival required
Thread 1 cannot allocate new log, sequence 5
All online logs needed archiving
Current log# 1 seq# 4 mem# 0: /dsk1/oradata/prod/redo01a.log
Current log# 1 seq# 4 mem# 1: /dsk2/oradata/prod/redo01b.log
ARC3: Encountered disk I/O error 19502
ARC3: Closing local archive destination LOG_ARCHIVE_DEST_1: '/dsk4/arch_prod/arch_1_2_847900609.log' (error 19502) (prod)
Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_arc3_13316.trc:
ORA-19502: write error on file "/dsk4/arch_prod/arch_1_2_847900609.log", block number 4097 (block size=512)
ORA-27072: File I/O error
Linux-x86_64 Error: 25: Inappropriate ioctl for device
Additional information: 4
Additional information: 4097
Additional information: 765440
查看归档日志存储空间：
16:41:16 SYS@ prod>
[root@rh6 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 18G 5.0G 12G 30% /
tmpfs 878M 72K 878M 1% /dev/shm
/dev/sda1 2.0G 62M 1.8G 4% /boot
/dev/sda3 12G 5.7G 5.3G 52% /u01
......
/dev/mapper/datavg-lv_dsk4
4.0G 3.8G 2.8M 100% /dsk4
竟然，归档日志存储空间已经被塞满，所以造成归档被hang。。。。。。
清理存储空间：
调整归档位置：
6:49:44 SYS@ prod>alter system set log_archive_dest_2='location=/dsk4/arch1';
System altered.
16:51:15 SYS@ prod>alter system set log_archive_dest_state_1=defer;
System altered.
Elapsed: 00:00:00.04
16:51:25 SYS@ prod>alter system switch logfile;
重新进行归档，归档成功！
ALTER SYSTEM SET log_archive_dest_2='location=/dsk4/arch1' SCOPE=BOTH;
Sun May 18 16:51:25 2014
Using STANDBY_ARCHIVE_DEST parameter default value as /dsk4/arch1
ALTER SYSTEM SET log_archive_dest_state_1='DEFER' SCOPE=BOTH;
Sun May 18 16:53:13 2014
Archived Log entry 4 added for thread 1 sequence 2 ID 0xf7a7caa dest 2:
krse_arc_driver_core: Successful archiving of previously failed ORL
Sun May 18 16:53:13 2014
Thread 1 advanced to log sequence 5 (LGWR switch)
Current log# 2 seq# 5 mem# 0: /dsk1/oradata/prod/redo02a.log
Current log# 2 seq# 5 mem# 1: /dsk2/oradata/prod/redo02b.log
Sun May 18 16:53:14 2014
Archived Log entry 5 added for thread 1 sequence 4 ID 0xf7a7caa dest 2:
Sun May 18 16:53:15 2014
Archived Log entry 6 added for thread 1 sequence 3 ID 0xf7a7caa dest 2:
@至此，问题彻底解决，对于归档日志的存储空间在巡检中一定要进行监控，否则空间满后，会给数据库带来很大的麻烦！