Setting "Overwrite mode for the Log Area SAPDB"

[Former Member]

Hello!

After Installing SAP Solution Manager and executing SGEN-jobs my DB-partition was full.

So I had to redirect the other Data files and log files to the other partition.

My free space on the second partition seems also to be full.

Now I am about to switch the log mode from "normal" to "Overwrite mode for the Log Area SAPDB".

What I should I do/prepare/check before executing this step?

(should SAP and/or DB be down)

After this:

Can I delete the existing Log files that are empty?

How can I check, which Log files are empty?

Thank you very much indeed!

regards

Thom

[markus_doehr2]

Use the DBMGUI and execute

- select the instance

- Instance - Configuration - Log settings

- select "Overwrite mode for the logarea"

- finish

The system will switch instantly, you can do this in a started instance also.

The log area itself is still necessary, however, you can delete the log, you wrote already to the disk using the log backup destination.

--

Markus

[Former Member]

Hello Markus!

Thank you very much!

I have switched the mode to overwrite.

I have seen that nealry 13 GB of Log files are unused.

And I have created 6 Log files a 6,5 GB

<b>Does it mean, that I can delete the last one, because this log files will never be used by overwrite mode?

Or do I need all created Log files, because the logs will be written among all log files (log file 1, .., 6)?</b>

Thank you very much indeed!

regards

Thom

[Melanie]

Hello Thom,

you have to distinguish between the log volumes and the log backup files. The log volumes can not just be deleted. You would have to re-install the database with a smaller log area / less log volumes.

The log backup files can be deleted if you don't need them for a recovery anymore.

Regards,

Melanie

[Former Member]

Hello Melanie,

thank's a lot for your response..

Let me clear the solution.

I have the partition "D" with the following structure:

\sapdb\<SID>\db

\sapdb\<SID>\sapdata (DISKD0001, ..,DISKD0009)

\sapdb\<SID>\saplog (DISKL001, DISKL002)

And I have the second SAPDB-partition "G" with:

\sapdb\<SID>\sapdata (DISKD0010, .., DISKD0013)

\sapdb\<SID>\saplog (DISKL003,.., DISKL006)

I have activates the Overwrite mode for the log files and have seen, that I have still nearly 17 GB free space.

<b>Can the Log files under "G" (such as DISKL005 and DISKL006) be deleted?</b>

Thank you!

regards

[Melanie]

Hello Thom,

no, you cannot just delete the log volumes on disk G. The database won't be able to start afterwards.

If you would like to remove these log volumes and free the space, you need to

re-install the database with a different configuration.

Therefore you should follow these steps:

1. create a complete data backup of the database (e.g. using DBMGUI)

2. in DBMGUI choose 'Instance -> initialize'

3. choose 'use current parameters' and then change the configuration that the unnecessary log volumes are not there anymore.

4. confirm the steps until you have to choose the 'creation mode'. Choose 'create instance for recovery'.

5. start the initialisation and restore the backup you created in step #1.

Afterwards you can delete the unused files (DISKL003 ... DISKL006) in the files system.

HTH,

Melanie