Backup - SAP MaxDB iDataAgent

Deployment - Windows Deployment - Microsoft Cluster Deployment - UNIX Deployment - UNIX - Veritas Cluster Configuration Backup Restore

Perform a Backup

 After configuring your Instance, BACKINT interface, and parameter file, you are ready to perform your first backup.

What Gets Backed Up

 The SAP for MAXDB iDataAgent backs up the following types of data:

  • All the database files.
  • Log Files.
  • Configuration Files which include Parameter files (param file).

What Does Not Get Backed Up

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

The following section provides step-by-step instructions for running your first full backup:

Perform Offline (Cold) Full Backup

  1. Open the DBM Command line Interface and verify the status of the database.

    #> dbmcli -d CERT1 -u dbm,dbm -uUTL
    dbmcli on CERT1>db_state
    OK
    State
    ADMIN

  2. For offline backup, MAXDB should be in admin (cold) state. If DB is not in this mode, execute the following command.

    #> dbmcli -d CERT1 -u dbm,dbm db_cold

     #> dbmcli -d CERT1 -u dbm,dbm db_cold

  3. Type the command to execute the offline full backup.

    #> dbmcli -d CERT1 -u dbm,dbm -uUTL -c backup_start BackData2 Migration

  4. The backup should complete without any errors.

    ok
    Return Code 0

Perform Online (Warm) Full Backup

  1. Open the DBM Command line Interface and verify the status of the database.

    #> dbmcli -d CERT1 -u dbm,dbm -uUTL
    dbmcli on CERT1>db_state
    OK
    State
    ONLINE

  2. For online backup, MAXDB should be in online (warm) state. If DB is not in this mode, execute the command.

     #> dbmcli -d < DBsid > -u dbm,dbm db_warm

  3. Type the command to execute the online full backup.

    # dbmcli -d CERT1 -u dbm,dbm -uUTL -c backup_Start BackData2 Recovery

  4. The backup should complete without any errors.

    ok
    Return Code 0