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

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.

Thanks
banumynameAsked:
Who is Participating?
 
RindbaekConnect With a Mentor Commented:
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.
 



0
 
slightwv (䄆 Netminder) Commented:
Based on the list of available views in the docs:

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcviews001.htm#sthref1058

I can't find a view that will give you the host.
0
 
banumynameAuthor Commented:
slightwv  ...i already had alook at that doc ...but no use

any way Thanks  a lot
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
slightwv (䄆 Netminder) Commented:
Leave this open for a while.  Maybe other Experts that use a recovery catalog will know things I don't.
0
 
banumynameAuthor Commented:
will do ...
Thanks slightwv
0
 
banumynameAuthor Commented:
Thanks Rindbaek...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.