log file lost.

[Former Member]

I got the advise to deleet the log file after the system stop because the log file was full. "they've done it before". Now I have the problem that I can't start the database again. Is there a way to initialize a new log file

Regards

Hans

[Former Member · Accepted solution]

Hi Hans,

the logfile (also called logvolume) is create at the time the database is created by an activate command. You can achive this by the following commands in dbmcli:

UTIL_CONNECT
BACKUP_START<your backupmedium> DATA
DB_ACTIVATE RECOVER <your backupmedium>
UTIL_RELEASE

After this the database can be started. <b>Be sure that your backup really had been successful, because the DB_ACTIVATE command removes all content from the database</b> before restoring the databackup.

If you do not want your application get stuck again in a logfull situation, then you should enable the automatic logbackup in order to free space on the logvolume as needed.

Kind regards, Martin

[Former Member]

Thanks Martin, worked like a tread.

regards

Hans