Getting Started - SAP for MAXDB Backup

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:

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

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