####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;
###Start ADR
adrci
###shows errors in log
SHOW PROBLEM
###Shows last 10 entries of alert file
SHOW ALERT -TAIL
###Display all trace files
SHOW TRACEFILE
###Display trace file location related to incident
SHOW TRACEFILE -I 1234
###Shows incidents in 11g above
SHOW INCIDENT
###Show details of particular incident
SHOW INCIDENT -MODE DETAIL -P “INCIDENT_ID=1234″
Find out instance info.
select * from v$instance;
Find out database info.
select * from v$database;
To get list of full backup from Oracle database run the script below, which uses the rman_backup_job_details system view, this list all backups in database with archivelog mode on and backup size of at least 1 Terabyte.
SELECT * FROM v$rman_backup_job_details
WHERE input_type = 'DB INCR'
AND output_bytes_display LIKE '%T'
ORDER BY session_key DESC;