OraFAQ Forum: Data Guard » Standby Swtich over

Home » Server Options » Data Guard » Standby Swtich over

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Standby Swtich over [message #171216]

Tue, 09 May 2006 01:45

yash_v
Messages: 24
Registered: April 2006

Junior Member

Hi,

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?

Thanks,
Yash

Report message to a moderator

Re: Standby Swtich over [message #171275 is a reply to message #171216]

Tue, 09 May 2006 04:41

aciolac
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.

Report message to a moderator

Re: Standby Swtich over [message #172061 is a reply to message #171216]

Sat, 13 May 2006 23:11

jagjeet.malhi
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

Regards,
Js

Report message to a moderator

Re: Standby Swtich over [message #173850 is a reply to message #172061]

Wed, 24 May 2006 16:44

anurag078
Messages: 34
Registered: May 2006
Location: West Des Moines

Member

I agree with Jagjeet, switchover can not happen automatically.

Anurag

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 02 00:01:08 CST 2026