on 01-09-2008 8:38 AM
Hi,
I have somthing i don't understand about MAXDB :
I have a log file here : /sapdb/log/DC1/DISKL001 where i supose it's there i could find the trace about file storage.
But there are other log files here : /sapdb/data/wrk/DC1/DC1_LOG.001 to DC1_LOG.051
I wanted to know what are this log file ( are they like redo log files? or other ) and if it is possible to delete them.
Thx by advance.
Before all thx for all.
But i have an other question _
1°) my
/sapdb/log/DC1/DISKL001 file witch is a log file take 1Go.
Like we are using very often the content server the file grow and when it is on 1Go i have to create an other file like for example /sapdb/log/DC1/DISKL002....so is there a way to purge ( delete not all but the oldest ) because of the size all the disk take.
2°)It's only with /sapdb/log/DC1/DISKL001 file the system make the recovery? maybe he have to use the little one ( DC1_LOG.001 to DC1_LOG.051) to the recovery?
Regards.
Edited by: Fabrice BABY on Jan 10, 2008 5:24 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
oh and I forgot.....delete them ???
deleteing them means loosing option to recover database , same as deleting archive redologs.
many DB administrators prefer to backup those files before deleting them
regards
Ivan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
you are right , file /sapdb/log/DC1/DISKL001 is log file
, in Oracle terminology : online redo log
files /sapdb/data/wrk/DC1/DC1_LOG.001 ,....., 002 , 003, ...
are log backup , in oracle term : offline redolog or archive redologs
very good reading is SAP note
869267 FAQ: MaxDB LOG area
regards
Ivan
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 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.