cancel
Showing results for 
Search instead for 
Did you mean: 

restore problem at maxdb version 7.8.02.23 from tape

0 Kudos

Dear Gurus.

I have a plan to migrate content server from windows 2003 32bit os system to windows 2008 r2 64bit os system with maxdb upgrade(7.5.00.44 -> 7.8.02.23)

I prepared 64bit test system on vm ware with 2.8Tera byte storage.

For your information, I have production system with 2tera byte.

I have read many notes about migration.

So I see that I can use backup/restore manner at situation of windows 2003 32bit -> windows 2008 64bit (same byte-assortment) and original db is as of 7.5.

I use tape device and external backup tool(Legato Networker) with parallel for backup on production system.

I want to restore its backuped file to new test 64 machine from tape device.

But an error was appeared.

I uses parallel backup medium to backup.

So I intstalled networker client on 64bit test system.

And I configured env file at C:\program files\nsr\sapdb\env.

Below is content of it. It was modified it of production server.

-


NSR_HOST dwbak01

NSR_HOME "C:\Program Files\Legato\nsr\bin"

NSR_POOL "PDC Weekly"

NSR_EXPIRE 2weeks

NSR_FULL "DATA RECOVERY"

NSR_NOTVERBOSE RECOVER

NSR_EBIDTYPE NSAVETIME

NSR_USEOUTPUT SAVE

NSR_IGNOREERROR " unknown error 109 (0x6d)"

NSR_IGNOREERROR " using unlocked access"

NSR_IGNOREERROR " The pipe has been ended."

NSR_IGNOREERROR " 파이프가 끝났습니다."

NSR_SAVEINTERVAL 60

NSR_BACKUPNAME SAPDB:<database_name>_on_<node>

NSR_AVOIDPSSIDBUG YES

...NSR_SAVETIMEFORMAT "yyyy/mm/dd HH:MM:SS AM"

...NSR_SAVETIMEFORMAT "yyyy-mm-dd xxxx HH:MM:SS"

NSR_SAVETIMEFORMAT "yyyy.mm.dd AM HH:MM:SS; AM=오전; PM=오후"

...NSR_SAVETIMEFORMAT "yyyy.mm.dd HH:MM:SS"

...NSR_SIZEROUNDUP NOROUNDUP

...NSR_SIZEROUNDUP FIRSTDECIMAL

-


And below is dbm.ebp on test 64bit server.

-


2011-12-06 11:23:58

Using environment variable 'TEMP' with value 'C:\Windows\TEMP' as directory for temporary files and pipes.

Using MaxDB Kernel Process.

Using connection to Legato's NetWorker with save, recover and mminfo.

2011-12-06 11:23:58

Checking existence and configuration of NetWorker.

Using environment variable 'NSR_ENV' with value 'C:\Program Files\nsr\sapdb\env' as path of NetWorker's configuration file.

Found NetWorker setting for 'NSR_HOST': 'dwbak01'.

Found NetWorker setting for 'NSR_HOME': 'C:\Program Files\Legato\nsr\bin'.

Found NetWorker setting for 'NSR_POOL': 'PDC Weekly'.

Found NetWorker setting for 'NSR_EXPIRE': '2weeks'.

Found NetWorker setting for 'NSR_FULL': 'DATA RECOVERY'.

Found NetWorker setting for 'NSR_NOTVERBOSE': 'RECOVER'.

Found NetWorker setting for 'NSR_EBIDTYPE': 'NSAVETIME'.

Found NetWorker setting for 'NSR_USEOUTPUT': 'SAVE'.

Found NetWorker setting for 'NSR_IGNOREERROR': ' unknown error 109 (0x6d)'.

Found NetWorker setting for 'NSR_IGNOREERROR': ' using unlocked access'.

Found NetWorker setting for 'NSR_IGNOREERROR': ' The pipe has been ended.'.

Found NetWorker setting for 'NSR_IGNOREERROR': ' 파이프가 끝났습니다.'.

Found NetWorker setting for 'NSR_SAVEINTERVAL': '60'.

Found NetWorker setting for 'NSR_BACKUPNAME': 'SAPDB:<database_name>_on_<node>'.

Found NetWorker setting for 'NSR_AVOIDPSSIDBUG': 'YES'.

