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;
=============================
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