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

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

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

    One of best article about data guard configuration and explaination. Thanks a lot 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: