Question

switch over 的NOT ALLOWED状态什么意思

Answer 1

你这个问题转化的时候会报一个错：

SQL> alter database commit to switchover to primary;

alter database commit to switchover to primary

*

ERROR at line 1:

ORA-16139: media recovery required

然后介质恢复后

SQL> alter database recover managed standby database disconnect from session;

Database altered.

在做转化就好了

SQL> alter database commit to switchover to primary;

Database altered.