Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> getting backup job status in 9i

getting backup job status in 9i

From: <graff3_at_hotmail.com>
Date: 4 Jun 2006 19:20:23 -0700
Message-ID: <1149474022.989707.176520@f6g2000cwb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US