OraFAQ Forum: Data Guard » Multiple Logical standby

Home » Server Options » Data Guard » Multiple Logical standby (Oracle 11g on RedHat Linux 6)

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

Multiple Logical standby [message #656097]

Thu, 22 September 2016 09:05

caprikar
Messages: 226
Registered: March 2007

Senior Member

Hi,
I have a logical standby database setup from primary and the standby database is a superset of primary database. We have a requirement to build another Logical standby database from the existing logical database and make the primary apply the logs to both the logical standby database. Is that is possible?

Report message to a moderator

Re: Multiple Logical standby [message #656102 is a reply to message #656097]

Thu, 22 September 2016 10:07

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

Senior Member
Account Moderator

Then you build this secondary standby from the primary like you did it from the first one.

Report message to a moderator

Re: Multiple Logical standby [message #656107 is a reply to message #656102]

Thu, 22 September 2016 12:15

caprikar
Messages: 226
Registered: March 2007

Senior Member

The issue is, the existing logical standby database data is super set of the primary, so we need to have the data same as the logical standby database.

Report message to a moderator

Re: Multiple Logical standby [message #656108 is a reply to message #656107]

Thu, 22 September 2016 12:21

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

Senior Member
Account Moderator

So the second standby is a standby of the first standby and not of the primary and so must be updated when the first standby is updated and not when the primary is but if your system is well tuned and configured, it is the same thing.

Report message to a moderator

Re: Multiple Logical standby [message #656109 is a reply to message #656108]

Thu, 22 September 2016 12:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>The issue is, the existing logical standby database data is super set of the primary,
post DDL that resulted in this "super set" of the primary

Report message to a moderator

Re: Multiple Logical standby [message #656110 is a reply to message #656108]

Thu, 22 September 2016 12:48

caprikar
Messages: 226
Registered: March 2007

Senior Member

so, are you saying it is possible to build a logical standby database from another logical standby db? let me know.

Report message to a moderator

Re: Multiple Logical standby [message #656112 is a reply to message #656110]

Thu, 22 September 2016 12:59

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

Senior Member
Account Moderator

Yes, this is possible, a logical standby is a database like any other one.

Report message to a moderator

Re: Multiple Logical standby [message #656116 is a reply to message #656110]

Fri, 23 September 2016 01:21

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

Senior Member

You may be able to make this work (search for "cascading standby") but it is not supported. In release 12 cascading standby is supported, but only for physical standbys, not logical.

Report message to a moderator

Previous Topic:	archive log gap
Next Topic:	Unable to duplicate datafile of "SYSTEM" tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jun 02 17:34:21 CDT 2025