6 Replies Latest reply: Oct 19, 2012 5:05 PM by rp0428 RSS

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

    789987
      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
      /