OraFAQ Forum: Data Guard » Can a logical database be applied from a physical standby

Home » Server Options » Data Guard » Can a logical database be applied from a physical standby (Can a logical database be applied from a physical standby)

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

Can a logical database be applied from a physical standby [message #591196]

Thu, 25 July 2013 08:00

jai_baba
Messages: 3
Registered: July 2013
Location: india

Junior Member

Dear All,

please help me ,i am waiting for your reply...............

I have a setup where i have one physical and logical standby from a primary database. In case of switch over between primary and physical database my logical apply gets stopped. Can a logical database be applied from a physical standby ?? Please help...

Report message to a moderator

Re: Can a logical database be applied from a physical standby [message #591200 is a reply to message #591196]

Thu, 25 July 2013 08:19

John Watson
Messages: 9000
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and please read How to use [code] tags and make your code easier to read

With regard to your question, you can certainly direct redo from the new primary to your logical standby. Best way is to automate the whole switchover process by enabling te Data Guard Broker.

Report message to a moderator

Re: Can a logical database be applied from a physical standby [message #591257 is a reply to message #591200]

Fri, 26 July 2013 00:25

jai_baba
Messages: 3
Registered: July 2013
Location: india

Junior Member

Dear John Watson ,

here my setup..

proddb---primary database
prodlg----logical standby database.
prodph----physical standby database.

after switchover..........
primary(proddb) convert to standby,
physical standby(prodph) convert to primary.
but now sql not apply to local standby (prodlg)

it this situation what can i do.....is it possible or not?

Report message to a moderator

Re: Can a logical database be applied from a physical standby [message #591275 is a reply to message #591257]

Fri, 26 July 2013 02:24

John Watson
Messages: 9000
Registered: January 2010
Location: Global Village

Senior Member

I've already told you what to do.

Report message to a moderator

Re: Can a logical database be applied from a physical standby [message #591306 is a reply to message #591275]

Fri, 26 July 2013 04:34

jai_baba
Messages: 3
Registered: July 2013
Location: india

Junior Member

hi John Watson ,

Can a logical database be applied from a physical standby...
in my situation ..
now sql not apply to local standby (prodlg)
....is possible or not??

Report message to a moderator

Re: Can a logical database be applied from a physical standby [message #591353 is a reply to message #591306]

Fri, 26 July 2013 11:24

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

Senior Member
Account Moderator

Yes it is possible and John told you how.
You can repost the same question how many times you want, the answer will be the same one.

Regards
Michel

Report message to a moderator

Previous Topic:	Dataguard Issue - Logs get shipped but not Applied - Due to Primary DB reset (merged)
Next Topic:	Dataguard encryption

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 16 16:31:46 CDT 2026