ORACLE 9i归档之ARCn: Media recovery disabled

最新推荐文章于 2024-11-03 09:30:00 发布

weixin_33895516

最新推荐文章于 2024-11-03 09:30:00 发布

阅读量97

点赞数

文章标签：数据库操作系统

原文链接：https://yq.aliyun.com/articles/284848

版权

本文记录了2016年第二季度巡检中发现的一个9i数据库告警问题及解决过程。主要针对大量出现的ARC1: Media recovery disabled告警进行详细解析，并通过调整log_archive_start参数及在线关闭归档进程来解决该问题。

摘要由CSDN通过智能技术生成

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