Manual Switchover In Oracle Database (19c)
Primary Database:
tnsping QPROD
tnsping QPRODR
echo $ORACLE_SIDsqlplus / 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:
Standby Database:
tnsping QPROD
tnsping QPRODR
echo $ORACLE_SID
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> 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;
SQL> select name,instance_name,status,database_role,open_mode from v$instance,v$database;
No comments:
Post a Comment