Oracle Data Guard : switchover & failover (6)

28 Feb

18. switchover & failover
a. persiapan (server primary) : Database OPEN, koneksi valid
SQL> select dest_id, destination, status, error from v$archive_dest;
DEST_ID DESTINATION STATUS ERROR
———- —————————————- ———- ———-
1 /u01/archive/prmr11g VALID
2 stby11g VALID

SQL> select DATABASE_ROLE, open_mode from v$database;
DATABASE_ROLE OPEN_MODE
—————- ———-
PRIMARY READ WRITE

b. persiapan (server standby) : Database MOUNT
SQL> select DATABASE_ROLE, open_mode from v$database;
DATABASE_ROLE OPEN_MODE
—————- ———-
PHYSICAL STANDBY MOUNTED

c. lakukan switchover (server primary) : error jika masih ada session yang aktif
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY
*
ERROR at line 1:
ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

d. Jika masih ada session yang aktif tambahkan command STANDBY WITH SESSION SHUTDOWN kemudian kill yang aktif jika perlu / tunggu sampai dengan logout (server primary)
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;

e. Jika semua sudah sukses langkah diatas, lakukan shutdown dan kemudian mount (server primary)
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;

f. SWITCHOVER TO PRIMARY (server standby)
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