Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

loading the database ( linux)

34 views
Skip to first unread message

sanjeev

unread,
Jan 28, 2004, 3:09:31 PM1/28/04
to
Hi all,
I am in ASE 12.5.1 on Linux environment.
We are haveing production on Solaris.
I dump the data from production and trying to load in Linux
I am getting following error
load database prodmaint
2> from "/opt/sybase/prodmntdb01"
3> go
Backup Server session id is: 14. Use this value when
executing the
'sp_volchanged' system stored procedure after fulfilling any
volume change
request from the Backup Server.
Backup Server: 6.66.2.1: Volume validation error: illegal
volume change, device
/opt/sybase/prodmntdb01: volume mounted out of order,
expected volume 0001, got
volume 16777216.
Backup Server: 6.36.2.4: Header labels of rejected volume:
Backup Server: 6.34.2.4:
VOL1
6
HDR1odmaint040270E8C7
HDR2F
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 6.32.2.3: /opt/sybase/prodmntdb01: volume not
valid or not
requested (server: , session id: 14.)
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 'FRONTIER', Line 1:
Error encountered by Backup Server. Please refer to Backup
Server messages for
details.
1> Open Server Error: 16144.10.0: Server process '14' is not
allocated in 'srv_event'

Thanks

Sanjeev

Bret Halford

unread,
Jan 28, 2004, 4:21:26 PM1/28/04
to
Dumping and loading between platforms (here you are trying to go from
Solaris to Linux) isn't supported. There are cases where it may work
despite not being supported, but it requires the two platforms to
be the same endian bit order. Solaris Sparc is big-endian while
Linux x86 is little-endian, so it for sure doesn't work. (Might
work on Solaris x86 to Linux x86 but again, would not be supported).

This is documented under the "LOAD DATABASE" command in the
Reference Manual: "You cannot load a dump that was made on a
different platform."


-bret

sanjeev

unread,
Jan 29, 2004, 6:21:03 PM1/29/04
to
Thanks
0 new messages