-
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|