channel t1DB1: starting full datafile backupset
channel t1DB1: specifying datafile(s) in backupset
including current SPFILE in backupset
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
cannot make a snapshot controlfile
released channel: t1DB1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t1DB1 channel at 04/30/2012 23:23:09
ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable
-- Determine which job is holding the conflicting enqueue:
-- After determining, query the sessions' Server PIDSELECT s.sid, username AS "User", program, module, action, logon_time "Logon", 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;
-- From Unix console, run the command below to kill it:set lines 250
set pages 9999
col sid_serial# for a11
col "Username" for a12
col "Program" for a40
col "OS_User" for a15
col "Machine" for a25
col server_pid for a10
SELECT s.sid || ',' || s.serial# sid_serial#,
p.spid server_pid,
s.username "Username",
s.program "Program",
TO_CHAR (logon_time, 'DD/MM/YYYY HH24:MI:SS') "Logon Time",
s.server,
s.status,
s.osuser "OS_User",
s.machine "Machine"
FROM v$session s, v$process p
WHERE p.addr = s.paddr
--AND s.username LIKE '%SYSTEM%'
--AND s.status = 'ACTIVE'
AND s.program like '%rman%'
ORDER BY logon_time DESC;
kill -9 [SPID]