Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Materialized Views in a RAC

771994May 11 2010 — edited May 11 2010
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.
Sandeep

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 8 2010
Added on May 11 2010
#performance-availability, #rac, #real-application-clusters
1 comment
1,911 views