Attention.log is a feature, which was introduced in Oracle Database 21c, designed to capture high-level summaries of significant database events and activities. It differs from the alert.log in following points:<\/p>\n\n\n\n
High-Level Summaries<\/strong>: The attention.log focuses on summarizing critical and significant events rather than logging every minor detail, including database startups and shutdowns, major configuration changes, errors or warnings that need immediate attention.<\/p>\n\n\n\n Consolidation of Critical Events<\/strong>: It provides a consolidated view of the most important events, making it easier for database administrators to quickly review and identify critical issues without rummaging through through detailed logs.<\/p>\n\n\n\n Accessibility<\/strong>: Designed to be easily readable and quickly accessible for a high-level overview of the database\u2019s health and significant activities.<\/p>\n\n\n\n Complementary to Alert Log<\/strong>: While the attention.log highlights major events, it complements the alert.log rather than replacing it. Database administrators can use the attention.log for a quick overview and the alert.log for detailed diagnostics.<\/p>\n\n\n\n Location<\/strong>: Like the alert.log, the attention.log is also found in the DIAGNOSTIC_DEST directory, usually under $ORACLE_BASE\/diag\/rdbms\/<db_name>\/<instance_name>\/log.<\/p>\n\n\n\n It can be very helpful for not so experienced database administrators or to get a quick overview in difficult or unexpected cases, as I had on a productive environment some time ago: an internal error had occurred, the database crashed and the alert.log was far too large to read without splitting it up which of course makes troubleshooting unnecessarily difficult (under time pressure).<\/p>\n\n\n\n The location of the attention log can be found by querying the The oracle documentation proposes to query the V$DIAG_ALERT_EXT view to get relevant attention.log information, but it is a view over the XML-based alert.log (in the Automatic Diagnostic Repository for the current container), not the attention log! But nevertheless we can get very useful information out of it, divided into the same categories as in the attention.log:<\/p>\n\n\n\n Querying MESSAGE_LEVEL:<\/p>\n\n\n\n MESSAGE_TYPE:<\/p>\n\n\n\n Opening the attention.log with vi<\/p>\n\n\n\n will give you an output like this (JSON formatted), which is obviously pretty comfortable to read:<\/p>\n\n\n\n It is possible to convert the output into plain text format:<\/p>\n\n\n\n which gives us a formatted expression that might look like this:<\/p>\n\n\n\n Severity Levels<\/strong>: Entries are tagged with severity levels such as [SEVERE], [CRITICAL], [IMPORTANT] or [NORMAL] to highlight their importance.<\/p>\n\n\n\n Timestamp<\/strong>: Each entry begins with a timestamp in ISO 8601 format.<\/p>\n\n\n\n Messages and Actions<\/strong>: Each entry provides a brief description of the event and recommended actions.<\/p>\n\n\n\n Quick Identification<\/strong>: The attention.log helps DBAs quickly identify and respond to critical issues without sifting through the more detailed alert.log.<\/p>\n\n\n\n Conciseness<\/strong>: It captures only the most significant events, reducing noise and making it easier to focus on urgent matters.<\/p>\n\n\n\n Complementary to <\/strong>alert.log<\/strong>: It complements the alert.log by summarizing critical events, while the alert.log continues to provide detailed information for troubleshooting.<\/p>\n\n\n\n Overall, the attention.log is a useful addition for DBAs, enabling more efficient monitoring and quicker responses to significant database events.<\/p>\n\n\n\n https:\/\/oracle-base.com\/articles\/21c\/attention-log-oracle-database-21c<\/a><\/p>\n\n\n\nHow to get information about the attention.log:<\/strong><\/h2>\n\n\n\n
V$DIAG_INFO<\/code> view, it is in the same directory as the alert. log, (since Oracle 11g: $OH\/diag\/rdbms… )<\/p>\n\n\n\nselect name, value\nfrom v$diag_info\nwhere name = 'Attention Log';\n\nNAME VALUE\n--------------------- -------------------------------------------------------------\nAttention Log \/u01\/app\/oracle\/diag\/rdbms\/cdb1\/cdb1\/trace\/attention_cdb1.log<\/code><\/pre>\n\n\n\n--message_type 2=INCIDENT_ERROR, message_type 3=ERROR\nSELECT message_type, message_level, message_text\nFROM V$DIAG_ALERT_EXT \nWHERE message_type in (2, 3);\n\nMESSAGE_TYPE MESSAGE_LEVEL MESSAGE_TEXT\n------------ ------------- ---------------------------------------------------------\n 3 4294967295 PMON (ospid: 3565): terminating the instance due to ORA error 471 <\/code><\/pre>\n\n\n\nV$DIAG_ALERT_EXT<\/code> the most important labels are: <\/p>\n\n\n\n1<\/code>: CRITICAL<\/code>: critical errors<\/p>\n\n\n\n2<\/code>: SEVERE<\/code>: severe errors<\/p>\n\n\n\n8<\/code>: IMPORTANT<\/code>: important message<\/p>\n\n\n\n16<\/code>: NORMAL<\/code>: normal message<\/p>\n\n\n\n1<\/code>: UNKNOWN<\/code>: essentially the NULL type<\/p>\n\n\n\n2<\/code>: INCIDENT_ERROR<\/code>: the program has encountered an error for some internal or unexpected reason, and it must be reported to Oracle Support<\/p>\n\n\n\n3<\/code>:\u00a0ERROR<\/code>: an error of some kind has occurred<\/p>\n\n\n\n4<\/code>:\u00a0WARNING<\/code>: an action occurred or a condition was discovered that should be reviewed and may require action<\/p>\n\n\n\n5<\/code>:\u00a0NOTIFICATION<\/code>: reports a normal action or event, this could be a user action such as “logon completed”<\/p>\n\n\n\n6<\/code>:\u00a0TRACE<\/code>: output of a diagnostic trace<\/p>\n\n\n\nvi \/u01\/app\/oracle\/diag\/rdbms\/cdb1\/cdb1\/trace\/attention_cdb1.log<\/code><\/pre>\n\n\n\n{\nIMMEDIATE : \"PMON (ospid: 3565): terminating the instance due to ORA error 471\" \nCAUSE: \"PMON detected fatal background process death\"\nACTION: \"Termination of fatal background is not recommended, Investigate cause of process termination\"\nCLASS : CDB-INSTANCE \/ CDB_ADMIN \/ ERROR \/ DBAL-35782660\nTIME : 2024-07-10T14:15:16.159-07:00\nINFO : \"Some additional data on error PMON error\"\n}\n<\/code><\/pre>\n\n\n\njq -r '.tags[].name' input.json > output.txt<\/code><\/pre>\n\n\n\n2024-07-01T10:15:32.123456+00:00\n[SEVERE] ORA-00600: internal error code, arguments: [1234], [], [], [], [], [], [], [], [], [], []\nAction: Please contact Oracle Support Services.\n\n2024-07-01T11:20:45.789012+00:00\n[CRITICAL] ORA-01578: ORACLE data block corrupted (file # 23, block # 220734)\nAction: This error signifies a corrupted data block. The data block has been marked as corrupt. Consider restoring from backup.\n\n2024-07-02T08:42:27.654321+00:00\n[ALERT] Database instance crashed due to unexpected termination.\nAction: Investigate the cause of the instance termination. Review related logs and diagnostic information.\n\n2024-07-03T12:34:56.987654+00:00\n[INFO] System global area (SGA) resized. New size: 68GB.\nAction: No immediate action required. Monitor performance and stability.<\/code><\/pre>\n\n\n\nKey Points<\/strong><\/h2>\n\n\n\n
Benefits for DBAs<\/strong><\/h2>\n\n\n\n
Sources, Links & Blogs:<\/strong><\/h2>\n\n\n\n