on 08-07-2013 10:22 AM
Hello,
I have one question about some log-files under /sapdb/data/wrk/<SID>/
In this directory are some log-files named SDB_LOG.040 - SDB_LOG.068. Each file have a size of 349765632 bytes = 333,5625 MB.and in total they take 9,12 GB. The files have a timestamp from 2007, 2008, 2009 and 2010.
The question is, can I delete this log-files without any impact of the DB ?
Here is the content of the directory:
/sapdb/data/wrk/<SID> # ls -ltr
total 9928136
-rw-rw---- 1 sdb sdba 2048 Mar 1 2007 dbm.upc
drwxrwx--- 2 sdb sdba 6 May 8 2007 analyzer
-rw-rw---- 1 sdb sdba 349765632 Oct 26 2007 SDB_LOG.040
-rw-rw---- 1 sdb sdba 349765632 Oct 31 2007 SDB_LOG.041
-rw-rw---- 1 sdb sdba 349765632 Nov 2 2007 SDB_LOG.042
-rw-rw---- 1 sdb sdba 349765632 Nov 2 2007 SDB_LOG.043
-rw-rw---- 1 sdb sdba 349765632 Nov 8 2007 SDB_LOG.044
-rw-rw---- 1 sdb sdba 349765632 Nov 21 2007 SDB_LOG.045
-rw-rw---- 1 sdb sdba 349765632 Nov 23 2007 SDB_LOG.046
-rw-rw---- 1 sdb sdba 349765632 Nov 23 2007 SDB_LOG.047
-rw-rw---- 1 sdb sdba 349765632 Nov 30 2007 SDB_LOG.048
-rw-rw---- 1 sdb sdba 349765632 Dec 5 2007 SDB_LOG.049
-rw-rw---- 1 sdb sdba 349765632 Dec 12 2007 SDB_LOG.050
-rw-rw---- 1 sdb sdba 349765632 Dec 27 2007 SDB_LOG.051
-rw-rw---- 1 sdb sdba 349765632 Jan 16 2008 SDB_LOG.052
-rw-rw---- 1 sdb sdba 349765632 Feb 19 2008 SDB_LOG.053
-rw-rw---- 1 sdb sdba 349765632 Mar 12 2008 SDB_LOG.054
-rw-rw---- 1 sdb sdba 349765632 Apr 15 2008 SDB_LOG.055
-rw-rw---- 1 sdb sdba 349765632 May 13 2008 SDB_LOG.056
-rw-rw---- 1 sdb sdba 349765632 Jul 7 2008 SDB_LOG.057
-rw-rw---- 1 sdb sdba 349765632 Sep 16 2008 SDB_LOG.058
-rw-rw---- 1 sdb sdba 349765632 Oct 7 2008 SDB_LOG.059
-rw-rw---- 1 sdb sdba 349765632 Jan 12 2009 SDB_LOG.060
-rw-rw---- 1 sdb sdba 349765632 Feb 26 2009 SDB_LOG.061
-rw-rw---- 1 sdb sdba 349765632 Mar 30 2009 SDB_LOG.062
-rw-rw---- 1 sdb sdba 349765632 Jul 20 2009 SDB_LOG.063
-rw-rw---- 1 sdb sdba 349765632 Sep 9 2009 SDB_LOG.064
-rw-rw---- 1 sdb sdba 349765632 Dec 23 2009 SDB_LOG.065
-rw-rw---- 1 sdb sdba 349765632 Mar 9 2010 SDB_LOG.066
-rw-rw---- 1 sdb sdba 349765632 Apr 28 2010 SDB_LOG.067
-rw-rw---- 1 sdb sdba 349765632 Jun 23 2010 SDB_LOG.068
-rw-rw---- 1 sdb sdba 843809 Jul 8 2011 knldiag.old
-rw-rw---- 1 sdb sdba 819234 Jul 8 2011 dbm.utl
-rw-rw---- 1 sdb sdba 199808 Jul 8 2011 knldiag.err
-rw-rw---- 1 sdb sdba 846320 Jul 8 2011 knldiag
-rw-rw---- 1 sdb sdba 801368 Jul 8 2011 dbm.ins
drwxrwx--- 2 sdb sdba 6 May 22 2012 dbahist
drwxrwxrwx 5 sdb sdba 83 May 22 2012 DIAGHISTORY
-rw-rw---- 1 sdb sdba 47 Jun 13 2012 dbm.cfg
-rw-rw---- 1 sdb sdba 696 Jan 15 2013 dbm.mmm
-rw-rw---- 1 sdb sdba 1163645 May 31 15:03 KnlMsg.old
-rw-rw---- 1 sdb sdba 15212544 May 31 20:02 knltrace
drwxrwx--- 2 sdb sdba 4096 May 31 20:02 rtedump_dir
-rw-rw---- 1 sdb sdba 139264 May 31 20:04 KnlMsgArchive
-rw-rw---- 1 sdb sdba 820232 Aug 7 10:15 dbm.mdf
-rw-rw---- 1 sdb sdba 605632 Aug 7 10:15 dbm.knl
-rw-rw---- 1 sdb sdba 547401 Aug 7 10:15 dbm.prt
-rw-rw---- 1 sdb sdba 1152103 Aug 7 11:18 KnlMsg
Thanks and best regards
Carsten
Dear Carsten,
These files looks like old transaction log files. If you have taken a full backup of the DB lately, you can delete these files.
Regards,
Sandy Sam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.