isitdevops.com/databases

Ensure all archive is present.

Ensure recovery in progress.

Check switchover status again – should be ok

SELECT SWITCHOVER_STATUS FROM V$DATABASE;

to primary

IF SESSIONS ACTIVE then error is:

ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY *

ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

—

SELECT SID, PROCESS, PROGRAM FROM V$SESSION WHERE TYPE = ‘USER’ AND SID <> (SELECT DISTINCT SID FROM V$MYSTAT);

if example shows jobs (i.e. CJQ0 is present) then

SHOW PARAMETER JOB_QUEUE_PROCESSES;

ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

If still errors then:

SELECT SID, PROCESS, PROGRAM FROM V$SESSION;

Kill the sessions.