Hi Experts,
I notice that the view v$rman_backup_job_details it's not available in oracle 11g, can you help me to find the equivalent of this query in 9i:
select upper(i.host_name) "Serveur",i.instance_name "BDD",INPUT_TYPE "Type sauvegarde", r.STATUS,
to_char(START_TIME,'DD/MM/YYYY hh24:mi') "Début Sauvegarde",
to_char(END_TIME,'DD/MM/YYYY hh24:mi') "Fin Sauvegarde",
Round(elapsed_seconds/60,2) "Durée de sauvegarde (Min)" from V$RMAN_BACKUP_JOB_DETAILS r,v$instance i
order by session_key desc;
Many thanks for your help