Oracle-CRSCTL命令显示备库状态不正确

现象

备库状态变成了Open,而不是预期的Open,Readonly

$ crsctl stat res -t -w "TYPE = ora.database.type"
ora.orcl.db
1 ONLINE ONLINE <hostname01> Open
2 ONLINE ONLINE <hostname02> Open
3 ONLINE ONLINE <hostname03> Open
4 ONLINE ONLINE <hostname04> Open

原因

This change in behavior is introduced by the fix for bug 14630237 found in version 11.2.0.4.

The issue has been reported in

Bug 17927970 : STANDBY DATABASE STATUS WRONGLY DISPLAYED BY CRSCTL UTILITY

解决方案

Apply patch 17927970 【Oracle 11.2.0.4.2 for OCW】

Oracle-CRSCTL命令显示备库状态不正确

上一篇:MSSQL Server 13位时间戳互转


下一篇:sql server DMV汇总