This content has been marked as final. Show 3 replies
Please help me to find view to check the catalog database name which is connected to my target databaseYou can check for any RMAN backup jobs that been scheduled on the server.
In the scheduled script check rman command.
You can then identify the database alias (of the catalog db) that is used in the rman backup script.
Once you have found the database alias, check for the database alias entry in tnsnames.ora file present in your target database server.
Once the entry is found, you can find the IP address and catalog db name from the tns entry.
Edited by: st. osh on Nov 22, 2012 11:38 PM
1 person found this helpful
We can check the catalog database name from the following ways but I want views to check it from target databaseNo. The Target database does not "register" the catalog database name anywhere.
Hemant K Chitale