How to find the catalog database name

[vnktummala]

Hi:

I have multiple catalog databases in the environment. From a given target database how to find in which catalog it is registered? Is there is any V$ or DBA_ view available?

Thanks,
-Vijay

[Tuma]

what catalog are you referring to? RMAN?.

[vnktummala]

Sorry, I should have be more clear.

Yes, I am refering the RMAN Catalog.

Thanks,

[Tuma]

If don't of any command that would give you the databases in the catalog. but if I want want to see if database ABB is in the catalog
-connect to the catalog from database/sid ABB.
-give a command
- list backups or crosscheck backups or list incarnation etc etc.
-Now if the database is not registered RMAN would return error - database not registered in catalog...

[vnktummala]

Yes, once we connect to RMAN catalog there are lot many way to investigate. But, I am trying to find is there any view available on the target database. I have tried in many places including metalink but could not find any thing and finally landed at my favourate forum.

Thanks,

[hrishy]

Hi

One way i cna think of is when you do
rman TARGET / CATALOG rman/cat@catdb

the catdb entry should be there in the tnsnames.ora file on the target db server.

regards
Hrishy

[BV1963]

TABLE DB in recovery catalog schema has a dbid which would match to your database id.