Skip to Content
0

MaxDB restore

Jul 05, 2017 at 04:27 PM

192

avatar image
Former Member

Hi

Have taken MaxDB complete data-backup in the main server and trying to restore the same in DR server but getting below errors. Can someone please help me on this

"-3004 Invalid host file sequenceServertask Info: because Error in backup task occuredJob 1 (Backup / Restore Medium Task) [executing] WaitingT57 Result=5220Error in backup task occured, #1 (E:\Backup\........) duplicate volumeBackup error occured, Error code 5220 "wrong_hostfile"

Maxdb version : 7.9

OS:Windows 2012 R2

10 |10000 characters needed characters left characters exceeded
Former Member

Hi James,

Have selected the option "initialize database before recover" and re-ran but getting the same error .

Thanks & Regards

Sateesh

0
Former Member

Hi James,

Complete data backup taken into one single file but while restoring it's asking us to "Change the medium to continue the restore process." .Check attached screenshot

Thanks & Regards

Sateesh

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

James Zhang
Jul 06, 2017 at 02:42 AM
0

Hi,

To restore backup to another server, did you chose "initialize database before recover" checkbox?
This should be used for such scenario.

Best regards,
James

Show 7 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi James,

Have selected the option "initialize database before recover" and re-ran but no luck .

Complete data backup taken into one single file but while restoring it's asking us to "Change the medium to continue the restore process." .Check attached screenshot

0

you want to do the recover with the backup was just finish restored?

Can you please share the screenshot from beginning? I mean after restore, you have option to start db, otherwise we need to do log recover instead of data recover.

0
Former Member

Hi James,

1.We have two MaxDB servers one is main server and other is DR server .Now my requirement is to keep the both servers data should be in sync

First I am taking Complete Data Backup from our main server .See attached screen shot 1

2.Have created template and started backup .check attached screen shots 2 and 3

3.Moved backup dump to target system and starting recovery(fyi due to previous incomplete recovery database was offline , So I have started fresh recovery now )check screen shot 4 and 5

4.After sometime recovery got failed check screen shot 6

1.jpeg (398.2 kB)
2.jpeg (503.6 kB)
3.jpeg (403.3 kB)
4.jpeg (640.9 kB)
5.jpeg (446.5 kB)
6.jpeg (732.1 kB)
0

I attached the screenshot 6copy.png form yours 6.jpeg.


You can see, we have option to start db, or back.

1. "start db", means we can start db, but we have no option to do recover log any more
2. "back" means, we can do log recover, but we have to chose log backup

For your case, you need to hit back, then chose log to recover. So the screenshot is like this hitback.png after hitting back, but you need to chose ""log backup"" instead of data backup


This is how maxdb standby works:

https://help.sap.com/doc/d7013cc67a7649ffab6c3b26444af8c0/7.5.7/en-US/4523882c9f9b4002e10000000a155369.html

Best regards,
James

6copy.png (68.9 kB)
hitback.png (99.1 kB)
0

I attached my recover steps as pdf, attached to:

https://mdocs.sap.com/mcm/public/v1/open?shr=-MALIWVFbUht7RoY4F5M-XPNJSlJEoxQ0n6VrzYVzdU


Sorry, I meant "restart" for previous start, then we need to click back, to do recover from beginning,
but this time, we need to select log backup or incremental backup.


So can you share the complete screenshot as I did and put into a pdf?


0
Former Member

Hi James,

Your recovery was completed that's why you got option to restart but my recovery is not completed and stuck in middle .it asking us to change the meduim to continue the restore , why it asking second file ?if i ignore and continue getting error check attached screenshot

untitled.png (62.3 kB)
0

please attach diagpack.tgz after executing: dbmcli -d <dbsid> -u superdba,<password> diag_pack

I need to read the maxdb log.

0