Recovery in MaxDB-LiveCache Error

[Former Member]

Hi experts,

Thank you very much in advance.

I'm making some restores (restore a complete database backup) and recoveries (restore a complete data backup and apply logs backups) tests make in a SCM 4.10 with LiveCache KERNEL 7.5.0 BUILD 042-123-145-415 MaxDB DBMServer 7.5.0 Build 042-123-145-415 and DBMGui 7.5.00.12.

I'm going to describe step by step the tests that I did and the result

Marks steps

1.- In SCM I did marks SAP Menu/Demand Planning/Planning/Interactive Demand PlanningInteractive Demand Planning

2.- MARK1

3.- Execute a complete data backup

4.- MARK2

5.- Execute a log backup

The result of the next steps is that i can NOT see MARK2, I can NOT do a Recovery

I have 4 mediums defines:

- Two for Complete Data Backup, Device Type File and Overwrite Option checked.

- One for Log backup, Device Type File and Autolog Option checked

- One for Incremental Data, Device Type File.

Recovery Steps

1.- Complete data backup recovery

With Inizialization

I recovery from a specified backup from history, with check botton on complete data backup that I execute after mak 1 --> Recovery is OK I can see MARK1

2.-

a.- Without Inizialization

Recovery from a Complete data backup and apply transaction log backup

The only option that I have is to recovery from a medium i only can select one. --> I can NOT Recover

b.- With Inizialization

1.- Restore Last Backup (and mark Medium with Log Backup) -> I can't Recover

2.- Restore Last Backup (and mark Medium with Complete data backup) --> Recovery OK but see MARK1

3.- Restore a Specified backup from history --> I can NOT select a Log backup medium --> I can NOT recover

4.- Restore a medium --> I can only choose Complete data backup medium --> I can NOT recover

(As it has come to read all mail up here PRIZE!).

(PS: Not if the prize is worth reading the line above you re-read the mail)

For any aclaration please contact me.

Thank you very much.

Regards.

[Former Member · Accepted solution]

Hi all,

Thank you very much for your help.

I created a customer message un parallel in SAPSupport

I forced a commit betwen MARK2 and transaction log Backup

I revised notes and documentation

All the tests that I' doing are with initialization because without initialization If I try to apply log data after complete data backup for recovery I only can select recover from medium.

The last tests I did I think I had checked all possibles combinations( from last

backup, from a specified backup from history and from medium) without

restart until apply log backup and all these tests ended with error :

-24988 sql error [db_activate RECOVER "Fil113600" DATA]; -3004,

save/restore type mismatch. I selected to create a new medium when warning about medium definition appear.

I don't know it this information can clarify a bit.

Thank you very much in advance,

Regards.

[lbreddemann · Accepted solution]

HI Alfonso,

may it be that you used the very same backup medium for data AND logbackup by switching the backuptype attribute in between the backups?

If so: don't do that.

Setup one backup medium for data backups and one for the log backups.

Perform your backup tests again.

Perform the recovery tests again.

What's the outcome then?

KR Lars

[former_member229109 · Accepted solution]

Hello Alfonso,

A) What is the ticket number you created for SAP?

B) "The last tests I did I think I had checked all possible combinations( from last

backup, from a specified backup from history and from medium) without

restart until apply log backup and all these tests ended with error :

-24988 sql error db_activate RECOVER \"Fil113600\" DATA; -3004,

save/restore type mismatch. I selected to create a new medium when warning about medium definition appear."

1)Why you are not using the DBMGUI tool?

2) Review the recommended hints & notes above, see also note::

767598 Available documentation

==> For SAP liveCache documentation in English:

http://help.sap.com/saphelp_nw04/helpdata/en/f2/0271f49770f0498d32844fc0283645/frameset.htm

-> User Manual: SAP liveCache -> Database Administration -> recoveries

-> Database Manager CLI, Commands for Restoring <click>

-> Recovering a Database Instance with Initialization

SAP MAXDB documentation ::

http://help.sap.com/saphelp_nw04/helpdata/en/b1/78bb3ee5bf7173e10000000a114084/frameset.htm

-> Background Knowledge -> Logging ->Using Log Entries at Restart or Recovery

&&

-> Background Knowledge -> High Availability

3) If you would like to use the dbmcli tool, try the following steps ::

I assumed ::

• <data-medium> - you created the complete databackup using this medium.

• <medium_name_log> :: LOGBACKUP - your log backup medium

