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
Printable View
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
what catalog are you referring to? RMAN?.
Sorry, I should have be more clear.
Yes, I am refering the RMAN Catalog.
Thanks,
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...
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,
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
TABLE DB in recovery catalog schema has a dbid which would match to your database id.