Oracle

Use longops to find out status of backup – Oracle

July 11, 2017

####This will show any running RMAN process with details about how much work is done and left #####

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;

You Might Also Like

No Comments

Leave a Reply