Monday, 16 October 2023

SAP MAXDB Backup using command line tool

 


SAP MAXDB Backup using the command-line tool

Use the command-line tool DBMCLI to take a DATA or LOG backup of the SAP MAXDB database. Follow the below command to take backups through the command-line tool.

Steps:
1. Open DBMCLI from the command prompt in the following location: /sapdb/programs/bin.

./dbmcli -d <SID> -u superdba,<password>

2. Check the DB state. 

./dbmcli on <SID>> db_state
OK
State
ONLINE
---

3. If you want to take offline backups stop the database (for Offline backups)

db_offline   
 
 (or)

db_admin

4. We need to create a backup template to take backups of data and logs.

For data (path location of Linux),

medium_put <data backup template name> "/<location>/<filename>" FILE  DATA

For Log (path location of Linux)

medium_put <log backup template name> "/<location>/<filename>" FILE  LOG

5. Connect the database before taking backups.

db_connect

6. Take a complete data backups.

backup_start <data backup template name>

7. Take log backup

backup_start <log backup template name>

8. Check the backup status after completion.

backup_state

(or)

medium_label <backup template name>

9. Start a database

db_online

10. Find the below reference link for more details.

Education purposes only : Click here

For your reference.