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.

Error loading DB with headeronly

4 posts in Backup and Recovery Last posting was on 2001-03-14 11:40:19.0Z
Vittorio Brugiatelli Posted on 2001-03-12 17:54:09.0Z
Message-ID: <3AAD0D41.A5D8705F@wuerth-phoenix.com>
Date: Mon, 12 Mar 2001 18:54:09 +0100
From: Vittorio Brugiatelli <vittorio.brugiatelli@wuerth-phoenix.com>
X-Mailer: Mozilla 4.6 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Error loading DB with headeronly
Content-Type: multipart/mixed; boundary="------------4C489ACE541850C2DDA97438"
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 62
NNTP-Posting-Host: 62.110.70.132
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:415
Article PK: 1060942

Hi there,
I'm new with Sybase, so please be patient...

I want to make some test with the dump & Load command (Sybase ASE
v.11.9.2 on Linux server)
on a HP DAT (DDS4 40Gb)

I dump two Databases with following command:

dump database db1 to tapedump3 with init
dump database db2 to tapedump3 with unload

It seems to work.
Before loading them, I want to know what is stored in the DAT, so I
typed:

load database db1 from tapedump3 with headeronly
load database db2 from tapedump3 with headeronly

These are the messages I obtained:

Server Message: Number 3216, Severity 10
Line 1:
Backup Server session id is: 26. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume
change request from the Backup Server.
Server Message: Number 603102, Severity 2
Server 'phxlinux_back', Procedure 'as_control', Line 0:
Backup Server: 6.31.2.1: Volume rejected.
Server Message: Number 603202, Severity 2
Server 'phxlinux_back', Procedure 'as_control', Line 0:
Backup Server: 6.32.2.3: /dev/st0: volume not valid or not requested
(server: , session id: 26.)
Server Message: Number 101402, Severity 2
Server 'phxlinux_back', Procedure 'as_control', Line 0:
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP
or LOAD session must exit.
Server Message: Number 604501, Severity 1
Server 'phxlinux_back', Procedure 'as_control', Line 0:
Backup Server: 6.45.1.1: Be sure to remove the tape/floppy from drive
/dev/st0 (server: , session id: 26).
Server Message: Number 3216, Severity 10

NB: the error does not appear if I dump and load only one DB, but I need
to store more DB in a single device (obviously if Icould).

What I do wrong?


Thanks in advance.


Download VCard vittorio.brugiatelli.vcf


Anthony Mandic <amandic Posted on 2001-03-12 22:56:28.0Z
Date: Tue, 13 Mar 2001 09:56:28 +1100
From: Anthony Mandic <amandic@*t.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Error loading DB with headeronly
References: <3AAD0D41.A5D8705F@wuerth-phoenix.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <hgLUZn0qAHA.274@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 25
NNTP-Posting-Host: 210.9.51.46
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:414
Article PK: 1060932


Vittorio Brugiatelli wrote:

> I want to make some test with the dump & Load command (Sybase ASE
> v.11.9.2 on Linux server) on a HP DAT (DDS4 40Gb)
>
> I dump two Databases with following command:
>
> dump database db1 to tapedump3 with init
> dump database db2 to tapedump3 with unload
>
> It seems to work.
> Before loading them, I want to know what is stored in the DAT, so I
> typed:
>
> load database db1 from tapedump3 with headeronly
> load database db2 from tapedump3 with headeronly
>
> These are the messages I obtained:
...
> Server 'phxlinux_back', Procedure 'as_control', Line 0:
> Backup Server: 6.32.2.3: /dev/st0: volume not valid or not requested

For multiple dumps you would want to use the non-rewinding device,
/dev/nst, rather than the auto-rewinding device, /dev/st. In the
above, your second dump overwrote the header and the first dump.
Its also a good idea to use a file name with the dump.

-am © 2001


Vittorio Brugiatelli Posted on 2001-03-13 08:12:21.0Z
Message-ID: <3AADD665.A64F0EB5@wuerth-phoenix.com>
Date: Tue, 13 Mar 2001 09:12:21 +0100
From: Vittorio Brugiatelli <vittorio.brugiatelli@wuerth-phoenix.com>
X-Mailer: Mozilla 4.6 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Error loading DB with headeronly
References: <3AAD0D41.A5D8705F@wuerth-phoenix.com> <hgLUZn0qAHA.274@forums.sybase.com>
Content-Type: multipart/mixed; boundary="------------4A0CA80EB0E64F7B86A6672D"
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 82
NNTP-Posting-Host: 62.110.70.132
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:410
Article PK: 1060929


