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
Steps:
1. Open DBMCLI from the command prompt
./dbmcli on TRM> dbmcli -d
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
Example :
./dbmcli on TRM> backup_template_create DATA1 TO FILE /sap_dump/trmdatabck COMPRESSED CONTENT DATA
For Log
./dbmcli on TRM> backup_template_create
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