You will find the below error when doing RMAN auto control backup:
Finished backup at 2012-03-19:23:35:41
waiting for snapshot control file enqueue
waiting for snapshot control file enqueue
waiting for snapshot control file enqueue
waiting for snapshot control file enqueue
waiting for snapshot control file enqueue
ORA-00230: operation disallowed: snapshot control file enqueue unavailable
The error looks like other process is holding the controlfile hence RMAN can’t do the snapshot. Most likely is the previous backup process job is still holding it, so let’s check what we have in the database:
Code: Select all
set lines 250
set pages 9999
col sid_serial# for a11
col "Username" for a12
col "Program" for a35
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.program LIKE '%rman%'
ORDER BY logon_time DESC;
Code: Select all
SID_SERIAL# SERVER_PID Username Program Logon Time SERVER STATUS OS_User Machine
----------- ---------- ------------ ----------------------------------- ------------------- --------- -------- --------------- -------------------------
438,58097 21837 SYS rman@uschgdev003 (TNS V1-V3) 19/03/2012 23:34:52 DEDICATED ACTIVE oracle uschgdev003
441,39795 21828 SYS rman@uschgdev003 (TNS V1-V3) 19/03/2012 23:34:49 DEDICATED INACTIVE oracle uschgdev003
228,59749 21830 SYS rman@uschgdev003 (TNS V1-V3) 19/03/2012 23:34:49 DEDICATED INACTIVE oracle uschgdev003
*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.