| standby database [message #59944] |
Mon, 05 January 2004 03:41  |
Praveen
Messages: 57
Registered: November 2001
|
Member |
|
|
Dear All,
I have a primary DB called "A" and a standby DB(in recovery mode) called "B".
my question is how will i make the standby DB "B" automatically start in the read-write mode once
the primary DB "A" FAILS
Thanks & Regards
Praveen
|
|
|
|
| Re: standby database [message #59963 is a reply to message #59944] |
Tue, 06 January 2004 02:40  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Hi,
whats your Oracle version ? I'm not a big fan of automatic switchover especially when there is only one standby database for the primary(becos I'll be invalidating the standby when there is a false alarm on the primary).
I generally introduce an intentional time lag between primary and standby to stop any erroneous transaction/errors propagating to the standby.
Again it depends on the client's need. And 9i DataGuard provides for such easy switchover via role transition.This could be automated in 8i also,by high frequency polling of the primary and the subsequent activation of the standby database etc.
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
