检查switchover_status select switchover_status from v$database; switchover_status 的值为 UNRESOLVABLE GAP(RAC 或者非 RAC),通过以下方法解决: 检查是否有些线程已关闭但是仍存在 colinstancefora10setlines 32767selectthread#,instance,statusfromv$thread; 结果示例如下: THREAD# INSTANCE STATUS --- --- --...
RESOLVABLEGAP-Onaprimarydatabase,thisstatusindicatesthatoneormorestandbydatabaseshavearedogapthatcanbeautomaticallyresolvedbyfetchingthemissingredofromtheprimarydatabaseorfromanotherstandbydatabase. UNRESOLVABLEGAP-Onaprimarydatabase,thisstatusindicatesthatoneormorestandbydatabaseshavearedogapthatcannotbeautomatically...
If switchover_status(v$database) shows UNRESOLVABLE GAP in RAC/non RAC environment如果switchover_status(v$database)在RAC/non RAC环境中显示UNRESOLVABLE GAP 1. Check if any closed thread exists and disable (if any)检查是否存在任何关闭的thread并禁用(如果有) 1 SQL>SELECTthread#, instance, statusFR...