Found NetWorker setting for 'NSR_SAVETIMEFORMAT': 'yyyy.mm.dd AM HH:MM:SS; AM=오전; PM=오후'.

Using NetWorker programs:

'C:\Program Files\Legato\nsr\bin\save.exe'

'C:\Program Files\Legato\nsr\bin\recover.exe'

'C:\Program Files\Legato\nsr\bin\mminfo.exe'

Check passed successfully.

2011-12-06 11:23:58

Preparing query for available backups.

Constructed NetWorker call '"C:\Program Files\Legato\nsr\bin\mminfo.exe" -a -s dwbak01 -c CONTAR01 -r name(26),pssid,level(4),savetime(26),totalsize,nsavetime -o t -N SAPDB:SDB_on_CONTAR01'.

Created temporary file 'C:\Windows\TEMP\temp1323138238-0' as output for NetWorker.

Created temporary file 'C:\Windows\TEMP\temp1323138238-1' as error output for NetWorker.

Setting environment variable 'NSR_MAST' to value 'nsradmin'.

Prepare passed successfully.

2011-12-06 11:23:58

Starting NetWorker.

Starting NetWorker process '"C:\Program Files\Legato\nsr\bin\mminfo.exe" -a -s dwbak01 -c CONTAR01 -r name(26),pssid,level(4),savetime(26),totalsize,nsavetime -o t -N SAPDB:SDB_on_CONTAR01 >>C:\Windows\TEMP\temp1323138238-0 2>>C:\Windows\TEMP\temp1323138238-1'.

Process was started successfully.

NetWorker has been started successfully.

2011-12-06 11:23:58

Waiting for end of the query.

2011-12-06 11:23:58 The backup tool is running.

2011-12-06 11:24:01 The backup tool process has finished work with return code 1.

Have encountered error -24920:

The backup tool failed with 1 as sum of exit codes.

Constructed the following reply:

ERR

-24920,ERR_BACKUPOP: backup operation was unsuccessful

The backup tool failed with 1 as sum of exit codes.

NetWorker has finished the query unsuccessfully.

2011-12-06 11:24:01

Cleaning up.

Copying output of NetWorker to this file.

-


Begin of output of NetWorker (C:\Windows\TEMP\temp1323138238-0)----


-


End of output of NetWorker (C:\Windows\TEMP\temp1323138238-0)----


Removed NetWorker's temporary output file 'C:\Windows\TEMP\temp1323138238-0'.

Copying error output of NetWorker to this file.

-


Begin of error output of NetWorker (C:\Windows\TEMP\temp1323138238-1)----


6095:mminfo: 쿼리에 대해 일치하는 항목이 없습니다.

-


End of error output of NetWorker (C:\Windows\TEMP\temp1323138238-1)----


Removed NetWorker's temporary error output file 'C:\Windows\TEMP\temp1323138238-1'.

Have finished clean up successfully.

-


Any replay can be helped to me.

Thank you for reading

Edited by: Bong Su on Dec 8, 2011 2:41 AM

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
0 Kudos

> 6095:mminfo: 쿼리에 대해 일치하는 항목이 없습니다.

