Oracle Data Guard : test switchover & failover (7)

28 Feb

19. test switchover & failover
a. primary standby yang sudah berubah menjadi standby server (sid = prmr11g), di down
SQL> shutdown immediate;
b. menambah record dari server standby yang sudah berubah menjadi primary standby (sid = stby11g)
SQL> conn scott/tiger
SQL> select * from dept;
DEPTNO DNAME LOC
———- ————– ————-
43 MK SBY
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
41 IT SBY
42 AU SBY
44 VA SBY
SQL> insert into dept values(45,’KL’,’SBY’);
SQL> commit;
c. server primary dipaksa create redo data (sid = stby11g)
SQL> conn / as sysdba
SQL> alter system switch logfile;
d. (sid = prmr11g), mount dan diset menjadi active dataguard
SQL> startup mount;
SQL> alter database open read only;
SQL> alter database recover managed standby database disconnect;

SQL> conn scott/tiger
SQL> select * from dept;
DEPTNO DNAME LOC
———- ————– ————-
43 MK SBY
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
41 IT SBY
42 AU SBY
44 VA SBY
45 KL SBY
e. Kembali ke posisi semula primary server (sid = prmr11g), standby server (sid = stby11g)
e1. lakukan switchover (server primary) (sid = stby11g)
SQL> conn / as sysdba
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;
e2. Jika sudah sukses, lakukan shutdown dan kemudian mount (server primary) (sid = stby11g)
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;

e3. SWITCHOVER TO PRIMARY (server standby) (sid = prmr11g)
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

1. oracle data guard pengertian

2. demo oracle data guard physical standby database

3. oracle data guard test pengiriman logfile

4. oracle data guard standby server untuk reporting

5. oracle data guard active data guard 11g

6. oracle data guard switchover failover

7. oracle data guard test switchover failover

8. oracle data guard lampiran initora

One Response to “Oracle Data Guard : test switchover & failover (7)”

  1. Jack Nickolson May 4, 2010 at 8:40 pm #

    I have tested Dataguard switchover using some tips from this and getting success. thanks buddy.

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: