Re: Weird alert log errors
Date: Fri, 27 Jan 2012 15:19:38 -0500
Message-Id: <4F22C08A0200000B004E3D86_at_groupwise.gcrta.org>
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_at_ssmhc.com> 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.
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 27 2012 - 14:19:38 CST