This discussion is archived
6 Replies Latest reply: Oct 19, 2012 3:05 PM by rp0428 RSS

How can i add servername to my report for all cataloged database

789987 Newbie
Currently Being Moderated
1) Im using following sql statement to find the backup type,status and their timings and i would also like to see the databasename with it's corresonding servername.

select
DB_NAME,DB_KEY,
input_type "Backup Object",
output_device_type "Target Device",
status "Status",
output_bytes_display "Backup Size",
time_taken_display "Time Taken",
start_time "Backup Begin",
end_time "Backup End"
from rman.rc_rman_backup_job_details
where start_time > sysdate - 1
and input_type in ('DB INCR','DB FULL','ARCHIVELOG','BACKUPSET')
order by DB_NAME,DB_KEY
/

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points