MaxDb Log

[NolanE]

Good Day,

I need some help with my MaxDB backups, the database backs via the backint utility but the log does not clear after the backup.

is there a setting or something I need to add in the config file to truncate the log.

I use Netbackup 6.5 on a windows 2003 platform

Nolan

[Will_Restore · Accepted solution]

from the admin guide:

To perform a backup

1.

medium.

Make sure that you have modified the proper configuration files and created a backup

2.

Type the following command:

Start a utility session.

dbmcli>

util_connect

3.

Type the following command:

Initiate the backup.

dbmcli>

medium_name

backup_start medium_name backup_type

Name of the backup medium.

backup_type

Specify either DATA, PAGES, or LOG
.

[Stumpr2]

Bill,
Does "Specify either DATA, PAGES, or LOG" mean that you can only specify one of them so then you would have to run two  backups to get the data AND the log?

.

[Will_Restore]

Yes, that's the way I see it. 

backup_type

Specify one of the following:

◆

DATA for a full data backup

◆

PAGES for an incremental data backup

◆

LOG for a log backup

[NolanE]

Hi Bill

I did create 2 different medium in MaxBD one for the full backup and one for the log, when I run the log backup it backup the log file but does not clear the log file after the backup.

I don't know if there is a switch in the script file or a setting in maxbd that i need to change for this to work

Nolan

[Marianne]

Nolan, the NBU manual gives basic instructions on how to get backups working. Maybe consult your MaxDB documentation as suggested in the manual?
p 119:
'For more information about MaxDB databases, see your MaxDB documentation.'

A Google search found this document w.r.t MaxDB log management:
http://maxdb.sap.com/training/internals_7.6/logging_EN_76.pdf

[Will_Restore]

It looks like log backup allows the region to be overwritten rather than truncating the logs.

[NolanE]

I will have to check if the log gets overwritten after the log backup