RE: Weird alert log errors

  • From: "Laurent, Vincent" <Vince_Laurent@xxxxxxxxx>
  • To: Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 27 Jan 2012 14:32:58 -0600

Nope.  We use pretty generic SAP/Oracle install.
From: Jeffrey Beckstrom [mailto:JBECKSTROM@xxxxxxxxx]
Sent: Friday, January 27, 2012 2:20 PM
To: oracle-l@xxxxxxxxxxxxx; Laurent, Vincent
Subject: Re: Weird alert log errors
Could someone have been trying to run logminer and referenced that log file?

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
Information Systems
1240 W. 6th Street
Cleveland, Ohio 44113
>>> "Laurent, Vincent" 
>>> <Vince_Laurent@xxxxxxxxx<mailto:Vince_Laurent@xxxxxxxxx>> 1/27/12 3:08 PM 
>>> >>>
Saw this in one of our server logs this past week.
I have edited out the dups:
------------------------------------------
Fri Jan 20 16:06:43 2012
Archived Log entry 43943 added for thread 1 sequence 40114 ID 0x5f1dd5ea dest 1:
Fri Jan 20 16:07:41 2012
Errors in file /oracle/BDE/saptrace/diag/rdbms/bde/BDE/trace/BDE_ora_6688.trc:
ORA-00308: cannot open archived log
'/oracle/BDE/oraarch/BDEarch1_37711_517935416.dbf'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
Fri Jan 20 16:08:16 2012
Errors in file /oracle/BDE/saptrace/diag/rdbms/bde/BDE/trace/BDE_ora_6688.trc:
ORA-00308: cannot open archived log
'/oracle/BDE/oraarch/BDEarch1_37711_517935416.dbf'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
Non critical error ORA-48913 caught while writing to trace file
"/oracle/BDE/saptrace/diag
/rdbms/bde/BDE/trace/BDE_ora_6688.trc"
Error message: ORA-48913: Writing into trace file failed, file size limit
[20480000] reached
Writing to the above trace file is disabled for now on...
Fri Jan 20 16:11:46 2012
Completed checkpoint up to RBA [0x9cb3.2.10], SCN: 41677510828
Fri Jan 20 16:20:27 2012
Beginning log switch checkpoint up to RBA [0x9cb4.2.10], SCN: 41677661976
Thread 1 advanced to log sequence 40116 (LGWR switch)
  Current log# 7 seq# 40116 mem# 0: /oracle/BDE/origlogB/log_g7m1.dbf
  Current log# 7 seq# 40116 mem# 1: /oracle/BDE/mirrlogB/log_g7m2.dbf
Fri Jan 20 16:20:29 2012
Archived Log entry 43944 added for thread
------------------------------------------

Why was oracle trying to write to an archive log that was over a month old?
Of course the log file was gone. It had been backed up and deleted weeks ago.

-Vince Laurent
SAP BASIS Support
SSM IHT


Confidentiality Notice: This email message, including any
attachments, is for the sole use of the intended recipient(s) and
may contain confidential and privileged information. Any
unauthorized review, use, disclosure or distribution is prohibited.
If you are not the intended recipient, please contact the sender by
reply email and destroy all copies of the original message.
--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l


Other related posts: