Maxdb Backup/Restore

[nikhil_bose]

hello administrators,

How can we do complete backup of any maxdb instance running, to a particular directory, on one machine and have those files to restore same instance on another machine.

Please note that: I don't want to use GUI tools.

Please guide me to do it with dbmcli or if possible with SQL.

thanks in anticipation,

nikhiL

[lbreddemann · Accepted solution]

Hi Nikhil,

first of all: why do you want to perform this action - it's a system copy - via command line?

The available GUIs provide a much easier way to perform this task.

If you want to schedule this copy procedure - think carefully if you really want to have the deletion of the target db automated!

Anyhow - here are the basic steps as well as the usual pointers to the documentation.

Be aware that you should have looked up these already yourself as per the Rules of Engagement of these forums.

As these commands are handling the database as a whole (and not objects inside a database) these commands cannot be part of the SQL command set. The commands used here are DBMServer commands and the interface tool for these is the DBMCLI.

1. Create the target instance

2. Create backup medium definitions on both db instances.

Make sure the medium definitions point to the very same file.

medium_put full_backup_medium '/mypath/myfolder/myfilename' FILE DATA

3. Create a complete data backup of the source db.

db_connect
backup_start data full_backup_medium

4. Recover the complete data backup to the target db:

db_admin
db_connect
db_activate RECOVER full_backup_medium autoignore

5. That's it - you've just copied the instance.

All this is described more detailed in: THE DOCUMENTATION!:

[Creating a Database Copy (Importing a Data Backup into Another Database Instance)|http://maxdb.sap.com/doc/7_6/87/dba841c0dae234e10000000a1550b0/content.htm]

You may also want to check the MaxDB Wiki: [Best Practice - MaxDB backup with dbmcli|https://wiki.sdn.sap.com/wiki/x/sx0B] or this blog entry [Mind the gap...' (#3 - Backup/Restore - Part 1)|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/10093] [original link is broken] [original link is broken] [original link is broken];.

But please: really think about why you want to do this via dbmcli.

Regards,

Lars

[nikhil_bose · Accepted solution]

Larrs thanks alot for the reply.

Actually I am developing a webdynpro mock up like Bugzilla. And want to include a backup/restore along so that person with authorization could do a backup/restore.

When I start with backup component, I thought it as a generic one so that it can be used within any landscape.

best regards,

nikhil

Edited by: Nikhil ßos on Jul 5, 2008 3:57 PM

[nikhil_bose · Accepted solution]

Thanks for the link to the documentations. I am new to MaxDB.

db_connect
backup_start data full_backup_medium

here I found a small mismatch

backup_start <medium_name> [<backup_type>] [AUTOIGNORE]

I am afraid that it should be like

 backup_start full_backup_medium DATA

thanks again.

nikhil