-
RMAN commands
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.
-
check the RMAN log for DBID and query from v$database view.
Thanks,
-
I tried that, but unfortunately the DBIDs are the same.
-
then please check the TNS entries. May be both are pointing to the same DB.
Thanks,
-
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.
Thanks.