during the role transition (from primary to physical standby) if we issue below command what will happen to the sessions already connected on the primary database.
- Code: Select all
alter database commit to switchover to primary with session shutdown
I would like to know if we change the database role from primary to standby does all existing connections on primary will get reconnected or failed over to physical standby?