Failover test Oracle Data Guard

AT PRIMARY

untuk melakukan failover :

1. aktifkan flashback di primary

2. select flashback_on from v$database;

3. shutdown immediate

4. startup mount

5. alter database flashback on

6. alter database open

7. select flashback_on from v$database;

8. shutdown abort

AT STANDBY :

1. di standby usahakan tidak ada gap jika ada gap :

alter database register physical logfile '****.arch';

2. lakukan failover ke standby :

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;

alter database commit to switchover to primary with session shutdown;

shutdown database

startup

check scn terkahir sebelum failover

select to_char(standby_became_primary_scn) from v$database;

> 312312

di primary hidupkan dalam kondisi mount:

startup mount

flashback database to scn 312312

alter database flashback off;

kemudian shutdown database primary

dari standby yang sudah jadi primary buat controlfile yang lain yang akan

digunakan primary

alter database create standby controlfile as 'test.ctl'

cp ke primary

kemudian startup mount

dan lakukan recover managed standby

STATUS = belum dirapihkan (mode=on)