This is the error message. Since your server seems to be in Korean (as opposed to what's recommended in English) I can't help you here but point to the error message.

This seems to mean "there are no results for your requests" (according to google translator) there seems to be something wrong with networker. You use the same networker version on both systems?

Markus

0 Kudos

Markus. Thank you for your update!

I think that your guess 'there are no results for your requests' for error 6095 is right.

I use same networker client version on the both systems.

Isn't Any problem in my test server's env entry or else?

Bong su.

0 Kudos

I tested backup after restart max db.

It is ok now. I changed the parameter for 'MaxBackupMedia' that cause the error.

Now I need to restore from another server's(r3lct00:now production sever) backup copy to test server.

I can see only the backup copies on this(test) server.

Should I change my env file for this?

If yes, how?

And, I want to know what I can input entry in dialog box(recovery of database <LOCAL> :SDB)

I can see the mesage at there.

'If the backup was made from a different database, substitute the name of the current database by the name of the database wherer the backup was made.'

And below there are some field I have to inbut.

databse server: database name: 'Apply' button.

Any advices can be helped to me.

Thank you.

markus_doehr2
Active Contributor
0 Kudos

> I can see the mesage at there.

> 'If the backup was made from a different database, substitute the name of the current database by the name of the database wherer the backup was made.'

> And below there are some field I have to inbut.

> databse server: database name: 'Apply' button.

Do as the program suggests

What program do you use to restore the database? DBMGUI? DBStudio?

Markus

0 Kudos

Dear Markus.

Thank you for your update.

I use DBStudio. Can I use DBMGUI for maxdb version as of 7.8?

Bong Su.

0 Kudos

I tested backup/restore today.

I can backup/restore in my new 64bit test server with single medium pipe option.

But I can backup and I can not restore with parallel pipe option.

I found this text on dbm.ebp file.

I think below text indicates that some error of external backup ID on 'The list of external backup ID's contains less than 4 ID's.'

But I can see the 4 backup copies on restore dialog.

-


2011-12-14 10:40:10

Using environment variable 'TEMP' with value 'C:\Windows\TEMP' as directory for temporary files and pipes.

Using MaxDB Kernel Process.

Using connection to Legato's NetWorker with save, recover and mminfo.

2011-12-14 10:40:10

Checking existence and configuration of NetWorker.

Setting environment variable 'NSR_ENV' for the path of NetWorker's configuration file to default 'C:\Program Files\nsr\sapdb\env'.

Found NetWorker setting for 'NSR_HOST': 'dwbak01'.

Found NetWorker setting for 'NSR_HOME': 'C:\Program Files\Legato\nsr\bin'.

Found NetWorker setting for 'NSR_POOL': 'PDC Weekly'.

Found NetWorker setting for 'NSR_EXPIRE': '2weeks'.

Found NetWorker setting for 'NSR_FULL': 'DATA RECOVERY'.

Found NetWorker setting for 'NSR_NOTVERBOSE': 'RECOVER'.

Found NetWorker setting for 'NSR_EBIDTYPE': 'NSAVETIME'.

Found NetWorker setting for 'NSR_USEOUTPUT': 'SAVE'.

Found NetWorker setting for 'NSR_IGNOREERROR': ' unknown error 109 (0x6d)'.

Found NetWorker setting for 'NSR_IGNOREERROR': ' using unlocked access'.

Found NetWorker setting for 'NSR_IGNOREERROR': ' The pipe has been ended.'.

Found NetWorker setting for 'NSR_IGNOREERROR': ' 파이프가 끝났습니다.'.

Found NetWorker setting for 'NSR_SAVEINTERVAL': '60'.

Found NetWorker setting for 'NSR_BACKUPNAME': 'SAPDB:<database_name>_on_<node>'.

Found NetWorker setting for 'NSR_AVOIDPSSIDBUG': 'YES'.

Found NetWorker setting for 'NSR_SAVETIMEFORMAT': 'yyyy.mm.dd AM HH:MM:SS; AM=오전; PM=오후'.

Using NetWorker programs:

'C:\Program Files\Legato\nsr\bin\save.exe'

'C:\Program Files\Legato\nsr\bin\recover.exe'

'C:\Program Files\Legato\nsr\bin\mminfo.exe'

Check passed successfully.

2011-12-14 10:40:11

Checking medium.

All pipes are located in '
.\pipe\'.

Check passed successfully.

2011-12-14 10:40:11

Preparing restore.

Have encountered error -24925:

The list of external backup ID's contains less than 4 ID's.

Constructed the following reply:

ERR

-24925,ERR_PREPARE: preparation of backup operation failed

The list of external backup ID's contains less than 4 ID's.

Prepare failed.

2011-12-14 10:40:11

Waiting for end of the restore operation.

2011-12-14 10:40:11 The backup tool is not running.

The restore operation has ended.

2011-12-14 10:40:11

Cleaning up.

Have finished clean up successfully.

-


0 Kudos

This problem was occured by db studio version 7.8.

Use 7.9.08.01 version of db studio.

7.9.08.02 version have same problem.

Answers (1)

Answers (1)

0 Kudos

Emm.

I edidted my upper problem text by text editor.

So, can I see my text as a strange form?

I can see strange form at tab of 'Preview'

How can I do to make my text to beauty form?

Thanks.

Edited by: Bong Su on Dec 8, 2011 2:50 AM

Edited by: Bong Su on Dec 8, 2011 2:51 AM