Performing a SAP MaxDB Archive Log Backup

Use log file backups to recover database transactions that have been lost due to an operating system or disk failure. You can apply these logs to an online backup in order to recover a database.

Perform the archive log backup after a full or incremental data backup. The log backup marks the log files to be truncated from the log volume if the log volume requires space to accommodate new logs.

Procedure

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. 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 following command to run the log backup

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

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

   ok
   Return Code 0