OraFAQ Forum: Replication » Oracle Replicate Database and failover or switchover

Home » Server Options » Replication » Oracle Replicate Database and failover or switchover (Oracle 11g R2)

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

Oracle Replicate Database and failover or switchover [message #591535]

Mon, 29 July 2013 09:42

akinur
Messages: 12
Registered: July 2013
Location: Canada

Junior Member

How can I replicate 2 production database? I know I can use Data Guard. But is there any other way or Data Guard is the best way?

I want to know about:
1) Replication of production database
2) If one go down another will take charge

Report message to a moderator

Re: Oracle Replicate Database and failover or switchover [message #591536 is a reply to message #591535]

Mon, 29 July 2013 09:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

post complete results from SQL below

SELECT * FROM V$VERSION;

Report message to a moderator

Re: Oracle Replicate Database and failover or switchover [message #591537 is a reply to message #591536]

Mon, 29 July 2013 09:51

akinur
Messages: 12
Registered: July 2013
Location: Canada

Junior Member

Here it is

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Solaris: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

Report message to a moderator

Re: Oracle Replicate Database and failover or switchover [message #591538 is a reply to message #591536]

Mon, 29 July 2013 09:53

akinur
Messages: 12
Registered: July 2013
Location: Canada

Junior Member

If possible pleae let me know your database expertise

Report message to a moderator

Re: Oracle Replicate Database and failover or switchover [message #591541 is a reply to message #591535]

Mon, 29 July 2013 10:38

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There are many ways with their pros and cons but "Enterprise Manager" forum is not the good one to find them.
I move your topic to "Replication" forum where you will find many answers to your question (just use the "Search" link top the page below the banner.

Regards
Michel

Report message to a moderator

Re: Oracle Replicate Database and failover or switchover [message #591642 is a reply to message #591535]

Tue, 30 July 2013 07:52

akinur
Messages: 12
Registered: July 2013
Location: Canada

Junior Member

Any anserS for:
1) Replication of production database
2) If one go down another will take charge

Report message to a moderator

Re: Oracle Replicate Database and failover or switchover [message #591650 is a reply to message #591642]

Tue, 30 July 2013 08:24

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Did you search?

Anyway, standby database is THE solution designed to fulfill 1 and 2 at the same time.

Regards
Michel

Report message to a moderator

Re: Oracle Replicate Database and failover or switchover [message #591670 is a reply to message #591650]

Tue, 30 July 2013 14:42

akinur
Messages: 12
Registered: July 2013
Location: Canada

Junior Member

> Did you search?
- What do you think?

> Anyway, standby database is THE solution designed to fulfill 1 and 2 at the same time.
- Great answer!

Report message to a moderator

Re: Oracle Replicate Database and failover or switchover [message #591688 is a reply to message #591670]

Wed, 31 July 2013 00:32

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

> Did you search?
- What do you think?

You didn't.

Quote:

> Anyway, standby database is THE solution designed to fulfill 1 and 2 at the same time.
- Great answer!

Thanks.

Regards
Michel

Report message to a moderator

Previous Topic:	Suggestions sought on replication
Next Topic:	oracle streams

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 17 11:00:30 CDT 2025