Oracle Data Guard switchover checklist

Oracle Data Guard switchover checklist on standby sitesql> select * from v $ version; BANNER www.2cto.com Release Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-
64bit Production PL/SQL Release 11.2.0.3.0-Production CORE 11.2.0.3.0 Production TNS for Linux: Version 11.2.0.3.0-Production NLSRTL Version 11.2.0.3.0-Production SQL> select database_role from v $ database; DATABASE_ROLE www.2cto.com -------------- physical standby SQL> select name, value from v $ parameter where name in ('Log _ archive_dest_1 ', 'Log _ archive_dest_state_1', 'Log _ archive _
Dest_2 ', 'Log _ archive_dest_state_2'); name value Comment comment log_archive_dest_1 location =/u01/app/oracle/arch log_archive_dest_2 service = zhongwc async lgwr register valid
_ For = (online_logfile, primary_role) db_unique_name = zhongwc using enable enabling SQL> select distinct status from v $ datafile; STATUS ------- online system SQL> select distinct open_mode from v $ database; OPEN_MODE -------------------- read only with apply SQL> SELECT DISTINCT thread #, MAX (SEQUENCE #) OVER
(Partition BY thread #) maxseq _ FROM v $ archived_log; THREAD # MAXSEQ _ ---------- 1 13 SQL> select max (SEQUENCE #) "LAST_LOG_APPLIED" FROM
V $ ARCHIVED_LOG where thread # = 1 and APPLIED = 'yes'; LAST_LOG_APPLIED -------------- 13 on primary sitesql> select distinct thread #, MAX (SEQUENCE #) OVER
(Partition BY thread #) maxseq _ FROM v $ archived_log; THREAD # MAXSEQ _ ---------- 1 13 SQL> select max (SEQUENCE #) "LAST_LOG_APPLIED" FROM
V $ ARCHIVED_LOG where thread # = 1 and APPLIED = 'yes'; LAST_LOG_APPLIED -------------- 13