Mengkonversi Oracle 11G standby database to active standby database

1) Connect dengan sys Pengguna ke standby database

bash$ sqlplus / as sysdba

2) matikan (shutdown) database

SHUTDOWN IMMEDIATE;

3) Dimulai dengan mode database : mount.

STARTUP MOUNT;

4) Buka Database dalam mode only mode

ALTER DATABASE OPEN READ ONLY;

5) jalankan Recovery

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;