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.

Loading Problem

6 posts in Backup and Recovery Last posting was on 2008-09-23 15:30:49.0Z
Sivakumar R Posted on 2008-09-23 06:40:19.0Z
Sender: 2238.48d854b0.1804289383@sybase.com
From: Sivakumar R
Newsgroups: sybase.public.ase.backup+recovery
Subject: Loading Problem
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48d88f53.2767.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 22 Sep 2008 23:40:19 -0700
X-Trace: forums-1-dub 1222152019 10.22.241.41 (22 Sep 2008 23:40:19 -0700)
X-Original-Trace: 22 Sep 2008 23:40:19 -0700, 10.22.241.41
Lines: 56
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3869
Article PK: 47962

Hi,

I am facing a problem when I am trying to load a dump
database in to Sybase Adaptive Server Enterprise v 15.0.2

I am trying to recover a backup database from the
Interactive SQL. Here are the methods I used.

1. Method 1: Loading Database from Backup

LOAD DATABASE momdb FROM 'E:\mom_backup\cbcdat21.dat'

Here are the error logs:

Sep 23 13:04:35 2008: Backup Server: 2.23.1.1: Connection
from Server TESTSRV1 on Host testsrv1 with HostProcid .
Sep 23 13:04:35 2008: Backup Server: 4.10.2.1: Label
validation error: first label not VOL1.
Sep 23 13:04:35 2008: Backup Server: 6.31.2.4: Volume
rejected.
Sep 23 13:04:35 2008: Backup Server: 1.14.2.2: Unrecoverable
I/O or volume error. This DUMP or LOAD session must exit.
Sep 23 13:04:35 2008: Backup Server: 6.32.2.3:
E:\mom_backup\cbcdat21.dat: volume not valid or not
requested (server: , session id: 67.)
Sep 23 13:04:35 2008: Backup Server: 1.14.2.4: Unrecoverable
I/O or volume error. This DUMP or LOAD session must exit.


2. Method 2: Loading Archive Database

LOAD DATABASE momdb FROM
'compress::E:\mom_backup\cbcdat21.dat'

Here are the error logs:
Sep 23 13:05:26 2008: Backup Server: 2.23.1.1: Connection
from Server TESTSRV1 on Host testsrv1 with HostProcid .
Sep 23 13:05:26 2008: Backup Server: 4.132.1.1: Attempting
to open byte stream device:
'compress::E:\mom_backup\cbcdat21.dat::00'
Sep 23 13:05:26 2008: Backup Server: 4.10.2.1: Label
validation error: first label not VOL1.
Sep 23 13:05:26 2008: Backup Server: 6.31.2.4: Volume
rejected.
Sep 23 13:05:26 2008: Backup Server: 1.14.2.2: Unrecoverable
I/O or volume error. This DUMP or LOAD session must exit.
Sep 23 13:05:26 2008: Backup Server: 6.32.2.3:
compress::E:\mom_backup\cbcdat21.dat::00: volume not valid
or not requested (server: , session id: 69.)
Sep 23 13:05:26 2008: Backup Server: 1.14.2.4: Unrecoverable
I/O or volume error. This DUMP or LOAD session must exit

Do you have any idea about this?

Thanks,
Sivakumar R


Luc Van der Veurst Posted on 2008-09-23 07:17:22.0Z
From: "Luc Van der Veurst" <dba_azvub@hotmail.com>
Newsgroups: sybase.public.ase.backup+recovery
References: <48d88f53.2767.1681692777@sybase.com>
Subject: Re: Loading Problem
Lines: 68
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-Forwarded: by - (DeleGate/5.8.7)
X-Forwarded: by - (DeleGate/5.8.7)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48d89802$1@forums-1-dub>
Date: 23 Sep 2008 00:17:22 -0700
X-Trace: forums-1-dub 1222154242 10.22.241.152 (23 Sep 2008 00:17:22 -0700)
X-Original-Trace: 23 Sep 2008 00:17:22 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3870
Article PK: 47966

When reporting load database problems, it's always good to give the
dump database command as well as the load database command.
Especially when using compression.

Are you sure that 'E:\mom_backup\cbcdat21.dat' is a database dump
and not a database device ?

Luc.

<Sivakumar R> wrote in message news:48d88f53.2767.1681692777@sybase.com...
> Hi,
>
> I am facing a problem when I am trying to load a dump
> database in to Sybase Adaptive Server Enterprise v 15.0.2
>
> I am trying to recover a backup database from the
> Interactive SQL. Here are the methods I used.
>
> 1. Method 1: Loading Database from Backup
>
> LOAD DATABASE momdb FROM 'E:\mom_backup\cbcdat21.dat'
>
> Here are the error logs:
>
> Sep 23 13:04:35 2008: Backup Server: 2.23.1.1: Connection
> from Server TESTSRV1 on Host testsrv1 with HostProcid .
> Sep 23 13:04:35 2008: Backup Server: 4.10.2.1: Label
> validation error: first label not VOL1.
> Sep 23 13:04:35 2008: Backup Server: 6.31.2.4: Volume
> rejected.
> Sep 23 13:04:35 2008: Backup Server: 1.14.2.2: Unrecoverable
> I/O or volume error. This DUMP or LOAD session must exit.
> Sep 23 13:04:35 2008: Backup Server: 6.32.2.3:
> E:\mom_backup\cbcdat21.dat: volume not valid or not
> requested (server: , session id: 67.)
> Sep 23 13:04:35 2008: Backup Server: 1.14.2.4: Unrecoverable
> I/O or volume error. This DUMP or LOAD session must exit.
>
>
> 2. Method 2: Loading Archive Database
>
> LOAD DATABASE momdb FROM
> 'compress::E:\mom_backup\cbcdat21.dat'
>
> Here are the error logs:
> Sep 23 13:05:26 2008: Backup Server: 2.23.1.1: Connection
> from Server TESTSRV1 on Host testsrv1 with HostProcid .
> Sep 23 13:05:26 2008: Backup Server: 4.132.1.1: Attempting
> to open byte stream device:
> 'compress::E:\mom_backup\cbcdat21.dat::00'
> Sep 23 13:05:26 2008: Backup Server: 4.10.2.1: Label
> validation error: first label not VOL1.
> Sep 23 13:05:26 2008: Backup Server: 6.31.2.4: Volume
> rejected.
> Sep 23 13:05:26 2008: Backup Server: 1.14.2.2: Unrecoverable
> I/O or volume error. This DUMP or LOAD session must exit.
> Sep 23 13:05:26 2008: Backup Server: 6.32.2.3:
> compress::E:\mom_backup\cbcdat21.dat::00: volume not valid
> or not requested (server: , session id: 69.)
> Sep 23 13:05:26 2008: Backup Server: 1.14.2.4: Unrecoverable
> I/O or volume error. This DUMP or LOAD session must exit
>
> Do you have any idea about this?
>
> Thanks,
> Sivakumar R