(一)从主库切到物理备库
主库查看当前可切换状态
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
--------------------
SESSIONS ACTIVE
主库查看当前活动的用户会话
SQL> select program,type from v$session where type='USER';
PROGRAM TYPE
------------------------------------------------ -----...