SQL> alter database commit to switchover to primary;
alter database commit to switchover to primary
*
ERROR at line 1:
ORA-01093: alter database close only permitted with no sessions connected
SQL> select id, process, program from v$session where type = 'USER' and sid <> (select distinct sid FROM V$mystat);
解决办法:
方法1:
1. alter database commit to switchover to primary with session shutdown;
方法2:
kill -9 进程ID
alter database commit to switchover to primary