Tuesday, March 8, 2022

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;


No comments:

Post a Comment