Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> getting backup job status in 9i
Hi guys,
I am trying to enumerate the rman jobs run on my 9i instance. Unfortunately, the RMAN views in 10g are not available on 9i.
Following is my 10g query.
select det.command_id as Name, det.status as Status, sub.input_type as
Type, det.TIME_TAKEN_DISPLAY as Time
from v$rman_backup_job_details det, v$rman_status st,
v$rman_backup_subjob_details sub
where det.SESSION_RECID = st.PARENT_RECID
and sub.SESSION_RECID = det.SESSION_RECID
and st.operation = 'BACKUP';
Can someone please tell me its equivalent in 9i?
Cheers
Max Received on Sun Jun 04 2006 - 21:20:23 CDT