Should we delete log files?

[chunbo]

There are over 1000 logs files in active log directory, and only the last 5 are active. I use archival logging, and the server will run out of disk space.

Should I delete old log files?

In archival logging, how to determine primary log files? Should we keep primary log files?

Thanks

 

[blom0344]

All depends upon the last backup of the database. You will only need the logfiles that are needed to do a rollforward from a certain point-in-time, which means there is no use for logfiles containing information on transactions before this point (unless the last backup proves to be corrupt). So why not store the logfiles compressed elsewhere?

T. Blom
Information analyst
tbl@shimano-eu.com