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. Moopnarain yadav

    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