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;