Re: MV and Dataguard

From: Andy Klock <andy_at_oracledepot.com>
Date: Wed, 1 Jun 2016 12:52:34 -0400
Message-ID: <CADo_RaNrq0ukRWGnrSbTjiaRhxq=FS97Yg6o_WsJ9KH7SZZpLQ_at_mail.gmail.com>

Physical or Logical standbys? Physical should work as expected, but logicals need to be considered:

https://docs.oracle.com/cd/E11882_01/server.112/e41134/manage_ls.htm#SBYDB4833

On Wed, Jun 1, 2016 at 12:13 PM, Sanjay Mishra <dmarc-noreply_at_freelists.org> wrote:

> Has anyone used MV with Dataguard ?
>
> If I had MV log on Primary and does the Standby will also have Data
> refreshed in both base tables as well as MV logs ?
> If MV log has the data, then Can we use it after switchover to Dataguard
> to Fast refresh the Target remote Database MV's ?
>
> TIA
> Sanjay
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 01 2016 - 18:52:34 CEST