Rapid oracle archive log generation issue

book

Article ID: 159515

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

Oracle 10.2.0.x running in Archive log mode begins generating many archive logs without accompanying traffic increase (about one every couple of seconds). Space in the Archive log directory is rapidly consumed.

Resolution

Issue

Oracle 10.2.0.x running in Archive log mode begins generating many archive logs without accompanying traffic increase (about one every couple of seconds).  Space in the Archive log directory is rapidly consumed.

No overt issues on the Oracle side: alert.log showing hyperactivity of the archive log generation.

Cause

Incident persister has a stuck incident.

Symptom

Massive number of archive logs being generated and presence of "ORA-01461: can bind a LONG value only for insert into a LONG column" in the incident persister log.

INFO   | jvm 1    | 2008/05/01 13:41:01 | * sql statement was 'INSERT INTO MessageComponent (messageComponentID,messageID,name,MIMEType,componentType,component,originalSize,crackedComponent,crackedEncoding,wasCracked,documentFormat,componentMetaInfo,messageComponentSaved,keyAlias) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?) '
INFO   | jvm 1    | 2008/05/01 13:41:01 | * Exception message is [ORA-01461: can bind a LONG value only for insert into a LONG column

Quick fix

Deletion of the stuck incident.

Long term remedy

Application of Hotfix: 9219