Restore Database to different Server Using Networker

[former_member100189]

I am trying to restore a database backed up from server A to server B. I am using Networker with PIPE backups. At first I could not get the restore software to recognize the backup due to date format error. So I removed the line 'NSR_SAVETIMEFORMAT "yyyy/mm/dd HH:MM:SS AM"" FROM THE ENV FILE. Now the gui recognizes the backup and tries to start it. However it fails with the error:

The line 'MAXDB:SLD 0 3 01/07/08 09:54:47 1622 MB 1199721287' is ignored, as it does not contain a backup ID at 'MB 1199721287'.

the output from the mminfo command is:

lin-test:/sdb/data/wrk/SLD # /usr/sbin/mminfo -a -s USSLVBACKUP1.hollister.com -c lvlcxsld -r "name(26),pssid,level(4),savetime(23),totalsize,nsavetime" -o t -N MAXDB:SLD

name prev ssid lvl date time total save time

MAXDB:SLD 0 3 01/07/08 09:54:47 1622 MB 1199721287

[former_member229109]

Hello,

The list of available backups could not be completed because of the time format used by networker.

You have to configure the dbmserver that it understands this time format. Therefore please set paramater

NSR_SAVETIMEFORMAT to "mm/dd/yy HH:MM:SS AM"

in the configuration file for NetWorker.

You can find documentation about this parameter setting online:

http://maxdb.sap.com/currentdoc/default.htm -> Installation ->

Installation Manual -> Connecting Backup Tools from Other Providers ->

< Review "Connecting Backup Tools from Other Providers"

-> Connecting to NetWorker ->

Configuring the NetWorker Connection >

.. Go to

-> Restoring with Backup Tools from other Providers

As you know, the backup history of the database is written in the following log files:

· For backups without external backup tools, in the dbm.knl log file

· For backups with external backup tools, in the dbm.ebf log file

For example, you could create the database on the target server, bring it into mode ADMIN

and activate/recover it using DBMCLI.

Activating a database with a backup can be done as follows:

dbmcli -d can be determined using backup_ext_ids_get/backup_ext_ids_list

on the source database server.

***

Please update with additional information::

• What version of DBMGUI are you using to run restore on the target machine?

• What are the versions of the source & target database?

• Please post the

• Are you SAP customer?

• It will be helpful to review the dbm.ebp, dbm.prt & knldiag.err files from the target server

& dbm.knl, dbm.ebl files from the source server and ouput of the dbm commands 'medium_getall',

"backup_ext_ids_get

Thank you and best regards, Natalia Khlopina

[markus_doehr2]

Are you using the same backup client version on the source and target system? I´ve seen those kinds of error when they are not equal.

Markus

[former_member100189]

Yes, Both are running Networker 7,4

[markus_doehr2]

Ok.. then this can´t be the error... and the NSR files are also the same - and also the names of the media?

If yes - please post the relevant part of dbm.ebl

Markus

[former_member100189]

Here is where it fails.

Created temporary file '/tmp/temp1199723247-0' as output for NetWorker.

Created temporary file '/tmp/temp1199723247-1' as error output for NetWorker.

Prepare passed successfully.

2008-01-07 10:27:27

Starting NetWorker.

Starting NetWorker process '/usr/sbin/mminfo -a -s USSLVBACKUP1.hollister.com -c lvlcxsld -r name(26),pssid,level(4),savetime(23),totalsize,nsavetime -o t -N MAXDB:SLD >>/tmp/temp1199723247-0 2>>/tmp/temp1199723247-1'.

Process was started successfully.

NetWorker has been started successfully.

2008-01-07 10:27:27

Waiting for end of the query.

2008-01-07 10:27:27 The backup tool is running.

2008-01-07 10:27:28 The backup tool process has finished work with return code 0.

NetWorker has finished the query successfully.

2008-01-07 10:27:28

Analyzing NetWorker's answer.

The line ' name prev ssid lvl date time total save time' is ignored, as it does not start with the backup name MAXDB:SLD.

The line 'MAXDB:SLD 0 3 01/07/08 09:54:47 1622 MB 1199721287' is ignored, as it does not contain a backup ID at 'MB 1199721287'.

Finished analyzing NetWorker's answer.

2008-01-07 10:27:28

Cleaning up.

Copying output of NetWorker to this file.

-

---

Begin of output of NetWorker (/tmp/temp1199723247-0)----

---

name prev ssid lvl date time total save time

MAXDB:SLD 0 3 01/07/08 09:54:47 1622 MB 1199721287

-

---

End of output of NetWorker (/tmp/temp1199723247-0)----

---

Removed NetWorker's temporary output file '/tmp/temp1199723247-0'.

Copying error output of NetWorker to this file.

-

---

Begin of error output of NetWorker (/tmp/temp1199723247-1)----

---

-

---

End of error output of NetWorker (/tmp/temp1199723247-1)----

---

Removed NetWorker's temporary error output file '/tmp/temp1199723247-1'.

Have finished clean up successfully.

[markus_doehr2]

I guess this is some NSR_*something parameter - but I can´t help you here - sorry...

Markus