Discussion:
Load dmp file not success
(too old to reply)
prateep
2009-09-11 06:08:15 UTC
Permalink
Raw Message
Hi,

We have dump database to SAN location by "dump database
dacs_main to '/xxxxxxx'. Then we restore it back by "load
database dacs_main from '/xxxxxxxx'" But we got the
error as below.

Backup Server: 4.58.1.1: Database dacs_main: 19716524
kilobytes LOADED.
Backup Server: 4.58.1.1: Database dacs_main: 19931574
kilobytes LOADED.
Backup Server: 4.58.1.1: Database dacs_main: 20146624
kilobytes LOADED.
Backup Server: 4.58.1.1: Database dacs_main: 20361674
kilobytes LOADED.
Backup Server: 4.58.1.1: Database dacs_main: 20576724
kilobytes LOADED.
Backup Server: 4.58.1.1: Database dacs_main: 20791774
kilobytes LOADED.
Backup Server: 4.58.1.1: Database dacs_main: 20972520
kilobytes LOADED.
Backup Server: 4.58.1.1: Database dacs_main: 20972528
kilobytes LOADED.
Backup Server: 6.32.2.2:
/reuters/sybase/dacs_main.20090908.dmp: volume not
valid or not requested (server: , session id: 5.)
Backup Server: 1.14.2.3: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 6.32.2.3:
/reuters/sybase/dacs_main.20090908.dmp: 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.
Msg 8009, Level 16, State 1:
Server 'DACS', Line 1:
Error encountered by Backup Server. Please refer to Backup
Server messages for
details.
1>

The size of database is 20GB. Size of
database may be the cause of the problem? We have test
with database size around 4GB and it works fine.

Thank you very much for your kindly help.

Regards,
Prateep
"Cory Sane [TeamSybase]" <cory!=sane>
2009-09-12 00:56:16 UTC
Permalink
Raw Message
Wow - I saw Dacs stuff several years ago.

a. You need to rule out that you dumps are not failing too.

b. Are you hitting a 4GB read limit?
The 4GB limit is a limitation of the old 32bit filesystems.
(I see that you load is up to 20GB, but is there really a 4GB file with compression?)
(i've seen cases where you can write over 4GB but not read it)

To diagnose this problem, collect the following information:
a) ASE version -- @@version
b) OS version -- "uname -a"
c) mount information for your dump filessystem.
--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0
Post by prateep
Hi,
We have dump database to SAN location by "dump database
dacs_main to '/xxxxxxx'. Then we restore it back by "load
database dacs_main from '/xxxxxxxx'" But we got the
error as below.
Backup Server: 4.58.1.1: Database dacs_main: 19716524
kilobytes LOADED.
Backup Server: 4.58.1.1: Database dacs_main: 19931574
kilobytes LOADED.
Backup Server: 4.58.1.1: Database dacs_main: 20146624
kilobytes LOADED.
Backup Server: 4.58.1.1: Database dacs_main: 20361674
kilobytes LOADED.
Backup Server: 4.58.1.1: Database dacs_main: 20576724
kilobytes LOADED.
Backup Server: 4.58.1.1: Database dacs_main: 20791774
kilobytes LOADED.
Backup Server: 4.58.1.1: Database dacs_main: 20972520
kilobytes LOADED.
Backup Server: 4.58.1.1: Database dacs_main: 20972528
kilobytes LOADED.
/reuters/sybase/dacs_main.20090908.dmp: volume not
valid or not requested (server: , session id: 5.)
Backup Server: 1.14.2.3: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
/reuters/sybase/dacs_main.20090908.dmp: 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.
Error encountered by Backup Server. Please refer to Backup
Server messages for
details.
1>
The size of database is 20GB. Size of
database may be the cause of the problem? We have test
with database size around 4GB and it works fine.
Thank you very much for your kindly help.
Regards,
Prateep
Loading...