Failover - Physical Standby

      [oracle@standby ~]$ sqlplus / as sysdba
 
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Aug 10 07:16:04 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved. 
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
 
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
 
Database altered.
 
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;
 
Database altered.
 
SQL> select SWITCHOVER_STATUS from V$DATABASE;
 
SWITCHOVER_STATUS
--------------------
TO PRIMARY
 
v  Switch standby to primary
 
SQL> alter database commit to switchover to primary with session shutdown;
 
Database altered.
 
SQL> alter database open;
 
Database altered.
 
SQL> select name, open_mode, db_unique_name, database_role from v$database;
 
NAME      OPEN_MODE            DB_UNIQUE_NAME                 DATABASE_ROLE
--------- -------------------- ------------------------------ ----------------
MAXCDB    READ WRITE           stand                          PRIMARY