Performing a SAP MaxDB Full Backup

After you configure the instance, BACKINT interface, and parameter file, perform your first backup.

A full backup contains the backup of an entire database. The full backup becomes a baseline to which subsequent incremental backups are applied should data restoration be requested.

The SAP MaxDB iDataAgent backs up the following types of data:

  • All the database files

  • Log Files

  • Configuration Files which include the parameter files (param file)

The SAP MaxDB iDataAgent does not backup the SAP MaxDB application files associated with the SAP MaxDB installation.

Procedure

Offline (Cold)

  1. Open the DBM command line interface and verify the status of the database. Type the following command:

    #> dbmcli -d CERT1 -u dbm,dbm -uUTL
     dbmcli on CERT1>db_state
     OK
     State
     ADMIN
  2. The SAP MaxDB database must be in the admin (cold) state. If the database is not in this mode, type the following command.

    #> dbmcli -d CERT1 -u dbm,dbm db_cold
  3. Type the following command to execute the offline full backup.

    #> dbmcli -d CERT1 -u dbm,dbm -uUTL -c backup_start BackData2 Migration
  4. A return code of 0 means the backup was successful.

    ok
     Return Code 0

Online (Warm)

  1. Open the DBM command line interface and verify the status of the database. Type the following command:

    #> dbmcli -d CERT1 -u dbm,dbm -uUTL
     dbmcli on CERT1>db_state
     OK
     State
     ONLINE
  2. The SAP MaxDB database must be in the online (warm) state. If the database is not in this mode, type the following command.

     #> dbmcli -d < DBsid > -u dbm,dbm db_warm
  3. Type the command to run the online full backup.

    # dbmcli -d CERT1 -u dbm,dbm -uUTL -c backup_Start BackData2 Recovery
  4. A return code of 0 means the backup was successful.

    ok
     Return Code 0

Loading...