10gDataGuard在备库需要切换为主库时,遇到以下的问题:
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE
SWITCHOVER_STATUS
--------------------
SWITCHOVER LATENT
原因是因为备库目前不在apply redo状态,执行以下命令
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE disconnect from session;
Database altered.
再次查询:
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
--------------------
TO PRIMARY
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE
SWITCHOVER_STATUS
--------------------
SWITCHOVER LATENT
原因是因为备库目前不在apply redo状态,执行以下命令
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE disconnect from session;
Database altered.
再次查询:
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
--------------------
TO PRIMARY