【Oracle ERP Note 】ARC3: Error 19502 Closing archive log file

Problem

較早之前運作正常的測試區，突然 User 反映無法連線。

Study

查看 alert_TEST.log  時，發現有 Thread 1 cannot allocate new log, sequence 2320  這錯誤訊息，所以可先合理懷疑磁碟空間是否不足。


ARC3: Error 19502 Closing archive log file '/u01/proddb/proddata/archive/1_2318_852393435.dbf'
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance TEST - Archival Error
ORA-16038: log 9 sequence# 2318 cannot be archived
ORA-19502: write error on file "", block number  (block size=)
ORA-00312: online log 9 thread 1: '/u01/proddb/proddata/redo/log09b.dbf'
Tue May 12 22:06:21 2015
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance TEST - Archival Error
ORA-16014: log 9 sequence# 2318 not archived, no available destinations
ORA-00312: online log 9 thread 1: '/u01/proddb/proddata/redo/log09b.dbf'
Tue May 12 22:06:56 2015
Thread 1 cannot allocate new log, sequence 2320
Checkpoint not complete
  Current log# 8 seq# 2319 mem# 0: /u01/proddb/proddata/redo/log08b.dbf


經以 df -h 指令查看硬碟空間，發現 Oracle EBS 安裝所在的 /ora03  沒有空間，所以我們可清除此空間。 (事實上， /ora03 與 /u01 指向同一個硬碟空間)

# df -h
Filesystem                         Size  Used  Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00    38G   4.5G  32G   13% /
/dev/sda1                          99M   16M   79M   17% /boot
tmpfs                              4.0G  3.3M  3.9G   1% /dev/shm
/dev/mapper/VolGroup00-LogVol02    40G   21G   17G   55% /ora01
/dev/mapper/VolGroup00-LogVol03    5.0G  631M  4.1G  14% /misap
/dev/mapper/VolGroup00-LogVol05    9.9G  1.4G  8.0G  15% /var
/dev/mapper/VolGroup01-LogVol05    352G  338G  31M  100% /ora03
/dev/mapper/VolGroup01-LogVol05    352G  338G  31M  100% /u01


Solution

我們清除 /ora03 的硬碟空間後，查看清除結果如下，之後重新以 IE Client 連線登入，此時系統恢復正常。


# df -h
Filesystem                         Size  Used  Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00    38G   4.5G  32G   13% /
/dev/sda1                          99M   16M   79M   17% /boot
tmpfs                              4.0G  3.3M  3.9G   1% /dev/shm
/dev/mapper/VolGroup00-LogVol02    40G   21G   17G   56% /ora01
/dev/mapper/VolGroup00-LogVol0ˇ    5.0G  631M  4.1G  14% /misap
/dev/mapper/VolGroup00-LogVol05    9.9G  1.4G  8.0G  15% /var
/dev/mapper/VolGroup01-LogVol05    352G  337G  357M 100% /ora03
/dev/mapper/VolGroup01-LogVol05    352G  337G  357M 100% /u01