RMAN-08512: waiting for snapshot controlfile enqueue

                 

RMAN-08512 error genrally will occur when snapshot control file header is locked by one process and the other processes is requesting the enqueue.

For example if you have multiple RMAN Backup Jobs and you trying to run the jobs parrallely on same database with two different RMAN session then this kind of error may occur.

To investigate if multiple RMAN clients are running or not Please use the below query.

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

SELECT 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;

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

Have a good day :)