-- =======================================================================
--  Mostra o andamento dos canais do RMAN
-- =======================================================================-- 
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;

-- =======================================================================
--  Mostra informações dos jobs do RMAN
-- =======================================================================
SELECT  a.command_id, a.start_time, a.end_time, a.output_device_type, a.status, a.input_type, 
        round(a.compression_ratio,2) as compression_ratio, a.input_bytes_display, a.output_bytes_display, a.time_taken_display
FROM V$RMAN_BACKUP_JOB_DETAILS a 
where rownum < 4 
order by start_time desc 

-- =======================================================================
--  Mostra informações detalhadas dos jobs do RMAN 
-- =======================================================================
SELECT * FROM V$RMAN_STATUS order by start_time desc
SELECT * FROM V$RMAN_OUTPUT
SELECT * FROM V$RMAN_CONFIGURATION
SELECT * FROM V$RMAN_COMPRESSION_ALGORITHM
SELECT * FROM V$RMAN_BACKUP_TYPE

-- =======================================================================
--  Consulta backupset RMAN
-- =======================================================================
SELECT * FROM V$BACKUP_SET order by start_time;

hostgator