Manual Switchover In Oracle Database (19c)

Manual Switchover In Oracle Database (19c)

Primary Database:

tnsping QPROD
tnsping QPRODR

echo $ORACLE_SID

sqlplus / as sysdba

SQL> select name,status,database_role,open_mode from v$instance,v$database;

SQL> select switchover_status from v$database;
SQL> alter database commit to switchover to physical standby with session shutdown;

SQL> !ps -ef|grep pmon
SQL> exit

(or)
SQL> shutdown immediate;

SQL> startup mount;
SQL> select name,instance_name,status,database_role,open_mode from v$instance,v$database;

SQL> recover managed standby database disconnect from session;

SQL> !ps -ef | grep mrp

SQL> !lsnrctl status

Standby Database:

tnsping QPROD

tnsping QPRODR

echo $ORACLE_SID

sqlplus / as sysdba

SQL> select name,instance_name,status,database_role,open_mode from v$instance,v$database;
SQL> alter database commit to switchover to primary;

SQL> select name,instance_name,status,database_role,open_mode from v$instance,v$database;

SQL> alter database open;
SQL> select name,instance_name,status,database_role,open_mode from v$instance,v$database;