RMAN-08512: waiting for snapshot controlfile enqueue ERROR
================================================
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;
RMAN second server process polling in V$SESSION_LONGOPS
=============================================
SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"
FROM V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
AND OPNAME NOT LIKE '%aggregate%'
AND TOTALWORK != 0
AND SOFAR <> TOTALWORK
/
query to monitor the size of buffers on a per-file basis while the backup is running
==============================================================
SELECT set_count, device_type, type, filename,
buffer_size, buffer_count, open_time, close_time
FROM v$backup_async_io
ORDER BY set_count,type, open_time, close_time;
estimated completion percentage for each channel process.
============================================
SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"
FROM V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
AND OPNAME NOT LIKE '%aggregate%'
AND TOTALWORK != 0
AND SOFAR <> TOTALWORK
/