cancel
Showing results for 
Search instead for 
Did you mean: 

MaxDB log full situation - how to avoid complete data backup

Former Member
0 Kudos

Hi,

I performed an homogeneous system copy. The source system was a demo system with a lot of clients. I don't need all of these clients, so I started a delete of these clients to free up DB space. But I forgot to switch the DB in overwrite mode... And now the log area is full...

The problem here is that there is no tape drive available, and the available free space is not sufficient to perform a complete data backup on disk.

What is the solution is this case ?

Thanks in advance for your attention and your reply.

Sincerely,

Christophe

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Lars,

I have another problem.

When I want to launch dbmcli (dbmcli -u control,****** -d DEV), I got the following error:

Error! Connection failed to node (local) for database DEV:

-24691,ERR_EXIT: The DBM server must be aborted.

-24700,ERR_DBMSRV_NOSTART: Could not start DBM server.

-24832,ERR_SHMNOTAVAILABLE: Shared memory not available

-24827,ERR_SHMALLOCFAILED: ID D:\sapdb\data\wrk\DEV.dbm.shi, requested size 26006,Creating shared memory file D:\sapdb\data\wrk\DEV.dbm.shi failed, rc = 183.

-24832,ERR_SHMNOTAVAILABLE: Shared memory not available

But I can launch a complete backup via Database Manager... useless here because I don't have enough free space...

Christophe

lbreddemann
Active Contributor
0 Kudos

Errortext for errorcode 183:

'Cannot create a file when that file already exists.'

Therefore: the file "D:\sapdb\data\wrk\DEV.dbm.shi" is already there.

Deleting it may help here...

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Lars,

I forgot to write that I'm on Windows...

Christophe

lbreddemann
Active Contributor

> I forgot to write that I'm on Windows...

That and that you don't know that on Windows the NULL device is adressed via nul:

To make it really reasy to follow:


medium_put "NIRVANA" nul: FILE DATA 0 8 YES

and then


db_connect
backup_start nirvana data

cheers

Lars

lbreddemann
Active Contributor
0 Kudos

Hi there,

create a backup medium for complete data backup pointing to /dev/nul and take the backup to it.

Afterwards you can take a log backup and enable log mode overwrite.

regards,

Lars