DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: RMAN commands

  1. #1
    Join Date
    Oct 2006
    Posts
    11

    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.

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  3. #3
    Join Date
    Oct 2006
    Posts
    11
    I tried that, but unfortunately the DBIDs are the same.

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  5. #5
    Join Date
    Oct 2006
    Posts
    11
    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
  •  


Click Here to Expand Forum to Full Width