viernes, 1 de agosto de 2014

Monitoreando RMAN JOBS

 backup device type sbt database;  
--monitor rman job
SELECT 'Detail Progress Information (per file)'"Detail Data" from dual;
SELECT SID, START_TIME, ELAPSED_SECONDS, TIME_REMAINING
FROM V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
AND OPNAME NOT LIKE '%aggregate%'
AND TOTALWORK != 0
AND SOFAR <> TOTALWORK;
SELECT 'Aggregate Progress Information' "Aggregate Data" from dual;
SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"
FROM V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
AND OPNAME LIKE '%aggregate%'
AND TOTALWORK != 0
AND SOFAR <> TOTALWORK;

No hay comentarios.:

Publicar un comentario