error:unable to get logical block size for spfile

還不算暈發表於2016-02-23

朋友遇到了這個問題,發來看到後,第一反應是spfile出了問題,可能是被人為修改損壞或檔案損壞;

排除人為修改導致檔案損壞或其它原因的檔案損壞後,此問題ORACLE網站上有一個解決方法:

Below is their response to my SR:
-------------------------------------------------------------------------------------
Ok, after reviewing everything there seems to be no problem to fix. All configurations are correct. We believe these errors are benign and can be ignored.

OBSERVATIONS
===============
- The ASM Instance is Online.
- The Diskgroup: +XXXXXX_SYSTEM is mounted and has both physical and logical sector size of 512 bytes.
- No error messages in ASM Alert log.

Considering the above facts, the message "ERROR: Unable to get logical block size for spfile" looks benign and can be ignored.

However, to avoid getting these messages, as a workaround, you can try creating pfile from the spfile '+XXXXXX_SYSTEM/XXXXXX/spfileXXXXXX.ora' and then again try creating spfile in diskgroup +XXXXXX_SYSTEM using this pfile.

即在確認無異常卻仍有此報錯時,可以忽略,或者通過重建spfile來嘗試解決此報錯;

相關文章