RE: MV and Dataguard
Date: Wed, 1 Jun 2016 09:48:00 -0700
Message-ID: <008601d1bc25$612dac10$23890430$_at_comcast.net>
Yes with a physical standby you can refresh from the MV log on the DG side after failover.
There are of course potential bugs/features sometimes if the failover happens at the right moment as the MV initializes on the original Primary side that you may get the ‘ORA-12034: materialized view log on ''.'' younger than last refresh’ after failover. Just depends on how many MV logs and MVs are running and of course the roll of the dice when the failover occurs. My experience has been 2 such errors in 5 years over 121 database failovers for databases with Materialized Views/Snapshots on 10g/11g. I haven’t seen it occur in 12c yet.
Matthew Parker
Chief Technologist
Dimensional DBA
425-891-7934 (cell)
D&B 047931344
CAGE 7J5S7
<mailto:Dimensional.dba_at_comcast.net> Dimensional.dba_at_comcast.net
<http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's profile on LinkedIn
<http://www.dimensionaldba.com/> www.dimensionaldba.com
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra (Redacted sender "smishra_97" for DMARC)
Sent: Wednesday, June 1, 2016 9:14 AM
To: Oracle-l Digest Users
Subject: MV and Dataguard
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-lReceived on Wed Jun 01 2016 - 18:48:00 CEST