Database Backup and Recovery (MOSC)

MOSC Banner

How to find hostname of databases in the Recovery Manager (RMAN) Catalog

edited Aug 19, 2020 4:40PM in Database Backup and Recovery (MOSC) 3 commentsAnswered
We have a situation where we need to capture the hostname (or ip) of all the databases being backed in our RMAN catalog.  We have over 250 databases.  The information in rc_rman_backup_job_details has all the information we are looking for with the exception of the hostname.

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center