Skip to Content

SAP MAX-DB Backup using command line tool

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

Steps:

1. Open DBMCLI from commandprompt

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

2. Stop Database (For Offline backup)

db_offline

                         (or)

                         db_admin

3. Create Backup template for data and logs.

For data

medium_put <templatename1> drive:\<location>\<filename> FILE DATA

For Log

medium_put <templatename2> drive:\<location>\<filename> FILE LOG

4.   Connect Database

db_connect

5.  Take Complete data backup

backup_start <templatename1>

6.  Take log backup

backup_start <templatename2>

7.  Check backup status after completion

backup_state

(and)

medium_label <templatename>

8. Start database

db_online

4 Comments
You must be Logged on to comment or reply to a post.
  • Hi,
    please *do not use* ‘db_stop’. This hard-stops the database to offline state without waiting for open transactions to close.
    To bring the database to ‘offline’ state, use ‘db_offline’, for ‘admin’ state ‘db_admin’.

    Starting the database is usually performed with ‘db_online’ command.

  • hello  


    I have facing a error in SAP MAX DB,My site is Disaster recovery.and MAX DB is standby mode.   ERROR MSG– -24994 runtime environment error[db_admin-f];1, dbm has stopped unexpectedly ,(view ‘Application Event log’) (OS error code 11000)