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