ORA-00230错误

wolfheader

咋解决呢

ORA-00230 operation disallowed: snapshot controlfile enqueue unavailable

Cause: The attempted operation cannot be executed at this time because another process currently holds the snapshot control file enqueue.

Action: Retry the operation after the concurrent operation that is holding the snapshot control file enqueue terminates.
（其他进程停止锁定后重试？其他进程怎么停止？）

哪位老大解释下

remen

1 等待这个进程run完
2 手工kill掉

wolfheader

From: Vaughan Andrews 21-Mar-05 17:50
Subject: Re : Backup Failure with CommVault


from docid 1018679.102 this may help:

Solution Description: =====================
Let's start by assuming that it is a simple enqueue conflict (i.e. some other job really is holding the controlfile enqueue). One possible reason for this would be that another rman backup which includes the controlfile is waiting for a tape to be loaded. To find out who is holding the conflicting enqueue, run the following query(do this from another session after you get the first 'waiting for controlfile enqueue' message).

select s.sid, username, program, module, action, logon_time, l.* from v$session s, v$enqueue_lock l where l.sid = s.sid and l.type = 'CF' and l.id1 = 0 and l.id2 = 2;

Solution Explanation: ===================== Ora-230 "operation disallowed: snapshot controlfile enqueue unavailable" Cause: The attempted operation cannot be executed at this time because another process currently holds the snapshot controlfile enqueue. Action: Retry the operation after the concurrent operation that is holding the snapshot controlfile enqueue terminates. This means that some other session is hung while either backing up the controlfile (perhaps waiting for some sort of media manager operator intervention) or resyncing the recovery catalog. This could happen if another instance of rman is running against the same target database.

wolfheader

kill掉rman，搞定，谢谢