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.
input_type "Backup Object",
output_device_type "Target Device",
output_bytes_display "Backup Size",
time_taken_display "Time Taken",
start_time "Backup Begin",
end_time "Backup End"
where start_time > sysdate - 1
and input_type in ('DB INCR','DB FULL','ARCHIVELOG','BACKUPSET')
order by DB_NAME,DB_KEY
The only information that will be available will be from one of the RC_* views. For a list of the views see the index in the Database Backup and Recovery Reference
The database name is available as the NAME column of the RC_DATABASE view. You will need to join this view to others at least on DB_KEY.
I'm not aware of any view that would have the server name. You will need to map the database name or id to your own table of server locations.