Advance Replication Server Down ?

27 Aug

Apa yang terjadi jika Advance Replikasi, yang menghubungkan kantor pusat [sid = orcl1] dengan kantor cabang [sid = orcl2] salah satu servernya Down ? berikut demonya.
a. dimana server kantor cabang [sid = orcl2] down
replikasi_db_down_01
b. server kantor pusat [sid = orcl1] up dan sedang melakukan transaksi [insert data]

SQL> conn scott/tiger@orcl1
SQL> insert into dept values (51,’dept’,’dept’,systimestamp);
SQL> insert into dept values (52,’dept’,’dept’,systimestamp);
SQL> insert into dept values (53,’dept’,’dept’,systimestamp);
SQL> insert into dept values (54,’dept’,’dept’,systimestamp);
SQL> insert into dept values (55,’dept’,’dept’,systimestamp);
SQL> commit;
replikasi_db_down_02
c. beberapa saat kemudian server kantor cabang [sid = orcl2] up kembali
replikasi_db_down_03
d. jreng – jreng ……
replikasi_db_down_04

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: