Skip to Content

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

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Thorsten Zielke

    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.

    (0) 
  2. Former Member

    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)

    (0) 

Leave a Reply