Oracle 19C Dataguard Swithover without DataGuard Broker

Environment:

Oracle Version: 19.3.0
OS Version: Oracle Linux Server 8

Primary Server

DB Unique Name=pearl
DB Name=pearl
Hostname=192.168.31.201

Standby Server

DB Unique Name=muthu
DB Name=muthu
Hostname=192.168.31.202

To Confirm that the synchronization is ready to perform a switchover(primary)

alter database switchover to muthu verify;

check that there are no gaps:(prim)

select status, gap_status from v$archive_dest_status where dest_id = 2;

Run Switchover command on Primary Side:

alter database switchover to muthu;

pearl was shutdowned
muthu was mounted (verify)

select name,open_mode,database_role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
PEARL   MOUNTED              PRIMARY

Once Switchiover is Done:

Primary database is muthu
Standby database is pearl

Open the muthu is current primary:

alter database open;

select name,open_mode,database_role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
PEARL   READ WRITE           PRIMARY

Start the pearl is current standby:

startup mount

alter database open;

alter database recover managed standby database disconnect from session;