Oracle RAC – Hotstandby (physical)

Tags:
Oracle
I have a 2 node RAC cluster (10.2.0.1) running on AIX. For testing and documentation purposes I need to create a hot standby on the second node. I have attempted this with varying error messages. I have an SR open with Oracle but have gotten no where at all. If anyone has done this or has an idea of how to do this please reply. The instances are running on ASM with OMF. The standby also runs ASM and OMF. I am using RMAN duplicate command to try and create the standby.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

That’s an interesting issue. A physical standby on the same machine would seem to be an oxymoron since you can’t duplicate the environment exactly. I’ve done this where the hot standby is on a third machine and that worked well. Please post the resolution.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Sequential
    I know it's not my idea of a good time either but that is what I have to work with. anyway I was able to solve the problem I had actually solved it and then made a change which introduced it. Here is the problem. Set lock_name_space=standby in 10.2.0.1 this is a deprecated parameter so you get the warning. Started up the server without the RAC instances running everything seemed fine. Removed the lock parameter still everything seemed fine. Made some more changes started up standby in nomount still no problems. shut it down. Started the RAC instances useing srvctl. Then started the standby it would not start complained about the instance number being in use. Lots of trial and error later. Use the Lock_name_space parameter even though it is deprecated. Oracle support says the same thing. Go Oracle.
    0 pointsBadges:
    report
  • Sequential
    I know it's not my idea of a good time either but that is what I have to work with. anyway I was able to solve the problem I had actually solved it and then made a change which introduced it. Here is the problem. Set lock_name_space=standby in 10.2.0.1 this is a deprecated parameter so you get the warning. Started up the server without the RAC instances running everything seemed fine. Removed the lock parameter still everything seemed fine. Made some more changes started up standby in nomount still no problems. shut it down. Started the RAC instances useing srvctl. Then started the standby it would not start complained about the instance number being in use. Lots of trial and error later. Use the Lock_name_space parameter even though it is deprecated. Oracle support says the same thing. Go Oracle.
    0 pointsBadges:
    report
  • Bit4man
    Your approach makes absolutely no sense? The node is already "standby" and even active in the cluster. If the other node goes down, this one keeps on running on your clustered database. Only if your cluster goes down, does the hot standby come into play, and putting your hot standby on the same node that can go down, really defeats the purpose? Because of how CRS works you might confuse the heck out of Oracle by placing additional software in your oracle inventory. But you haven't given any details on your approach or what errors you're getting. However, as I wrote - it really makes no sense what you're trying to do. The hot-standby should be on a separate node. Please provide exact details on what you're trying to do and what errors you're getting, or do it the easy way - use a different computer for your standby database.
    0 pointsBadges:
    report
  • Oracle RAC – Hotstandby (physical) (Q/A) | Seek The Sun Slowly
    [...] Address: https://itknowledgeexchange.techtarget.com/itanswers/oracle-rac-hotstandby-physical/ (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: