Unable to recover from backup

[Former Member]

Hello,

i'm pretty new to SAP and MaxDB. Unfortunalty we had a server crash and i had to reinstall SAP ECC 6.0 along with MaxDB 7.6 as it was delivered in these versions and installed on the crashed mashine.

The new mashine also has a new name. This seems to be the problem while trying to recover the database.

MaxDB Studio gives me the following error trying to recover first the volume, then the logs:

-3004 Invalid host file sequence1,Backupmedium #1 (E:\SAP Backup\VOL\DB2_INC) save/restore type mismatch6,Backup error occured, Error code 5220 "wrong_hostfile"17,Servertask Info: because Error in backup task occured10,Job 1 (Backup / Restore Medium Task) [executing] WaitingT29 Result=52206,Error in backup task occured, Error code 5220 "wrong_hostfile"

How can I tell The MaxDB Studio to recover anyways or how can i change the hostname inside the backup?

Glad for any help.

Greetings.

Jan

[yashwanthkumar_kethineed · Accepted solution]

Hello Jan,

I Assume you have a complete data backup before the crash.

If you are planning to recover the database to the point in time when the backup was created, you can go ahead and run the recovery as "Recovery with Initialization" from your Database Studio. Use the option to recover the parameters from the backup - if you wish to keep the same configuration. The "wrong_hostfile" error is probably because you are trying to run a normal recovery.

As you said you are pretty new to SAP and MaxDB, I recommend you to go through the following documentation & Training links before performing the restore.

Go to http://maxdb.sap.com/training/

The following Sessions will be helpfull:

Session 2: Basic Administration with Database Studio

Session 11: SAP MaxDB Backup and Recovery

Also refer to the MaxDB Library at http://maxdb.sap.com/doc/7_8/default.htm

Tools -> Database Studio -> Restoring Databases: Overview

Let me know if you need any further help during the restore.

Regards,

Yashwanth

[Former Member · Accepted solution]

Hello Yashwanth,

thank you so much for your help. Unfortunatly your idea didn't work. Recovery with initiatization throws me the same error:

-3004 Invalid host file sequence1,Backupmedium #1 (E:\SAP Backup\VOL\DB2_INC) save/restore type mismatch6,Backup error occured, Error code 5220 "wrong_hostfile"17,Servertask Info: because Error in backup task occured10,Job 1 (Backup / Restore Medium Task) [executing] WaitingT53 Result=52206,Error in backup task occured, Error code 5220 "wrong_hostfile"

When I said I'm new to MaxDB i meant the I did have a course at SAP for MaxDB administartion but that was 2 years ago and I haven't had much training since. Nevertheless I will refrehen my knowledge with the links you gave me.

Any other ideas regarding my problem?

Greetings.

Jan

[former_member188883 · Accepted solution]

Hi Jan,

Could you refer this thread http://scn.sap.com/thread/801165

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

thanks for your help.

It doesn't seem to be a rights issue. I gave my backup file all rights.

The same error occurs when I just check the backup.

Any thoughts? Can I provide any more information?

Greetings. Jan

[former_member188883 · Accepted solution]

Hi Jan,

Could you share the ouput of this command

dbmcli -d <database_name> -u <dbm_operator>,<dbm_operator_password> medium_getall

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak.

Here's the output:

OK

Logbackup       E:\SAP Backup\LOG\init_log_bkp  FILE    LOG     0       8

NO      NO              20130319152848  20130319152848          NONE

COM     D:\Backup\VOL\DB2_INC   FILE    DATA    0       8       YES     NO

        20130322121825  20130322121825          NONE

Those seem to be the backupfiles I gave the MaxDB Studio...

Greetings.

[yashwanthkumar_kethineed · Accepted solution]

Hello Jan,

I see you have a CSS ticket open with SAP.

I tried to reproduce the error (-3004) you mentioned in our environment and I was able to reproduce it when I try to restore the "Incremental Backup" using a medium defnition created for "Data Backup"

It looks like from the output you attached

COM     D:\Backup\VOL\DB2_INC   FILE    DATA    0       8       YES     NO

        20130322121825  20130322121825          NONE

"COM" is a medium definition for the "Complete Data" Backup - but the Device/File for this medium is pointed to the incremental backup "DB2_INC" you need to change the medium definition to the File location where you have the complete data backup. You can do this using the DATABASE STUDIO during the restore process - select the medium "COM" and click on EDIT.

This should fix the problem. If not, please open a WTS connection to the system and update the CSS message - I will take a look into it.

Regards,

Yashwanth

[Former Member · Accepted solution]

Hello Yashwanth,

thank you. That was it. I never noticed thet the backup was so small it couldn't have been my complete backup. Anyway, I found it now, the complete backup and it restored fine. Next problem is, that the incremental backup says:

-111 Incompatible incremental backup6,Data recovery failed17,Servertask Info: because Error in backup task occured10,Job 1 (Backup / Restore Medium Task) [executing] WaitingT74 Result=10406,Error in backup task occured, Error code 1040 "incompatible_savefile"

These are my backups:

The dates are fine since we haven't used SAP much and not at all since last year.

Any advice? Thanks and greetings.

Jan

[yashwanthkumar_kethineed · Accepted solution]

Hello Jan,

For your reference,  you can refer to the MaxDB documentation to understand the meaning of most of the error messages:

http://maxdb.sap.com/doc/7_8/5d/00bbeb7c98481eabd277021d2292cf/content.htm

What does error -111 say ?

-111: Incompatible incremental backup /18/de2614d8724b678e27aa44e99c181d/frameset.htm

Explanation

The database version to be loaded is not the follow-up version of the current database state.

Clarify me the following:

Did you initialize the database before restore ?

Did you restore any of the log backups after the data backup is restored ?

Do you have the log (dbm.knl) from the crashed instance DB2 with which these backups are created ? Please attach it to the thread.

(It would be easier by looking at the dbm.knl log to identify which log backup / Incremental backup has to be used followed by the complete data backup to restore the database to the point in time when the crash happened.)

Can you post the screenshot of log backups with date and timestamp visible ?

Please attach  the dbm.knl file from the RUN DIRECTORY of current database instance

Thanks,

Yashwanth

[Former Member · Accepted solution]

Hello Yashwan,

thank you for your great help.

I did not initialize the DB before the restore.

After restoring the complete backup, i did not restore any logs. According to the dates, I have to retore the incremental backup after the complete backup, then the logs.

I do not have any files from the crashed System. Sorry

The screeenshor of the above post shows all the dates. of all the backups.

• DB2_INC is the incremental backup
• init_bkp is the complete backup (restore worked)
• All other files on the left are the log-backups

The knl file is attatched.

Thanks and greetings.

Jan

UPDATE!

I got it working. The initialisation of the DB prior to the COM restore did it. After the COM restore, you have to hit "back to recover other media" and restore the incremental backup, after that the Logs. Everything works fine now. Thanks for the help. 😃

dbm.knl.txt.zip

[yashwanthkumar_kethineed · Accepted solution]

You are very welcome. Glad that your restore is succesfull.