Discussion:
Load Failure - Please Help
(too old to reply)
unknown
2005-11-29 19:20:28 UTC
Permalink
I am attempting to load a 136gig database from a dump that
was sent to me. The create database and load statements
where sent and I have used them but I am getting an error.
I have increased the shared memory on the backupserver to
1024mb (same as the backupserver it was dumped from) but to
no avail. The servers are both at ASE 12.5.3 EBF 12330.
If you could respond to ***@statestreet.com, I would
appreciate it.

Any help would be appreciated:

load database edw_ge
from 'compress::/GEAM_UAT/jgriff_ready_1.dump'
stripe on 'compress::/GEAM_UAT/jgriff_ready_2.dump'
stripe on 'compress::/GEAM_UAT/jgriff_ready_3.dump'
stripe on 'compress::/GEAM_UAT/jgriff_ready_4.dump'
go

...
Backup Server: 4.58.1.1: Database edw_ge: 32659784 kilobytes
LOADed.
Backup Server: 4.58.1.1: Database edw_ge: 34390354 kilobytes
LOADed.
Backup Server: 3.14.2.4: Logical page 23739903 is not in the
given database map.
Backup Server: 6.32.2.3:
compress::/GEAM_UAT/jgriff_ready_2.dump::01: volume not
valid or not requested
(server: , session id: 5.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD session must exit.
Backup Server: 6.32.2.3:
compress::/GEAM_UAT/jgriff_ready_1.dump::00: volume not
valid or not requested
(server: , session id: 5.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD session must exit.
Backup Server: 4.58.1.1: Database edw_ge: 35774806 kilobytes
LOADed.
Backup Server: 6.32.2.3:
compress::/GEAM_UAT/jgriff_ready_3.dump::02: volume not
valid or not requested
(server: , session id: 5.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD session must exit.
Nov 29 13:50:42 2005 Backup Server: 6.32.2.3:
compress::/GEAM_UAT/jgriff_ready_4.dump::03: volume not
valid or not requested (server: , session id: 5.)
Msg 8009, Level 16, State 1:
Server 'S06DST1'Nov 29 13:50:42 2005, Line 1:
Error encountered by Backup Server. Please refer to Backup
Server messages for details.
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD session must exit.
1> Open Server Error: 16144.10.0: Server process '5' is not
allocated in 'srv_event'
Michael Peppler
2005-11-30 17:35:49 UTC
Permalink
Logical page 23739903 is not in the given
database map
I have seen this error a few times, and usually it was a problem with a
corrupted database dump, requiring a new dump to be made on the source
server.

Michael
--
Michael Peppler - ***@peppler.org - http://www.peppler.org/
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com/
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html
MRG
2005-12-12 16:20:36 UTC
Permalink
What are the page sizes & platforms of the source and target.

You may have problems loading a backup compressed in one platform to
another platform and the error messages for those errors have similar
wordings.

Ganesan Murugappan

Loading...