| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
|
 |
01-13-04, 14:31
|
|
Registered User
|
|
Join Date: Jan 2004
Posts: 2
|
|
|
LOAD DATABASE problem
|
|
When I write
load database DB from "c:\qwe.dmp"
and 'DB' database already exists
I got the following messages:
Server Message: Number 3216, Severity 10
Line 1:
Backup Server session id is: 107. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Server Message: Number 606602, Severity 2
Server 'MTL_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.66.2.1: Volume validation error: illegal volume change, device c:\qwe.dmp: volume mounted out of order, expected volume 0001, got volume 16777216.
Server Message: Number 603602, Severity 2
Server 'MTL_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.36.2.4: Header labels of rejected volume:
Server Message: Number 603402, Severity 2
Server 'MTL_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.34.2.4: VOL1 6 HDR1hm4test033460F351 HDR2F
Server Message: Number 101402, Severity 2
Server 'MTL_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
Server Message: Number 603202, Severity 2
Server 'MTL_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.32.2.3: c:\qwe.dmp: volume not valid or not requested (server: , session id: 107.)
Server Message: Number 101402, Severity 2
Server 'MTL_BS', 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 8009, Severity 16
Line 1:
Error encountered by Backup Server. Please refer to Backup Server messages for details.
Please help if you have any ideas.
Thanks!
|
|
01-13-04, 19:16
|
|
Registered User
|
|
Join Date: Feb 2002
Location: Willy is on vacation
Posts: 1,208
|
|
Didi you use stripes when you dumped this database. You have load using the stripe syntax in the same order that you dumped.
|
|
01-14-04, 04:02
|
|
Registered User
|
|
Join Date: Jan 2004
Posts: 5
|
|
|
|
Quote:
Originally posted by willy_and_the_ci
Didi you use stripes when you dumped this database. You have load using the stripe syntax in the same order that you dumped.
|
Hi
I've same problem.
What can I do, if i don't know stripe syntax?
|
|
01-14-04, 04:33
|
|
Registered User
|
|
Join Date: Nov 2002
Location: Switzerland
Posts: 523
|
|
Quote:
Originally posted by Abbat
What can I do, if i don't know stripe syntax?
|
Check the Backup log.
|
|
01-14-04, 04:58
|
|
Registered User
|
|
Join Date: Jan 2004
Posts: 5
|
|
Quote:
Originally posted by fadace
Check the Backup log.
|
I've only one file(.dmp)
Where I can see Backup log?
|
|
01-14-04, 08:15
|
|
Registered User
|
|
Join Date: Sep 2003
Location: Switzerland
Posts: 443
|
|
The backup log will be in $SYBASE/$SYBASE_ASE/install
Was this backup taken in the same server? Do you know when this backup was taken?
If so, you can look at the backup log and get the details on how this backup was taken.
|
|
01-14-04, 09:15
|
|
Registered User
|
|
Join Date: Jan 2004
Location: Munich/Germany
Posts: 12
|
|
|
Re: LOAD DATABASE problem
This database has been dumped with multiple stripes and you are missing them somewhere,
Dump the source database again, and load the target with the same amount ot stripes or no stripes at all, depending on how big your db is etc
syntax
dump database dbname to '/dir/dbname.dmp1'
[stripe on '/dir/dbname.dmp2']
[stripe on '/dir/dbname.dmp3']
......... etc
load database dbname from '/dir/dbname.dmp1'
[stripe on '/dir/dbname.dmp2']
[stripe on '/dir/dbname.dmp3']
.......... etc
Quote:
Originally posted by ilyab
When I write
load database DB from "c:\qwe.dmp"
and 'DB' database already exists
I got the following messages:
Server Message: Number 3216, Severity 10
Line 1:
Backup Server session id is: 107. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Server Message: Number 606602, Severity 2
Server 'MTL_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.66.2.1: Volume validation error: illegal volume change, device c:\qwe.dmp: volume mounted out of order, expected volume 0001, got volume 16777216.
Server Message: Number 603602, Severity 2
Server 'MTL_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.36.2.4: Header labels of rejected volume:
Server Message: Number 603402, Severity 2
Server 'MTL_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.34.2.4: VOL1 6 HDR1hm4test033460F351 HDR2F
Server Message: Number 101402, Severity 2
Server 'MTL_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
Server Message: Number 603202, Severity 2
Server 'MTL_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.32.2.3: c:\qwe.dmp: volume not valid or not requested (server: , session id: 107.)
Server Message: Number 101402, Severity 2
Server 'MTL_BS', 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 8009, Severity 16
Line 1:
Error encountered by Backup Server. Please refer to Backup Server messages for details.
Please help if you have any ideas.
Thanks!
|
|
|
11-28-10, 04:00
|
|
Registered User
|
|
Join Date: Nov 2010
Posts: 2
|
|
|
sam
I have facing the following problem while i am loading the dump file. Please help me
OS - windows 2003 server and sybase 11.9.2
Server Message: Number 3216, Severity 10
Line 1:
Backup Server session id is: 21. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Server Message: Number 603202, Severity 2
Server 'RAKOLD_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.32.2.1: d:\rakco.dmp: volume not valid or not requested (server: , session id: 21.)
Server Message: Number 603602, Severity 2
Server 'RAKOLD_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.36.2.1: Header labels of rejected volume:
Server Message: Number 603402, Severity 2
Server 'RAKOLD_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.34.2.1: VOL1 0 7 HDR1rakco1027809E90 HDR2F
Server Message: Number 101402, Severity 2
Server 'RAKOLD_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
Server Message: Number 603202, Severity 2
Server 'RAKOLD_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.32.2.3: d:\rakco.dmp: volume not valid or not requested (server: , session id: 21.)
Server Message: Number 101402, Severity 2
Server 'RAKOLD_BS', 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 8009, Severity 16
Line 1:
Error encountered by Backup Server. Please refer to Backup Server messages for details.
Server Message: Number 3444, Severity 10
Please help if you have any ideas.
Thanks![/QUOTE]
|
Last edited by samuae; 11-28-10 at 04:15.
|
11-28-10, 04:17
|
|
Registered User
|
|
Join Date: Nov 2010
Posts: 2
|
|
|
Dump Loading Problem
have facing the following problem while i am loading the dump file. Please help me
OS - windows 2003 server and sybase 11.9.2
Server Message: Number 3216, Severity 10
Line 1:
Backup Server session id is: 21. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Server Message: Number 603202, Severity 2
Server 'RAKOLD_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.32.2.1: d:\rakco.dmp: volume not valid or not requested (server: , session id: 21.)
Server Message: Number 603602, Severity 2
Server 'RAKOLD_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.36.2.1: Header labels of rejected volume:
Server Message: Number 603402, Severity 2
Server 'RAKOLD_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.34.2.1: VOL1 0 7 HDR1rakco1027809E90 HDR2F
Server Message: Number 101402, Severity 2
Server 'RAKOLD_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
Server Message: Number 603202, Severity 2
Server 'RAKOLD_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.32.2.3: d:\rakco.dmp: volume not valid or not requested (server: , session id: 21.)
Server Message: Number 101402, Severity 2
Server 'RAKOLD_BS', 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 8009, Severity 16
Line 1:
Error encountered by Backup Server. Please refer to Backup Server messages for details.
Server Message: Number 3444, Severity 10
Please help if you have any ideas.
Thanks![/QUOTE][/QUOTE]
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
LOAD DATABASE problem
