Log-File missing

[Former Member]

Hello,

I´ve done a stupid mistake, I hope anybody can help me now:

I have reorganized the hard disks of my pc and unfortunally formatted a seemingly unessential disk.

Now, my Basis-System (MaxDB 7.6.00.35) is crashing when starting the database:

VOLUMEIO Could not open volume 'F:sapdbP00saplogDISKL001', rc = 2
IOMan    Attach error on log volume 1: could not open volume

Stupidly I have never done a backup of this file, because I thought, the log file residents on another disk.

The database is using "Override mode for log area ON".

I would be very grateful if anybody ca give my a hint what to do now.

Kind regards

Volker

[lbreddemann · Accepted solution]

>

VOLUMEIO Could not open volume 'F:\sapdb\P00\saplog\DISKL001', rc = 2
> IOMan    Attach error on log volume 1: could not open volume

>

> Stupidly I have never done a backup of this file, because I thought, the log file residents on another disk.

> The database is using "Override mode for log area ON".

Hi Volker,

Usually you don't make backups of this file as you usually never backup any files of MaxDB.

What you may do right now is this:

1. Perform a full data backup of the Database in ADMIN MODE. You can do this easily with the DBMGUI.

2. Once you have the full data backup, you need to perform a "Recovery with Initialization". This will recreate missing Log-Files.

3. After you've sucessfully recovered the database, I highly recommend to install the current patch (7.6.05) as the version you use is very old.

Best regards,

Lars

[Former Member]

Hello Lars,

many thanks for your help! The database is starting now, the missing log file is created.

Kind regards

Volker