Creating database from backup on different OS

[Former Member]

I am trying to create a database on a Windows XP box from a backup of a database on a Windows 2003 box. I get this error in the knldiag.err :

2008-08-05 17:46:36 0xDD8 ERR 18246 IO Block_0 IO: LengthGiven = 49152, LenghtWanted = 65536

2008-08-05 17:46:36 0xD48 ERR 52012 RESTORE error occured, basis_err 3700

2008-08-05 17:46:36 0xD48 ERR 6 Recovery Data recovery failed

2008-08-05 17:46:36 0xD48 ERR 1 Backup + Backupmedium #1 (g:\temp\pp\monday) blockcount mismatch

2008-08-05 17:46:36 0xD48 ERR 6 KernelCo + Backup error occured, Error code 3700 "hostfile_error"

2008-08-05 17:46:36 0xD48 ERR 17 SrvTasks + Servertask Info: because Error in backup task occured

2008-08-05 17:46:36 0xD48 ERR 10 SrvTasks + Job 1 (Backup / Restore Medium Task) [executing] WaitingT73 Result=3700

2008-08-05 17:46:36 0xD48 ERR 6 KernelCo + Error in backup task occured, Error code 3700 "hostfile_error"

Is it possible to configure either the source or target database to work around this error?

Joe Lalor

[Former Member]

Thanks Markus

I hadn't done that originally, but I have done that now and my new database is working fine.

Thanks for your help.

If anyone else is interested, the dbmcli sequence I followed was :

dbmcli>db_create dbname dbm,dbm

OK

---

dbmcli>medium_put backupname "g:\temp\pp\monday" file data 0 8 NO

OK

---

dbmcli>service_connect

OK

---

dbmcli>recover_config backupname

OK

Returncode 0

Date 20080804

Time 00201013

Server x.x.local

Database dbname

Kernel Version Kernel 7.6.03 Build 015-123-173-107

Pages Transferred 0

Pages Left 0

Volumes

Medianame

Location g:\temp\pp\monday

Errortext blockcount mismatch

Label DAT_000000123

Is Consistent true

First LOG Page 155

Last LOG Page

DB Stamp 1 Date 20080804

DB Stamp 1 Time 00201003

DB Stamp 2 Date

DB Stamp 2 Time

Page Count 424

Devices Used 1

Database ID x.x.local:dbname_20080723_201014

Max Used Data Page 0

Converter Page Count 8

---

dbmcli>service_release

OK

---

dbmcli>param_put RUNDIRECTORY "g:\maxdb\data\wrk\dbname"

OK

---

dbmcli>param_put LOG_VOLUME_NAME_001 "g:\maxdb\data\wrk\dbname\diskl0001"

OK

---

dbmcli>param_put DATA_VOLUME_NAME_0001 "g:\maxdb\data\wrk\dbname\diskd0001"

OK

---

dbmcli>db_admin

OK

---

dbmcli>db_connect dbm,dbm

OK

---

dbmcli>db_activate recover backupmedium data

OK

Returncode 0

Date 20080805

Time 00215254

Server x.x.local

Database dbname

Kernel Version Kernel 7.6.03 Build 015-123-173-107

Pages Transferred 440

Pages Left 0

Volumes 1

Medianame backupname

Location g:\temp\pp\monday

Errortext

Label DAT_000000123

Is Consistent true

First LOG Page 155

Last LOG Page

DB Stamp 1 Date 20080804

DB Stamp 1 Time 00201003

DB Stamp 2 Date

DB Stamp 2 Time

Page Count 424

Devices Used 1

Database ID x.x.local:dbname_20080723_201014

Max Used Data Page 0

Converter Page Count 8

Joe

[Former Member]

Correct.

This may be the problem : I created the database using dbmcli as follows :

dbmcli>param_startsession

ERR

-24948,ERR_NODBNAME: database name required

---

dbmcli>db_create PolPlant dbm,dbm

OK

---

dbmcli>medium_put monday "g:\temp\pp\monday" file data 0 8 NO

OK

---

dbmcli>service_connect

OK

---

dbmcli>recover_config monday

OK

Returncode 0

Date 20080804

Time 00201013

Server it-sbs2003.ITBS.local

Database POLPLANT

Kernel Version Kernel 7.6.03 Build 015-123-173-107

Pages Transferred 0

Pages Left 0

Volumes

Medianame

Location g:\temp\pp\monday

Errortext blockcount mismatch

Label DAT_000000123

Is Consistent true

First LOG Page 155

Last LOG Page

DB Stamp 1 Date 20080804

DB Stamp 1 Time 00201003

DB Stamp 2 Date

DB Stamp 2 Time

Page Count 424

Devices Used 1

Database ID it-sbs2003.ITBS.local:POLPLANT_20080723_201014

Max Used Data Page 0

Converter Page Count 8

Should I have changed the database ID at this point, and how?

Joe

[markus_doehr2]

Since some version (I don't remember exactly) the recover with init command changed to

db_activate recover....

Did you use that one to recover?

Markus

[Former Member]

Thanks Markus

I'm not trying to recover the log, just the data from the latest complete data backup.

Joe

[markus_doehr2]

And this error occurs when the database is restored and is tried to be started?

Markus

[Former Member]

Thanks Markus.

Yes, I used "recovery with init..."

Joe

[markus_doehr2]

And you are trying to recover data + log?

It seems that the log is not from the source database...

Markus

[Former Member]

Thanks Markus

Yes, I had configured the media differently. I now have this error - if you wish I'll mark this thread as answered and open a new one. Here it is anyway :

2008-08-05 18:47:35 0xD48 ERR 51080 SYSERROR -9407 unexpected error

2008-08-05 18:47:35 0xD48 ERR 3 Admin Database state: OFFLINE

2008-08-05 18:47:35 0xD48 ERR 20028 Log + DBIdentifier of DataVolume (it-sbs2003.ITBS.local:POLPLANT_20080723_201014) and LogVolume (LAPTOP.local.lan:PO

2008-08-05 18:47:35 0xD48 ERR 20028 Log + LPLANT_20080805_174236) does not match

2008-08-05 18:47:35 0xD48 ERR 8 Log + Log- and data area are not compatible because 'The DB Identifiers are not equal'.

2008-08-05 18:47:35 0xD48 ERR 20028 Admin + Initialization of log for 'restart' failed with 'LogAndDataIncompatible'

2008-08-05 18:47:35 0xAC ERR 7 Messages Begin of dump of registered messages

2008-08-05 18:47:35 0xAC ERR 8 Messages End of the message list registry dump

2008-08-05 18:47:38 ___ Stopping GMT 2008-08-05 17:47:38 7.6.03 Build 015-123-173-107

Joe

[markus_doehr2]

Did you use a "recovery with initialization"?

Markus

[Former Member]

Thanks Markus

The db versions are the same 7.6.3.15.

The BACKUP_BLOCK_CNT is 64 for both dbs (this parameter has the comment "It is obsolete")

Joe

[markus_doehr2]

> The db versions are the same 7.6.3.15.

Ok. The database version on the machine you restore shouldn't be lower than the source database. That's ok.

>

> The BACKUP_BLOCK_CNT is 64 for both dbs (this parameter has the comment "It is obsolete")

Ok.

Did you maybe configure the backup medium differently? Different blocksizes?

Markus

[markus_doehr2]

> 2008-08-05 17:46:36 0xDD8 ERR 18246 IO Block_0 IO: LengthGiven = 49152, LenghtWanted = 65536

- are you using the same database version on both systems?

- check the parameter BACKUP_BLOCK_CNT on both systems

Markus