1
Vote

Log for Oracle 11g XML Format Event/Alert

description

Howto parse alert log (xml format) version oracle 11G
 
If possible add template format default.

file attachments

comments

gituncar wrote Mar 30, 2010 at 1:53 PM

Example

Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter



Thread 1 advanced to log sequence 40 (LGWR switch)



Current log# 1 seq# 40 mem# 0: C:\ORACLE\ORADATA\RPROODS\REDO01.LOG



Archived Log entry 19 added for thread 1 sequence 39 ID 0x388f6ee4 dest 1:



Clearing Resource Manager plan via parameter

sergeys wrote Mar 31, 2010 at 2:37 PM

gituncar, thanks for the sample. The format is very easy to parse. The first version of format description is attached. Please take a look and give your feedback if it works OK on your real logs. You need to put Oracle-11g-alert-log-xml.format.xml to Formats folder. I have several quiestions:
  • What extension does this log have? *.xml or somthing else?
  • What does pid attribute mean? Process ID?
  • What does level attribute mean? Level of severity? It yes, what values are considered to be info, warning and error?

gituncar wrote Mar 31, 2010 at 3:45 PM

Oracle-11g-alert-log-xml.format.xml to Formats folder. I have several quiestions:
  • What extension does this log have? *.xml or somthing else?
    R: File extension is .xml (physical file: log.xml)
  • What does pid attribute mean? Process ID?
    R: pid is Process ID of the session, It's a number that management by Oracle.
  • What does level attribute mean? Level of severity? It yes, what values are considered to be info, warning and error?
    R: If possible that values are considered as warning/error/info join with type,
    http://download.oracle.com/docs/cd/E11882_01/server.112/e10713/startup.htm#CNCPT89063
Attach real log file.

sergeys wrote Apr 2, 2010 at 2:34 PM

I updated the template in the attachments. It will be included into the next release.

gituncar wrote Apr 5, 2010 at 4:03 PM

Thanks