| Manual failover to standby db without RAC and DG? [message #584324] |
Mon, 13 May 2013 00:34  |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
Hi
I would like to know if it is possible to create a failover setup without RAC and DG
For example:
I have 11.2.0.2 database (with EBS 12.1.3) on dbnode1
I would like to create another node to failover my primary datbas in case of any failure.
Steps i will follow:
1: creat dbnode2
2: install same os as dbnode1
3: install same oracle as dbnode1
4: share dbnode2
database between dbnode1
and dbnode2
Now, if hardware fails on dbnode1, can i manually failover and start my database on
dbnode2?
I know we can do with RAC and DG,
BUT without RAC and DG If not possible, Kindly explain me, why i cannot do it (TechnicallY)
|
|
|
|
| Re: Manual failover to standby db without RAC and DG? [message #584354 is a reply to message #584324] |
Mon, 13 May 2013 05:50  |
John Watson
Messages: 8804
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
I think what you are describing would mean mounting the database storage on node dbnode1, and then in the event of a problem unmounting it from dbnode1 and re-mounting it on dbnode2. That is certainly possible: it is the way Oracle Fail Safe works under Windows. You would need to think about using, and relocating, a virtual IP address and hostname.
|
|
|
|
| Re: Manual failover to standby db without RAC and DG? [message #584362 is a reply to message #584354] |
Mon, 13 May 2013 06:36 |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
Yes John,
This is exactly what i meant but for HP-UX not for Windows.
I read that Oracle Failsafe is specific to Windows.
Is there any similar solution for unix.
I check with oracle they say, it is doable but i need to know any best practices
and thinks to be considered seriously.
Regards,
|
|
|
|
| Re: Manual failover to standby db without RAC and DG? [message #584365 is a reply to message #584362] |
Mon, 13 May 2013 06:58 |
John Watson
Messages: 8804
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
In your first post, you asked if it possible. I told you that it is. Now you say that you had ALREADY asked Oracle about this, and got the same answer.
So now you have the same answer twice. How many more times do you want it?
I've described the general technique, think about it and have a go.
|
|
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
