Re: Oracle Materialized Views in a RAC
From: sandeep pande <sandy.soft80_at_gmail.com>
Date: Tue, 11 May 2010 01:16:31 -0700 (PDT)
Message-ID: <fcfa8a11-d864-4327-9365-1e34599fa384_at_p5g2000pri.googlegroups.com>
On Apr 9, 3:42 am, Ora_DBA <sanjaydharmadhik..._at_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.
Date: Tue, 11 May 2010 01:16:31 -0700 (PDT)
Message-ID: <fcfa8a11-d864-4327-9365-1e34599fa384_at_p5g2000pri.googlegroups.com>
On Apr 9, 3:42 am, Ora_DBA <sanjaydharmadhik..._at_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.
Hi,
On RAC there is a single database. Each RAC instance runs on the very
same database.
RAC is a shared everything architecture - nothing at all like the inferior (shared nothing) cluster technologies used by many of the other database vendors.
In other words, a database resource (table/sequence/view/procedure/ etc) is available on all that database's cluster instances.
Regards
Sandy
Received on Tue May 11 2010 - 03:16:31 CDT