Anthony Mandic wrote:

>
> For multiple dumps you would want to use the non-rewinding device,
> /dev/nst, rather than the auto-rewinding device, /dev/st. In the
> above, your second dump overwrote the header and the first dump.
> Its also a good idea to use a file name with the dump.
>
> -am © 2001

I tried what you suggest:

sp_dropdevice tapedump3
sp_addumpdevice "tape", tapedump3, "/dev/nst0", 39000

dump database db1 to tapedump3 with init, file="Db1010313"
dump database db1 to tapedump3 with file="Db2010313"

Then I tried to read the header:

load database db1 from tapedump3 with headeronly
load database db2 from tapedump3 with headeronly


Server Message: Number 3216, Severity 10
Line 1:
Backup Server session id is: 81. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Server Message: Number 603102, Severity 2
Server 'phxlinux_back', Procedure 'bs_read_header', Line 0:
Backup Server: 6.31.2.1: Volume rejected.
Server Message: Number 603202, Severity 2
Server 'phxlinux_back', Procedure 'bs_read_header', Line 0:
Backup Server: 6.32.2.2: /dev/nst0: volume not valid or not requested (server:
, session id: 81.)
Server Message: Number 101402, Severity 2
Server 'phxlinux_back', Procedure 'bs_read_header', Line 0:
Backup Server: 1.14.2.3: Unrecoverable I/O or volume error. This DUMP or LOAD
session must exit.
Server Message: Number 603202, Severity 2
Server 'phxlinux_back', Procedure 'bs_read_header', Line 0:
Backup Server: 6.32.2.3: /dev/nst0: volume not valid or not requested (server:
, session id: 81.)
Server Message: Number 101402, Severity 2
Server 'phxlinux_back', Procedure 'bs_read_header', Line 0:
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or LOAD
session must exit.
Server Message: Number 604501, Severity 1
Server 'phxlinux_back', Procedure 'bs_read_header', Line 0:
Backup Server: 6.45.1.1: Be sure to remove the tape/floppy from drive
/dev/nst0 (server: , session id: 81).
Server Message: Number 8009, Severity 16
Line 1:
Error encountered by Backup Server. Please refer to Backup Server messages
for details.


At first sight, there are the same errors I received yesterday, when I used
/dev/st0: and like
yesterday, if I dump only one database instead of more, it works.
I agree with you that the second dump overwrites the header, but I dont't know
how (and why).

Thanks


Download VCard vittorio.brugiatelli.vcf


Anthony Mandic <amandic Posted on 2001-03-14 11:40:19.0Z
Date: Wed, 14 Mar 2001 21:40:19 +1000
From: Anthony Mandic <amandic@*t.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Error loading DB with headeronly
References: <3AAD0D41.A5D8705F@wuerth-phoenix.com> <hgLUZn0qAHA.274@forums.sybase.com> <3AADD665.A64F0EB5@wuerth-phoenix.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <s91jS7HrAHA.258@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 28
NNTP-Posting-Host: CPE-208-111-111-203.syd.dav.net.au 203.111.111.208
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:403
Article PK: 1060921


Vittorio Brugiatelli wrote:

> I tried what you suggest:
>
> sp_dropdevice tapedump3
> sp_addumpdevice "tape", tapedump3, "/dev/nst0", 39000
>
> dump database db1 to tapedump3 with init, file="Db1010313"
> dump database db1 to tapedump3 with file="Db2010313"

Were there any error messages after these dumps?

> Then I tried to read the header:
>
> load database db1 from tapedump3 with headeronly
> load database db2 from tapedump3 with headeronly

Was the tape rewound first? Remember, its now a non-rewinding
device. It won't rewind unless instructed too.

> At first sight, there are the same errors I received yesterday, when I used
> /dev/st0: and like
> yesterday, if I dump only one database instead of more, it works.
> I agree with you that the second dump overwrites the header, but I dont't know
> how (and why).

Hmmm ... I'll look into this tomorrow. If Linux has an
mt command you can scan the tape and see how many files
are on it. Alternately, you could try writing files on
the tape and see if you can read them back.

-am © 2001