SYS@PROD1 > SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
----------------------------------------
SWITCHOVER PENDING
SYS@PROD1 > select dest_id,sequence#,archived,applied from v$archived_log order by 1,2;
DEST_ID SEQUENCE# ARCHIV APPLIED
---------- ---------- ------ ------------------
1 16 YES NO
1 18 YES NO
2 11 YES NO
2 12 YES NO
2 13 YES NO
2 14 YES NO
2 15 YES NO
2 17 YES NO
2 19 YES NO
9 rows selected.
解决方法:
到归档路径下查看归档日志是否存在,发现需要的归档都在,于是进行应用归档日志,然后原来备库状态变为TO PRIMARY,再次切换可以正常切换了
SYS@PROD1 > alter database recover managed standby database disconnect from session;
Database altered.
SYS@PROD1 > select dest_id,sequence#,archived,applied from v$archived_log order by 1,2;
DEST_ID SEQUENCE# ARCHIV APPLIED
---------- ---------- ------ ------------------
1 16 YES YES
1 18 YES YES
2 11 YES YES
2 12 YES YES
2 13 YES YES
2 14 YES YES
2 15 YES YES
2 17 YES YES
2 19 YES YES
9 rows selected.
SYS@PROD1 > SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
----------------------------------------
TO PRIMARY
SYS@PROD1 > ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
Database altered.