Switch Over to Standby Database While Oracle Dataguard Being Used for Replication

###########################################
Please perform below activity on Primary Database
###########################################

export ORACLE_SID=test

sqlplus "/as sysdba"


select name,open_mode,log_mode,database_role from v$database;

show parameter log_archive_dest_2;

SELECT username  FROM v$session WHERE status = 'ACTIVE' AND username IS NOT NULL AND username not in ('SYS','SYSTEM') ;


select name, database_role, switchover_status from V$database;

select max(sequence#) from v$log_history;

select max(sequence#) from v$archived_log ;


alter database commit to switchover to physical standby with session shutdown;

shutdown immediate;

exit;

sqlplus "/as sysdba"

startup mount ;

sho parameter log_archive_dest_state_2

alter system set log_archive_dest_state_2=defer;

show parameter log_archive_dest_state_2

alter database recover managed standby database disconnect from session;

select name,open_mode,log_mode,database_role from v$database;


##############################################
Please perform the below activities on Standby database
##############################################

export ORACLE_SID=test

sqlplus "/as sysdba"

select name,open_mode,log_mode,database_role from v$database;

show parameter log_archive_dest_2;


select name, database_role, switchover_status from V$database;

select max(sequence#) from v$log_history;

select max(sequence#) from v$archived_log where applied ='YES' ;

alter database commit to switchover to primary with session shutdown;

shutdown immediate

exit

sqlplus "/as sysdba"

startup  mount ;

sho parameter log_archive_dest_state_2

alter system set log_archive_dest_state_2=ENABLE;

show parameter log_archive_dest_state_2

alter database open ;

select name,open_mode,log_mode,database_role from v$database;

alter system switch logfile;

alter system switch logfile;