Tuesday, July 23, 2013

ORACLE - Data Guard - Switchover

How to perform switchover for Oracle Data Guard ?

=============================
Verification before switchover:
=============================
select switchover_status from v$database;
show parameter log_archive_dest_state
select sequence#, status, applied from v$archived_log;
alter system switch logfile;

=============================
1)old primary site:
=============================
SQL>alter database commit to switchover to physical standby with session shutdown;
SQL>shutdown immediate
SQL>startup nomount
SQL>alter database mount standby database;
SQL>alter system set log_archive_dest_state_2=defer scope=both;

=============================
2)old standby site:
=============================
SQL>select switchover_status from v$database;
SQL>alter database commit to switchover to primary;
SQL>shutdown immediate
SQL>startup

=============================
3)New standby site - START MRP -
=============================
SQL>alter database recover managed standby database disconnect from session;

No comments:

Post a Comment