How to Take SAP MAXDB Backup using command line tool

We can use the command-line tool DBMCLI to take the backup of the MAX-DB database. If you are facing problems while taking a backup from MAX-DB GUI tools you can opt for this option.
Steps:

1. Open DBMCLI from the command prompt

./dbmcli on TRM> dbmcli -d -u superdba,

2. Stop Database (For Offline backup)

./dbmcli on TRM> db_offline

                         (or)

./dbmcli on TRM> db_admin

3. Create a Backup template for data and logs.

For data

./dbmcli on TRM> backup_template_create  drive:\\ FILE DATA

Example :

./dbmcli on TRM> backup_template_create DATA1 TO FILE /sap_dump/trmdatabck COMPRESSED CONTENT DATA

For Log

./dbmcli on TRM> backup_template_create  drive:\\ FILE LOG

Example:


./dbmcli on TRM> backup_template_create LOG1 TO FILE /sap_dump/trmlogbck COMPRESSED CONTENT LOG
 
4.   Connect Database

./dbmcli on TRM> db_connect

Example: 

./dbmcli on TRM> db_connect
OK
___

5.  Take Complete data backup

./dbmcli on TRM> backup_start

Example:

 For DATA

./dbmcli on TRM> backup_start DATA1
 
6.  Take log backup

./dbmcli on TRM> backup_start


Example :
 
For LOG

./dbmcli on TRM> backup_start LOG1

7.  Check backup status after completion

./dbmcli on TRM> backup_state

(and)

./dbmcli on TRM> medium_label

8. Start database

./dbmcli on TRM> db_online

Example:

Example: 

./dbmcli on TRM> db_online
OK 
ONLINE
___

Data backup Result:


./dbmcli on TRM> backup_template_create DATA1 TO FILE /sap_dump/smadatabck COMPRESSED CONTENT DATA
OK

---
./dbmcli on TRM> backup_start DATA1
OK
 
Return code               0
Date                          20191202
Time                         00150842
Server                       MAXDB
Database                  TRM
Kernel Version         Kernel    7.9.09   Build 005-123-259-005
Pages Transferred    12953632
Pages Left                0
Volumes                   1
Media name               DATA1
Location                  /sap_dump/trmdatabck
Error text
Label                       DAT_000000004
Is Consistent            true
First LOG Page          33607623
Last LOG Page
DB Stamp 1 Date         20191202
DB Stamp 1 Time         00143617
DB Stamp 2 Date
DB Stamp 2 Time
Page Count              12953591
Devices Used            1
Database ID             MAXDB:TRM_20191202_150840
Max Used Data Page      0
Converter Page Count    7670