ORACLE 9i歸檔之ARCn: Media recovery disabled

    2016年第二季度集中巡檢中發現一平臺9i資料庫的告警日誌中有大量的報警資訊如下：
Wed Apr 13 11:16:35 2016
Thread 1 advanced to log sequence 560256
  Current log# 3 seq# 560256 mem# 0: /oradata/oracle/redolog/redo03.dbf
Wed Apr 13 11:16:35 2016
ARC1: Media recovery disabled
Wed Apr 13 11:16:55 2016
ARC1: Media recovery disabled
Wed Apr 13 11:17:55 2016
ARC1: Media recovery disabled
Wed Apr 13 11:18:55 2016
ARC1: Media recovery disabled
Wed Apr 13 11:19:50 2016
ARC0: Media recovery disabled
Wed Apr 13 11:19:55 2016
ARC1: Media recovery disabled
Wed Apr 13 11:20:55 2016
ARC1: Media recovery disabled
Wed Apr 13 11:21:55 2016
ARC1: Media recovery disabled
Wed Apr 13 11:22:55 2016
ARC1: Media recovery disabled
Wed Apr 13 11:23:55 2016
ARC1: Media recovery disabled
Wed Apr 13 11:24:50 2016
ARC0: Media recovery disabled
Wed Apr 13 11:24:55 2016
ARC1: Media recovery disabled
.
.
.
   之所以出現ARC1: Media recovery disabled告警，原因是9i資料庫中有一個引數log_archive_start設定成true，在資料庫處於非歸檔模式啟動後啟動了歸檔程式導致的，下邊是處理過程：
   --查詢資料庫是否是非歸檔模式
SQL>  select LOG_MODE    from v$database;
LOG_MODE
------------
NOARCHIVELOG
   --檢視log_archive_start引數
SQL>show parameter log_archive_start 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_start                    boolean     TRUE
   --線上關閉歸檔程式
SQL> archive log stop;
?′|-μē? --作業系統字符集亂碼，意思應該是歸檔程式已停止
   --檢視告警日誌
oracle@ZB-MVS:~> tail -f /home/oracle/oradbf/admin/zxin/bdump/alert_ora.log
Archive Log Stop
Archiving is disabled
Shutting down archive processes
Archiving is disabled
Fri Apr 15 14:40:27 2016
ARCH shutting down
ARC0: Archival stopped
Fri Apr 15 14:40:27 2016
ARCH shutting down
ARC1: Archival stopped
   --操作前作業系統層次的歸檔程式檢視
oracle@ZB-MVS:~> ps -ef|grep arc
oracle   13329     1  0 Apr13 ?        00:00:00 ora_arc0_ora
oracle   13331     1  0 Apr13 ?        00:00:00 ora_arc1_ora
oracle   27057 18494  0 14:20 pts/0    00:00:00 grep arc
   --操作後作業系統層次的歸檔程式檢視
oracle@ZB-MVS:~> ps -ef|grep arc 
oracle   10350 15945  0 14:41 pts/0    00:00:00 grep arc