Hi, I am using Oracle 9i RMAN and database instances. I have two instances with exactly the same name on different servers. How do I verify I am connected to the correct instance when I connect via the RMAN TARGET='sys/xxxx@db1 as sysdba' CATALOG=rman/yyyy@db2? I was thinking I could just select the host_name from v$instance, but I can not enter a sql select statement from the rman prompt.
07-26-2011, 12:26 AM
check the RMAN log for DBID and query from v$database view.
07-26-2011, 07:32 AM
I tried that, but unfortunately the DBIDs are the same.
07-26-2011, 11:47 PM
then please check the TNS entries. May be both are pointing to the same DB.
07-27-2011, 07:47 AM
yes, it looks like I was actually connected to the production instance. This setup is very confusing (I definitely didn't do it). I think I am going to add new entries to each tnsnames with the servername and instance name to distinguish the difference. That should help.