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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29357786/viewspace-2081916/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29357786/viewspace-2081916/