Load on 12.5.3 64 Bit of a dump created by 12.5.1 32 Bit

[unknown]

Help in solving this problem. Many thanks !!

Raj
_____________________________________________________
The script is:
#!/usr/bin/ksh

#execute load procedure

$SYBASE/$SYBASE_OCS/bin/isql -Uoper -SPROD <<EOF >
/usr/sybase/scripts/dumprestore.out
password
use master
go
load database prod
from "compress::/usr/sybase/DBbackup/prod.dmp"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s1"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s2"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s3"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s4"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s5"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s6"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s7"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s8"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s9"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s10"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s11"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s12"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s13"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s14"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s15"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s16"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s17"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s18"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s19"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s20"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s21"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s22"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s23"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s24"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s25"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s26"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s27"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s28"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s29"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s30"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s31"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s32"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s33"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s34"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s35"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s36"

go
online database prod
go


EOF
_______________________________________________________
Error Obtained is:
Password:
Backup Server session id is: 12. Use this value when
executing the
'sp_volchanged' system stored procedure after fulfilling any
volume change
request from the Backup Server.
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp::00'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s1::01'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s2::02'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s3::03'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s4::04'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s5::05'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s6::06'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s7::07'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s8::08'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s9::09'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s10::10'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s11::11'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s12::12'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s13::13'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s14::14'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s15::15'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s16::16'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s17::17'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s18::18'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s19::19'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s20::20'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s21::21'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s22::22'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s23::23'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s24::24'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s25::25'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s26::26'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s27::27'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s28::28'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s29::29'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s30::30'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s31::31'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s32::32'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s33::33'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s34::34'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s35::35'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s36::36'
Backup Server: 4.177.2.1: The database page size of 8192
bytes obtained from ASE
is different from the database page size of 2048 bytes read
from the dump
header. The LOAD session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s4::04:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s32::32:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s3::03:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s28::28:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s26::26:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s23::23:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s21::21:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s2::02:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s17::17:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s16::16:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s14::14:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s10::10:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s11::11:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s12::12:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s13::13:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s15::15:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s18::18:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s19::19:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s30::30:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s31::31:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s33::33:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s34::34:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s5::05:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s35::35:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s8::08:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s36::36:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s6::06:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s7::07:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s29::29:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s25::25:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s27::27:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s24::24:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s20::20:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s22::22:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s1::01:
volume not valid or not requested (server: , session id:
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp::00: volume
not valid or not requested (server: , session id: 12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
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:
compress::/usr/sybase/DBbackup/prod.dmp.s9::09:
volume not valid or not requested (server: , session id:
12.)
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 'QF', Line 1:
Error encountered by Backup Server. Please refer to Backup
Server messages for
details.
Database 'prod' is now online.

[Mark A. Parsons]

1 - verify that the dataserver you dumped from, and the dataserver
you're loading into, are using the same page size; the error message
thinks the dump is coming from a dataserver with a page size of 2K,
while the dataserver into which you're trying to load the dump is
running with a 8K page size; you can't dump-n-load between dataservers
running different page sizes

2 - if you dumped your database with a compression level other than 1
you may want to verify the format of your stripe names; to be safe, you
want to use the same exact format/names as was used with the dump command

For example, assuming a compression level of 3 was used for the dumps,
your stripe names hve to include the compression level, like such:

... snip ...
stripe on "compress::3::/usr/sybase/DBbackup/prod.dmp.s1"
... snip ...

[Obviously if you used a different compression level then replace the
'3' with whatever compression level you used.]

Post by unknown
Help in solving this problem. Many thanks !!
Raj
_____________________________________________________
#!/usr/bin/ksh
#execute load procedure
$SYBASE/$SYBASE_OCS/bin/isql -Uoper -SPROD <<EOF >
/usr/sybase/scripts/dumprestore.out
password
use master
go
load database prod
from "compress::/usr/sybase/DBbackup/prod.dmp"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s1"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s2"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s3"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s4"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s5"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s6"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s7"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s8"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s9"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s10"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s11"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s12"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s13"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s14"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s15"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s16"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s17"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s18"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s19"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s20"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s21"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s22"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s23"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s24"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s25"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s26"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s27"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s28"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s29"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s30"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s31"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s32"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s33"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s34"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s35"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s36"
go
online database prod
go
EOF
_______________________________________________________
Backup Server session id is: 12. Use this value when
executing the
'sp_volchanged' system stored procedure after fulfilling any
volume change
request from the Backup Server.
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp::00'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s1::01'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s2::02'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s3::03'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s4::04'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s5::05'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s6::06'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s7::07'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s8::08'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s9::09'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s10::10'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s11::11'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s12::12'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s13::13'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s14::14'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s15::15'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s16::16'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s17::17'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s18::18'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s19::19'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s20::20'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s21::21'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s22::22'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s23::23'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s24::24'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s25::25'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s26::26'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s27::27'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s28::28'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s29::29'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s30::30'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s31::31'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s32::32'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s33::33'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s34::34'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s35::35'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s36::36'
Backup Server: 4.177.2.1: The database page size of 8192
bytes obtained from ASE
is different from the database page size of 2048 bytes read
from the dump
header. The LOAD session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
compress::/usr/sybase/DBbackup/prod.dmp::00: volume
not valid or not requested (server: , session id: 12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
This DUMP or LOAD
session must exit.
Error encountered by Backup Server. Please refer to Backup
Server messages for
details.
Database 'prod' is now online.

[unknown]

I recreated the database 12.5.3 64Bit with a page size of
2K.
Compression level is same as that for the dump. I am getting
an error for sort order and character set. I know they are
different and nedd to make the one on 12.5.2 64 bit tha same
as that for 12.5.1 32 Bit.

How do i go ahead with that ? Database is newly created and
empty.
______________________________________________________

Password:
Backup Server session id is: 60. Use this value when
executing the
'sp_volchanged' system stored procedure after fulfilling any
volume change
request from the Backup Server.
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp::00'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s1::01'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s2::02'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s3::03'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s4::04'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s5::05'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s6::06'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s7::07'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s8::08'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s9::09'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s10::10'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s11::11'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s12::12'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s13::13'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s14::14'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s15::15'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s16::16'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s17::17'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s18::18'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s19::19'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s20::20'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s21::21'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s22::22'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s23::23'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s24::24'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s25::25'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s26::26'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s27::27'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s28::28'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s29::29'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s30::30'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s31::31'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s32::32'
Backup Server: 4.132.1.1: Attempting to open byte stream
device:
'compress::/usr/sybase/DBbackup/prod.dmp.s33::33'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s24::24'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s23::23'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s29::29'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s25::25'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s27::27'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s33::33'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s30::30'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s28::28'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s26::26'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s32::32'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s31::31'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp::00'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s1::01'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s2::02'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s3::03'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s4::04'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s5::05'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s6::06'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s7::07'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s8::08'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s9::09'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s10::10'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s11::11'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s12::12'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s13::13'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s14::14'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s15::15'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s16::16'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s17::17'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s18::18'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s19::19'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s20::20'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s21::21'
Backup Server: 6.28.1.1: Dumpfile name 'qf_prod05334054C7'
section number 1
mounted on byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s22::22'
This is a database dump of database ID 4, name 'qf_prod',
from Nov 30 2005
6:01AM. SQL Server version: Adaptive Server
Enterprise/12.5.0.3/EBF 10972
ESD#1/P/Sun_svr4/OS 5.8/rel12503/1919/32-bit/FBO/Tue M.
Backup Server version:
Backup Server/12.5.0.3/EBF 10972 ESD#1/P/Sun_svr4/OS
5.8/rel125x/2253/32-bit/OPT/Mon Mar 3 19:58:5. Database
page size is 2048.
Database contains 79052800 pages; checkpoint RID=(Rid pageid
= 0x7e3263; row num
= 0x1d); next object ID=1641213047; sort order ID=45,
status=50; charset ID=2.
Database log version=6; database upgrade version=31.
The database you are attempting to LOAD was DUMPed under a
different sort order
ID (45) or character set ID (2) than the ones running on
this server (SortOrd =
50, CharSet = 1). If the sort orders differ, at least one of
them is
non-binary.
Database 'prod' is now online.

Post by Mark A. Parsons
1 - verify that the dataserver you dumped from, and the
dataserver you're loading into, are using the same page
size; the error message thinks the dump is coming from a
dataserver with a page size of 2K, while the dataserver
into which you're trying to load the dump is running with
a 8K page size; you can't dump-n-load between dataservers
running different page sizes
2 - if you dumped your database with a compression level
other than 1 you may want to verify the format of your
stripe names; to be safe, you want to use the same exact
format/names as was used with the dump command
For example, assuming a compression level of 3 was used
for the dumps, your stripe names hve to include the
... snip ...
stripe on "compress::3::/usr/sybase/DBbackup/prod.dmp.s1"
... snip ...
[Obviously if you used a different compression level then
replace the '3' with whatever compression level you
used.]

Post by unknown
Help in solving this problem. Many thanks !!
Raj
_____________________________________________________
#!/usr/bin/ksh
#execute load procedure
$SYBASE/$SYBASE_OCS/bin/isql -Uoper -SPROD <<EOF >
/usr/sybase/scripts/dumprestore.out
password
use master
go
load database prod
from "compress::/usr/sybase/DBbackup/prod.dmp"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s1"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s2"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s3"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s4"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s5"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s6"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s7"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s8"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s9"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s10"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s11"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s12"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s13"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s14"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s15"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s16"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s17"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s18"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s19"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s20"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s21"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s22"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s23"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s24"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s25"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s26"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s27"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s28"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s29"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s30"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s31"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s32"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s33"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s34"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s35"
stripe on "compress::/usr/sybase/DBbackup/prod.dmp.s36"
go
online database prod
go
EOF
_______________________________________________________
Backup Server session id is: 12. Use this value when
executing the
'sp_volchanged' system stored procedure after fulfilling
any volume change
request from the Backup Server.
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp::00'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s1::01'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s2::02'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s3::03'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s4::04'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s5::05'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s6::06'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s7::07'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s8::08'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s9::09'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s10::10'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s11::11'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s12::12'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s13::13'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s14::14'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s15::15'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s16::16'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s17::17'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s18::18'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s19::19'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s20::20'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s21::21'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s22::22'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s23::23'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s24::24'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s25::25'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s26::26'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s27::27'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s28::28'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s29::29'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s30::30'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s31::31'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s32::32'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s33::33'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s34::34'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s35::35'
Backup Server: 4.132.1.1: Attempting to open byte stream
'compress::/usr/sybase/DBbackup/prod.dmp.s36::36'
Backup Server: 4.177.2.1: The database page size of 8192
bytes obtained from ASE
is different from the database page size of 2048 bytes
read from the dump
header. The LOAD session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
compress::/usr/sybase/DBbackup/prod.dmp::00: volume
not valid or not requested (server: , session id: 12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume
error. This DUMP or LOAD
session must exit.
Error encountered by Backup Server. Please refer to
Backup Server messages for
details.
Database 'prod' is now online.

[Michael Peppler]

I recreated the database 12.5.3 64Bit with a page size of 2K.
Compression level is same as that for the dump. I am getting an error for
sort order and character set. I know they are different and nedd to make
the one on 12.5.2 64 bit tha same as that for 12.5.1 32 Bit.
How do i go ahead with that ? Database is newly created and empty.

See the sqlloc utility.

Michael