Performing a SAP MaxDB Incremental Backup

An incremental backup contains only data that is new or has changed since the last backup, regardless of the type. On average, incremental backups consume far less media and place less of a burden on resources than full backups. To streamline the backup process and to optimize the time and resources, you can run incremental backups.

Procedure

Offline (Cold)

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. Create a table and add records.

   Usage example:

   #> sdbfill <DBName> init|create|append|check|delete [<From> <To>
   [<TransactionLength> [<SleepBeforeCommit> [ q|a|b
   [dba dbapassword]]]]]
       
   

   #> sdbfill CERT1 append 1000000 2000000 10000 0 a DBA DBA
   2000000, finale commit at 1999999
   1000000 rows inserted successfully.
       
   

3. 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
       
   

4. Type the following command to execute the offline incremental backup.

   #> dbmcli -d <DBSid> -u dbm,dbm -uUTL -c backup_start BackPages migration
       
   

5. 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 incremental backup.

   # dbmcli -d CERT1 -u dbm,dbm -uUTL -c backup_start BackPages2 Recovery
       
   

4. A return code of 0 means the backup was successful.

   ok
    Return Code 0