Skip to main content

NetApp wins prestigious Coveo Relevance Pinnacle Award. Learn more!

INSIGHT Japan :2023年 1月25日(水)ANAインターコンチネンタルホテル開催 へ参加・申込を行う

NetApp Knowledge Base

What logs are helpful for volume unavailable on Oracle DB/RAC?

Views:
145
Visibility:
Public
Votes:
0
Category:
element-software
Specialty:
solidfire
Last Updated:

Applies to

  • Oracle DB/RAC
  • NetApp Element software

Answer

To triage the issue, gather the following around the time of the reported issue:

  • Host OS logs
  • Oracle AWR report
  • Database alert log
  • ASM alert log
  • CRS and CSS logs (only for RAC)

Additional Information

This set of data provides the following information:

  • Database-related
    • What was the work done during the trouble
    • How long that work took to do
    • Histogram of I/O response times
  • Any I/O failures that were observed by:
    • Database
    • ASM
    • RAC
    • OS
  • Any iSCSI recovery processing executed by the host OS

 

Scan to view the article on your device