Restore MaxDB 7.8 ABAP db on a new computer (How?)

[Former Member]

Hi:

I have an ABAP only database on Max db 7.8 on Windows 2008R2. I have done a full data backup and I was using the logs in overwrite mode so no need for log backups.

I want to restore this (disaster recovery) on a new server (Windows 2008 R2). I am not an SAP customer. I also only want to restore the DB (not use SAPinst for anything at this point in time).

I have installed the MaxDB software and DBMgui on the new server.

I need to restore the DB and use all the parameter values from within the backup file.

Does anybody have the steps I need to do (preferably using the DBMcli)?

Many Thanks,

Tony.

[former_member229109]

Hello,

this forum is for liveCache/LCA questions.

Do you have the database of LVC type?

If not => post your question on SAP Maxdb forum.

1. I recommend to install the MAXDB database studio.

2. You could use the dbmcli tool as well:

    Create the complete databackup of the source database and transfer it to the target databae server.

    Target database:

     Create the backup template with the same definitions as you had in the source database.

     Install and create the database instance of the same version as on the source target or higher.

      "Copying a Parameter File from a Data Backup" -

      http://maxdb.sap.com/doc/7_7/44/eabea2f85b2950e10000000a11466f/content.htm

      <until 9. >

      Check the DB parameters and DB volume configuration, adjust them for the target server.

       Transfer the database instance to the ADMIN operational state: 

    dbmcli on <sid-target>> db_admin

    Open a database session:

    dbmcli on <sid-target>> db_connect

    Import the complete data backup from source to target ( initializing target DB using the backup template SourceDataCompl_recover created for source DB:

dbmcli on <sid-target>> db_activate RECOVER SourceDataCompl_recover

       Restart the database, load system tables, check the schema user.

       Create the complete databackup.

Regards, Natalia Khlopina

[Former Member]

Hi Tony,

Please check these links

http://www.sapdb.org/7.4/pdf/backrec_eng.pdf

http://wiki.sdn.sap.com/wiki/display/MaxDB/HowTo+-+SAP+MaxDB+backup+with+Database+Manager+CLI