# 46019
youngDBA
|
|
To: 盖老师
盖老师:
你好!
我有个问题想咨询一下,为什么我数据库执行
alter system archive log current 这句就卡住不动了,像是锁了一样。
但是我可以正常执行alter system switch logfile.
我看了一个告警有一天的日志:
ARC0: Evaluating archive log 5 thread 1 sequence 9420
ARC0: Unable to archive log 5 thread 1 sequence 9420
Log actively being archived by another process
Fri Apr 25 15:22:37 2014
ARCH: Completed archivinglog 5 thread 1 sequence 9420
然后查了一下盖老师之前的贴子。
http://www.eygle.com/archives/2007/06/log_archive_process_more.html
没太明白。目前数据库是9i rac. 请问alter system archive log current 会有锁的情况吗?
还是硬件IO出现了故障呢。麻烦盖老师指点一下。谢谢。
From: youngDBA 2014.04.26 04:48
|
|
|
|
To: youngDBA
你看看等待事件,或者在操作系统上跟踪一下,应该不是硬件的问题了。
From: eygle 2014.04.27 21:49
|
|
|
|
|