Go Premium for a chance to win a PS4. Enter to Win


Is there any view to find out the host name in Recovery catalog database?

Posted on 2010-09-01
Medium Priority
Last Modified: 2013-12-19
I am querying the databases that are not backed up in a catalog database .

I am getting the instances that are not backed up , is there any way to query the host name of the instance.

Question by:banumyname
  • 3
  • 2
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33580176
Based on the list of available views in the docs:


I can't find a view that will give you the host.

Author Comment

ID: 33580492
slightwv  ...i already had alook at that doc ...but no use

any way Thanks  a lot
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33580505
Leave this open for a while.  Maybe other Experts that use a recovery catalog will know things I don't.
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.


Author Comment

ID: 33580530
will do ...
Thanks slightwv

Accepted Solution

Rindbaek earned 1500 total points
ID: 33585431
I dont think its build in.

One solution could be to create a custom table binding hostname to RC_DATABASE.DB_KEY and than use that in your select as well.  The bad thing is of cause that this table has to be maintained manually.

I dont know if this will violate the license for the use of the catalog tough.


Author Comment

ID: 33586081
Thanks Rindbaek...

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question