SAP MaxDB Backups

The Commvault software supports the following backups:

  • Full

  • Incremental

  • Selective Online Full

  • Archive log

  • Automatic archive log

Use one of the following options to automate SAP MaxDB backups that use the Commvault software:

  • Use the SAP DBMGUI interface

  • Create a script that has a sequence of commands, and then run the script

You can use a schedule policy to perform the backup. For more information about the schedule policies, see Schedule Policies Overview. The schedule policy automatically changes the database state to the offline (cold) state or the online (warm) state based on the backup type you selected. However, you must complete the following steps to allow the schedule policy to perform the backup:

Note

You must consider running full backups and log backups for SAP MaxDB one after the other because backint configurations files cannot be reused until the existing job completes.

User Permissions

The user performing the backup and restore operations must have a minimum of the following DBM permissions:

SERVERRIGHTS= Backup, Recovery, Scheduling, DBInfoRead, DBStop, DBStart

Examples

  • To create a user who does the backup and restore operations for MaXDB, use the following command:

    dbmcli -d cert1 -u dbm,dbm
    dbmcli on cert1>user_create CVLTUSER,COMMVAULT
  • To assign the permission, use the following command:

    dbmcli on db1>user_put <username> SERVERRIGHTS=+Backup,+Recovery,+DBInfoRead,+Scheduling,+DBStop,+DBStart

  • To verify the permissions assigned to the user, use the following command:

    dbmcli on db1>user_get backup_user

Loading...