Prev: [Materialized Views over DB links]HA Problem with ORA-02019
Next: Query : Understand and Re-write
From: gazzag on 24 Mar 2010 07:09
On 24 Mar, 09:29, Jia Lu <roka...(a)gmail.com> wrote:
> Hi all
>  I created 2 multi master DBs and using materialize views to
> synchronize them.
>  The relation is Main - Sub, and when I insert/commit to either one ,
> another site's table will be updated.
>
> My problem is when DB link failed, I cannot insert data into the
> normal DB it said ORA-02019.
>
> That will be a high availability problem when one DB is down.
>
> Is there a feature can let me to update to the table when another site
> is down?
> And can it be synchronized after the db link recovered ?
>
> Thank you.
> Best
> Lau Lu.

I assume that you're on 10gR2 Standard Edition One as per your
previous thread?

If you're looking for a High Availabilty option, I doubt you should be
using Standard Edition One. Depending on your exact requirements and
budget, you might want to consider Enterprise Edition and Oracle's
DataGuard.

This document may also be worth a read:
http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10gR2_Roadmap.pdf

HTH
-g
From: Jia Lu on 24 Mar 2010 08:10
On 3月24日, 午後8:09, gazzag <gar...(a)jamms.org> wrote:
> I assume that you're on 10gR2 Standard Edition One as per your
> previous thread?
>
> If you're looking for a High Availabilty option, I doubt you should be
> using Standard Edition One.  Depending on your exact requirements and
> budget, you might want to consider Enterprise Edition and Oracle's
> DataGuard.


Thanks for your answer.
Yes I want to use EE too.
but the budget is the problem and the boss donot know anything about
Oracle.
So I have to use SEO edition to implement it.
:(

Wishes
From: Mark D Powell on 24 Mar 2010 09:06
On Mar 24, 8:10 am, Jia Lu <roka...(a)gmail.com> wrote:
> On 3月24日, 午後8:09, gazzag <gar...(a)jamms.org> wrote:
>
> > I assume that you're on 10gR2 Standard Edition One as per your
> > previous thread?
>
> > If you're looking for a High Availabilty option, I doubt you should be
> > using Standard Edition One.  Depending on your exact requirements and
> > budget, you might want to consider Enterprise Edition and Oracle's
> > DataGuard.
>
> Thanks for your answer.
> Yes I want to use EE too.
> but the budget is the problem and the boss donot know anything about
> Oracle.
> So I have to use SEO edition to implement it.
> :(
>
> Wishes

If your exiting code only works when both databases are available and
you need each database and its associated applications when the other
is unavailable then depending on how many tables you need replicated
you might consider roll your own replication.

Define database table triggers on the tables. The triggers can either
capture all changes to a tracking table and then a batch process can
run and ship the rows over deleting them on successful shipment. If
the remote database is unavailable the next run picks up the data and
tries again.

You can also have the triggers attempt to directly insert/update/
delete the remote data and only capture the change via error handling
if the remote operation fails due to the remote database being
unavailable however the performance of repeated failed remote
operations is not good to say the least.

HTH -- Mark D Powell --
 | 
Pages: 1
Prev: [Materialized Views over DB links]HA Problem with ORA-02019
Next: Query : Understand and Re-write