Question: I need to troubleshoot
by RMAN sessions. What are some RMAN troubleshooting
scripts?
Answer: You cam run these scripts to troubleshoot the open number of RMAN
sessions.
Also see my notes on
RMAN debugging. The other RMAN scripts show other details on
currently-running RMAN sessions, For full scripts,
download the Oracle
script collection.
select
count(*)
from
v$rman_output;
COUNT(*)
----------
19665
--
****************************************
select
output
from
v$rman_output
where
session_recid = (select
max(session_recid) from v$rman_status)
order by
recid ;
--
********************************************
select
session_key,
input_type,
status,
to_char(start_time,'dd/mm/yy hh24:mi') start_time,
to_char(end_time,'dd/mm/yy
hh24:mi') end_time,
round((end_time-start_time)*1440,2)
"minutes"
from
v$rman_backup_job_details
where
input_type='DB INCR'
order by
session_key desc;
--
***********************************************