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?
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: 65202
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

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.
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: 65202
Registered: March 2007
Location: Nanterre, France, http://...
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.

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: 25719
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
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.
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: 65202
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

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: 7150
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.
Previous Topic: PING[ARCX]: Heartbeat failed to connect to standby 'XXX'. Error is 1034
Next Topic: Unable to duplicate datafile of "SYSTEM" tablespace
Goto Forum:
  


Current Time: Wed Nov 22 12:42:00 CST 2017

Total time taken to generate the page: 0.02615 seconds