" Creating a backup medium in the standby instance for importing the log backups from the original instance:

medium_put LOGBACKUP <path_log>\save.log FILE LOG "

Run your test scenario 1: .. Mark1 ..., complete databackup; Mark 2...; create the log backup .

Aftet that run::

dbmcli -d <SID> -u <dbm-user>,<pwd>

<enter>

dbmcli on <SID>>db_admin

dbmcli on <SID>>util_connect

dbmcli on <SID>>db_activate recover <data-medium> data

dbmcli on <SID>>db_restartinfo

< run this command to find out which log backup has to be imported first.

The Used Log Page line shows the next log page from which log entries have to be read.

Reviewed the buckup history >

dbmcli on <SID>>recover_start LOGBACKUP LOG <number of logbackup>

< Run "recover_replace LOGBACKUP <path_log>\save.log <number of logbackup +1>"

and so on, if you need to recover more as one log backups listed in backup history,

and created successfully. >

dbmcli on <SID>>recover_ignore

< after this command the liveCache will be in the ONLINE state >

dbmcli on <SID>>exit

4) For example I run the following steps in my local database::

dbmcli -d MAXDB1 -u control,control

dbmcli on MAXDB1>db_offline

OK

---

dbmcli on MAXDB1>medium_getall

OK

LOGBACKUP C:\sapdb\data\MAXDB1\backup\LOG FILE LOG 0 8

NO NO 20080226153620 20080226153620 NONE 0

INITIALBACKUP C:\sapdb\data\MAXDB1\backup\DATA1 FILE DATA 0

8 YES NO 20080226154106 20080226154106 NONE

0

dbmcli on MAXDB1>db_admin

OK

---

dbmcli on MAXDB1>util_connect

OK

---

dbmcli on MAXDB1>db_activate recover INITIALBACKUP data

…

… OK …

dbmcli on MAXDB1>db_restartinfo

< checked the results of "Used LOG Page" & Backup history file.

I had only one log backup created after I run the complete databackup … =>>

dbmcli on MAXDB1>recover_start LOGBACKUP LOG 001

dbmcli on MAXDB1>recover_ignore

….

dbmcli on MAXDB1>db_state

OK

State

ONLINE

---

dbmcli on MAXDB1>exit

OK

******

Thank you and best regards, Natalia Khlopina

[Former Member · Accepted solution]

Hi Natalia,

Thank you very much.

A) Customer message is 0000064340

B)

1) Because I thought would be more friendly

2) Ok, I did

I followed all the steps for dbmcli recovery and recovery finished OK, I'm not sure but maybe dbmgui don't have recovery options as clear.

Thanks again.

Best regards.

Alfonso

[former_member229109]

Hello Alfonso,

Please review the SAP notes and SAP documentation to find the answers on the reported questions, so far I din't see any errors in the posted thread:

869267 FAQ: MaxDB LOG area < Pay attention to 41., 42., 43., 44. >

820824 FAQ: MaxDB / SAP liveCache technology

767598 Available documentation

Hints:

A) Did you commit the transaction with creation of 'MARK2' before you run a liveCache log backup?

B) If you run the recovery without initialization & the liveCache was restartable after that, then you have the logging entries in the LOG area. You don't need to run the recovery of the LOG backup. Please see 40., 41., 42. of the note 869267. Restart after recovery works if the DBIdent in the log area matches the DBIdent in the data area.

C) When you run the recovery with initialization of the liveCache, the log area has been initialized !!

=> Restart after recovery works.

If you restarted the liveCache after the recovery with initialization was done, then tried to run the recovery of the log backup, you will get the error message 8003 "LOG and Data must be compatible" , Log- and data area are not compatible because 'Restore Log with Log State 'HistoryLost' is not allowed',

explained in the note 869267.

If you run the recovery with initialization of the liveCache the backup history is lost, you have to run the complete data backup before to be able to run the log backups.

Please run the recovery with initialization of the liveCache, start with recovery of the databackup, keep the liveCache in the admin mode, if you would like to run the recovery of the log backups in sequence. After recovery of the databackup finished please continue with the recovery of the log backups in sequence.

=> If the hints didn't help you, please create the OSS message as recommended by Lars.

Thank you and best regards, Natalia Khlopina

[lbreddemann]

HI Alfonso,

as a SAP customer you should open a support message in order to have this analyzed thorougly.

KR Lars