Skip to main content
NetApp Knowledge Base

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

Views:
82
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