unknown
2005-11-29 19:20:28 UTC
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'
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'