Oracle Materialized Views in a RAC
in [Oracle Help]
|
Prev: Can OLAP cubes containing summaries, be used for queries for single subscriber?
Next: Is there a column-data-type restricted to truncated date format?
From: Ora_DBA on 8 Apr 2010 18:42 We have a source database which is Oracle 11g RAC. The target database is a stand laone database (11g). We need to create Materialized View in the Target database based on tables in the RAC source database. The Refresh method is Refresh Fast on Demand. Is the process of creating Materialized View Logs in a RAC same as the one for creating MV logs in a stand alone database ? What if the instance/node in the RAC where the MV Logs are created goes down ? If the configuration of MV logs in a RAC is different from the one in a stand alone database, can you please describe in detail or point to web site that explains it in detail ? Thanks in adavance.
From: Mark D Powell on 10 Apr 2010 09:49
On Apr 8, 6:42 pm, Ora_DBA <sanjaydharmadhik...(a)gmail.com> wrote: > We have a source database which is Oracle 11g RAC. The target database > is a stand laone database (11g). > > We need to create Materialized View in the Target database based on > tables in the RAC source database. > > The Refresh method is Refresh Fast on Demand. > > Is the process of creating Materialized View Logs in a RAC same as the > one for creating MV logs in a stand alone database ? What if the > instance/node in the RAC where the MV Logs are created goes down ? > > If the configuration of MV logs in a RAC is different from the one in > a stand alone database, can you please describe in detail or point to > web site that explains it in detail ? > > Thanks in adavance. Yes, the basic way you define an mview when the source is RAC is the same as when the source db is non-RAC. What happens when one instance is down depends on how you define the database link, that is, on a specific instance or capable of connecting to any available instance. HTH -- Mark D Powell -- |