Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Load dmp file not success

2 posts in Backup and Recovery Last posting was on 2009-09-12 00:56:16.0Z
prateep Posted on 2009-09-11 06:08:15.0Z
Sender: 5d67.4aa8e7e4.1804289383@sybase.com
From: prateep
Newsgroups: sybase.public.ase.backup+recovery
Subject: Load dmp file not success
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4aa9e94f.2e8.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Sep 2009 23:08:15 -0700
X-Trace: forums-1-dub 1252649295 10.22.241.41 (10 Sep 2009 23:08:15 -0700)
X-Original-Trace: 10 Sep 2009 23:08:15 -0700, 10.22.241.41
Lines: 50
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4030
Article PK: 48117

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] Posted on 2009-09-12 00:56:16.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.backup+recovery
References: <4aa9e94f.2e8.1681692777@sybase.com>
In-Reply-To: <4aa9e94f.2e8.1681692777@sybase.com>
Subject: Re: Load dmp file not success
Lines: 70
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18005
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4aaaf1b0@forums-1-dub>
Date: 11 Sep 2009 17:56:16 -0700
X-Trace: forums-1-dub 1252716976 10.22.241.152 (11 Sep 2009 17:56:16 -0700)
X-Original-Trace: 11 Sep 2009 17:56:16 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4031
Article PK: 48119

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

"prateep" wrote in message news:4aa9e94f.2e8.1681692777@sybase.com...
> 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