oracle里面的arcn,案例:Oracle数据库日志ARCn Media recovery disabled原因分析

天萃荷净

Oracle数据库日志中ARCn: Media recovery disabled原因分析

1.查看Oracle数据库版本

SQL> select * from v$version;

BANNER

-------------------------------------------------------------

Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production

PL/SQL Release 9.2.0.8.0 - Production

CORE 9.2.0.8.0 Production

TNS for Linux: Version 9.2.0.8.0 - Production

NLSRTL Version 9.2.0.8.0 - Production

2.查看Oracle数据库alert日志中出现信息

Fri Feb 10 05:16:55 2012

ARC1: Media recovery disabled

Fri Feb 10 05:17:23 2012

ARC0: Media recovery disabled

Fri Feb 10 05:17:23 2012

ARC1: Media recovery disabled

Fri Feb 10 05:18:23 2012

ARC1: Media recovery disabled

Fri Feb 10 05:19:12 2012

Thread 1 advanced to log sequence 24

Current log# 1 seq# 24 mem# 0: /tmp/recover/redo01.log

Fri Feb 10 05:19:12 2012

ARC0: Media recovery disabled

Fri Feb 10 05:19:23 2012

ARC1: Media recovery disabled

Fri Feb 10 05:20:23 2012

ARC1: Media recovery disabled

Fri Feb 10 05:21:23 2012

ARC1: Media recovery disabled

3.查看Oracle数据库归档信息状态

SQL> archive log list;

Database log mode No Archive Mode

Automatic archival Enabled

Archive destination /tmp/recover

Oldest online log sequence 25

Current log sequence 27

SQL> show parameter log_archive_start

NAME TYPE VALUE

------------------------------------ ----------- ---------------

log_archive_start boolean TRUE

从这里可以看出，数据库处于非归档模式，但是log_archive_start=true，这样会导致归档进程自动启动(ARCn),因为数据库设置为非归档模式，从而导致该进程启动后，又自己关闭

4.Oracle研究中心的解决方法

SQL> alter system set log_archive_start=false scope=spfile;

System altered.

SQL> startup force

ORACLE instance started.

Total System Global Area 202445176 bytes

Fixed Size 450936 bytes

Variable Size 167772160 bytes

Database Buffers 33554432 bytes

Redo Buffers 667648 bytes

Database mounted.

Database opened.

SQL> show parameter log_archive_start

NAME TYPE VALUE

------------------------------------ ----------- --------------

log_archive_start boolean FALSE

SQL> ARCHIVE LOG LIST;

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination /tmp/recover

Oldest online log sequence 26

Current log sequence 28

ALERT中无类此记录出现

-----------------温馨提示--------------------

操作有风险，动手需谨慎

Oracle研究中心

http://www.oracleplus.net

本文由大师惜分飞原创分享，转载请尽量保留本站网址

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之案例:Oracle数据库日志ARCn Media recovery disabled原因分析