catalog

I have a question about cataloge database.

In an ideal environment we create a seperate database for catalog.
Database that need to registered we register in the catalog.

from the external database how we know that what is out cataloge database.
tonydbaAsked:
Who is Participating?
 
Franck PachotConnect With a Mentor Commented:
Hi,
You can check from rman output if a recovery catalog was used:
select * from v$rman_output where lower(output) like '%catalog%';
But no way to know which catalog...
Regards,
Franck.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I only know of having 1 single (production) recovery catalog database server, even in a multi-database and multi-host oracle db environment. you register all your (production) databases into that single recovery catalog, which shall have the highest version of any of the production databases.

technically, you could register your database in several catalogs, but I don't see directly in how far that could bring any added-value,if any.

in short: you only have 1 recovery catalog, and the backup scripts refer to the rman instance, which is the recovery catalog db.
0
 
Mark GeerlingsDatabase AdministratorCommented:
I assume that you asking about a catalog database for RMAN.  Yes, it is usually best to create just one RMAN catalog database to manage the backups (and recovery if needed) for your other databases.  And yes, you then need to register each of your other databases in this RAMN database.

I do not understand what your last sentence means.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
tonydbaAuthor Commented:
I mean..
I have a database B,
I want to know from there I want to know this particular database is registeres with another catalog database ----any command
0
 
Mark GeerlingsDatabase AdministratorCommented:
From the recovery catalog you can see which databases are registered with it.  But, I don't know of a way to do the reverse: that is query to see if the database you are conencted to is registered with an RMAN catalog database, or not.
0
 
tonydbaAuthor Commented:
which query is related with catalog
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
please refer to the official documenation in that regards:
http://docs.oracle.com/cd/B10501_01/server.920/a96566/rcmquery.htm
0
 
Mark GeerlingsDatabase AdministratorCommented:
If you have RMAN open (on the catalog server), the "list" command there will show you the databases that you have registered.
0
 
tonydbaAuthor Commented:
fine..
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.