How to find hostname of databases in the Recovery Manager (RMAN) Catalog
Can someone tell me how we can easily extract the hostname, db name, input type, status, start and stop time from the recovery catalog. Again, all but the hostname can be found in rc_rman_backup_job_details and we need the hostame information. We don't want to login to all the servers gather this information if at all possible.