Home » Server Options » Data Guard » switchback to primary database (ORACLE 10G R2)
switchback to primary database [message #355084] Wed, 22 October 2008 09:08 Go to next message
cwillian
Messages: 4
Registered: October 2008
Location: RIO DE JANEIRO
Junior Member
One time activated standby database,
Is it possible switchback to primary database without restore backup ? although i had set up primary database to be a new standby database receiving and applying the archives, so they are synchronized.

Tks
Re: switchback to primary database [message #355088 is a reply to message #355084] Wed, 22 October 2008 10:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
With or without dataguard broker?

Maybe the following will help:
Data Guard Concepts and Administration
Chapter 7 Role Transitions

Regards
Michel
Re: switchback to primary database [message #355094 is a reply to message #355088] Wed, 22 October 2008 11:28 Go to previous messageGo to next message
cwillian
Messages: 4
Registered: October 2008
Location: RIO DE JANEIRO
Junior Member
without Dataguard.

My version is standard database.
Re: switchback to primary database [message #355096 is a reply to message #355094] Wed, 22 October 2008 11:40 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Data Guard isn't available in Standard Edition.
Re: switchback to primary database [message #355098 is a reply to message #355096] Wed, 22 October 2008 11:45 Go to previous messageGo to next message
cwillian
Messages: 4
Registered: October 2008
Location: RIO DE JANEIRO
Junior Member
I know,

But i´m using Standby database manually
Re: switchback to primary database [message #355099 is a reply to message #355098] Wed, 22 October 2008 11:47 Go to previous messageGo to next message
cwillian
Messages: 4
Registered: October 2008
Location: RIO DE JANEIRO
Junior Member
I know,

But i am using Standby database manually

Re: switchback to primary database [message #355102 is a reply to message #355099] Wed, 22 October 2008 11:59 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In this case you have to recreate the primary before switching back as you created the standby.

Regards
Michel
Previous Topic: physical standby database
Next Topic: enable configuration in data guard borker (merged)
Goto Forum:
  


Current Time: Sat Dec 03 18:34:38 CST 2016

Total time taken to generate the page: 0.19712 seconds