Home » Server Options » Data Guard » Standby Swtich over
Standby Swtich over [message #171216] Tue, 09 May 2006 01:45 Go to next message
Messages: 24
Registered: April 2006
Junior Member

Is there a way where if the primary db fails, the standby can take over automatically and all my application pointing to primary can automatically point to standby database.

What is the ideal bandwidth for implementing remote standby?

Re: Standby Swtich over [message #171275 is a reply to message #171216] Tue, 09 May 2006 04:41 Go to previous messageGo to next message
Messages: 242
Registered: February 2006
Senior Member
1)A functionality what You need is implemeted by RAC.
2)The size of bandwidth depends from the size of generating logs in your database.
Re: Standby Swtich over [message #172061 is a reply to message #171216] Sat, 13 May 2006 23:11 Go to previous messageGo to next message
Messages: 4
Registered: March 2006
Location: India
Junior Member

o As per my knowldge, Switchover can not take automatically, though it is easy in 10g.

Applications which are using primary database cab be used
your standby database
[ which will act as primary after role swithover ]

You just need to put a single line in your tnsnames.ora
the whole address string for standby database
and [ failover on ] -- not exactly remember the syntax

Re: Standby Swtich over [message #173850 is a reply to message #172061] Wed, 24 May 2006 16:44 Go to previous message
Messages: 34
Registered: May 2006
Location: West Des Moines
I agree with Jagjeet, switchover can not happen automatically.

Previous Topic: Performance Problem due to standby database
Next Topic: Error accessing package DBMS_APPLICATION_INFO
Goto Forum:

Current Time: Wed Mar 03 06:21:24 CST 2021