Home » Server Options » Data Guard » Multiple Logical standby (Oracle 11g on RedHat Linux 6)
Multiple Logical standby [message #656097] Thu, 22 September 2016 09:05 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
John Watson
Messages: 8978
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jun 09 16:15:53 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.