远程备份出错（已解决备份问题，不过发现速度相当慢，待解决写入速度问题）

donniejeck

环境：一台12.0,一台12.53
现做远程备份要把12.0的库备份到12.53里，配置都没问题，执行备份时出错如下:
1> dump database WDZX to "e:\wdzx.dmp" at back_BS
2> go
Backup Server session id is:  13.  Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 5.16.2.2: Client-Library error: Error number 40, Layer 4, Origin
1, Severity 5: ct_results(): protocol specific layer: external error: There is a

tds protocol error. An invalid column status was received..
Backup Server: 5.32.2.1: Internal System Error: Client-Library call 'ct_results'

failed with return code '0' for 'bs_poll_capabilities' RPC.
Msg 8009, Level 16, State 1:
Line 1:
Error encountered by Backup Server.  Please refer to Backup Server messages for
details.

[ 本帖最后由 donniejeck 于 2006-11-21 11:17 编辑 ]

Blackrose

感觉是不同版本的ASE间做远程备份的问题.....没有做过这样的测试......

有没有可能把两边的数据库版本弄成一样再试试？

donniejeck

呵呵~~~我也觉得会不会是因为版本之间的关系.晚上又安装了一台测试出错如下:

1> dump database WDZX to "e:\wdzx.dmp" at back_bs
2> go
Backup Server session id is:  5.  Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 3.27.2.1: Invalid RPC sequence at RPC as_cmd.
Backup Server: 5.7.2.7: RPC ('as_cmd') execution failed.
Msg 8009, Level 16, State 1:
Server 'cq', Line 1:
Error encountered by Backup Server.  Please refer to Backup Server messages for
details.
1> select @@version
2> go




-------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
----------------
Adaptive Server Enterprise/12.5.3/EBF 13331 ESD#7/P/NT (IX86)/OS 4.0/ase1253/19

         51/32-bit/OPT/Fri Mar 24 02:17:56 2006

donniejeck

1> sp_helpserver
2> go
name                           network_name
         class
         status



         id    cost
------------------------------ --------------------------------
         ---------------
         -----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------
         ----- -----
CQ_XP                          CQ_XP
         RPCServer
         timeouts, no net password encryption, writable , rpc security model A



         3     1000
SYB_BACKUP                     cq_BS
         ASEnterprise
         timeouts, no net password encryption, writable , rpc security model A



         1     NULL
SYB_EJB                        EJBServer
         ASEJB
         external engine auto start



         2     NULL
back_bs                        back_bs
         ASEnterprise
         timeouts, no net password encryption, writable , rpc security model A



         5     1000
cq                             cq
         local




         0     0
loopback                       cq
         ASEnterprise
         timeouts, no net password encryption, writable , rpc security model A



         4     1000

donniejeck

1> sp_helpserver
2> go
name                           network_name
         class
         status



         id    cost
------------------------------ --------------------------------
         ---------------
         ----------------------------------------------------------------------
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
------------------------
         ----- -----
CQ_XP                          CQ_XP
         RPCServer
         timeouts, no net password encryption, writable , rpc security model A



         3     1000
SYB_BACKUP                     cq_BS
         ASEnterprise
         timeouts, no net password encryption, writable , rpc security model A



         1     NULL
SYB_EJB                        EJBServer
         ASEJB
         external engine auto start



         2     NULL
back_bs                        back_bs
         ASEnterprise
         timeouts, no net password encryption, writable , rpc security model A



         5     1000
cq                             cq
         local




         0     0
loopback                       cq
         ASEnterprise
         timeouts, no net password encryption, writable , rpc security model A

donniejeck

远程备份日志

Nov 19 17:28:07 2006: Backup Server/12.5.2/EBF 11798/P/NT (IX86)/OS 4.0/ase1252/2266/32-bit/OPT/Fri Mar 26 19:36:19 2004
Nov 19 17:28:07 2006: Confidential property of Sybase, Inc.
Copyright 1987, 2004
Sybase, Inc.  All rights reserved.
Unpublished rights reserved under U.S. copyright laws.

This software contains confidential and trade secret information of Sybase,
Inc.   Use,  duplication or disclosure of the software and documentation by
the  U.S.  Government  is  subject  to  restrictions set forth in a license
agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
agreement  specifying  the  Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
Logging Backup Server messages in file 'e:\back\back_BS.log'

Nov 19 17:28:07 2006: Backup Server: 1.70.1.1: Configuring the maximum shared memory usage to 48 MB.
Nov 19 17:28:07 2006: Backup Server: 1.69.1.2: Configuring the number of service threads to 48.
Nov 19 17:28:07 2006: Backup Server: 1.70.1.3: Configuring the shared memory per stripe to 1048576 bytes.
Nov 19 18:18:45 2006: Backup Server/12.5.3/EBF 13331 ESD#7/P/NT (IX86)/OS 4.0/ase1253/2344/32-bit/OPT/Thu Mar 23 21:42:16 2006
Nov 19 18:18:45 2006: Confidential property of Sybase, Inc.
Copyright 1987, 2006
Sybase, Inc.  All rights reserved.
Unpublished rights reserved under U.S. copyright laws.

This software contains confidential and trade secret information of Sybase,
Inc.   Use,  duplication or disclosure of the software and documentation by
the  U.S.  Government  is  subject  to  restrictions set forth in a license
agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
agreement  specifying  the  Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
Logging Backup Server messages in file 'e:\back\back_BS.log'

Nov 19 18:18:45 2006: Backup Server: 1.70.1.1: Configuring the maximum shared memory usage to 48 MB.
Nov 19 18:18:45 2006: Backup Server: 1.69.1.2: Configuring the number of service threads to 48.
Nov 19 18:18:45 2006: Backup Server: 1.70.1.3: Configuring the shared memory per stripe to 1048576 bytes.
Nov 19 18:20:17 2006: Backup Server: 1.52.1.1: Backup Server terminating because of system shutdown
Nov 19 18:20:17 2006: Backup Server: 3.48.1.1: The Backup Server will go down immediately.  Terminating sessions.
Nov 19 18:22:32 2006: Backup Server/12.5.3/EBF 13331 ESD#7/P/NT (IX86)/OS 4.0/ase1253/2344/32-bit/OPT/Thu Mar 23 21:42:16 2006
Nov 19 18:22:32 2006: Confidential property of Sybase, Inc.
Copyright 1987, 2006
Sybase, Inc.  All rights reserved.
Unpublished rights reserved under U.S. copyright laws.

This software contains confidential and trade secret information of Sybase,
Inc.   Use,  duplication or disclosure of the software and documentation by
the  U.S.  Government  is  subject  to  restrictions set forth in a license
agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
agreement  specifying  the  Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
Logging Backup Server messages in file 'e:\back\back_BS.log'

Nov 19 18:22:32 2006: Backup Server: 1.70.1.1: Configuring the maximum shared memory usage to 48 MB.
Nov 19 18:22:32 2006: Backup Server: 1.69.1.2: Configuring the number of service threads to 48.
Nov 19 18:22:32 2006: Backup Server: 1.70.1.3: Configuring the shared memory per stripe to 1048576 bytes.
Nov 19 19:21:43 2006: Backup Server: 1.52.1.1: Backup Server terminating because of system shutdown
Nov 19 19:21:43 2006: Backup Server: 3.48.1.1: The Backup Server will go down immediately.  Terminating sessions.
Nov 19 19:23:58 2006: Backup Server/12.5.3/EBF 13331 ESD#7/P/NT (IX86)/OS 4.0/ase1253/2344/32-bit/OPT/Thu Mar 23 21:42:16 2006
Nov 19 19:23:58 2006: Confidential property of Sybase, Inc.
Copyright 1987, 2006
Sybase, Inc.  All rights reserved.
Unpublished rights reserved under U.S. copyright laws.

This software contains confidential and trade secret information of Sybase,
Inc.   Use,  duplication or disclosure of the software and documentation by
the  U.S.  Government  is  subject  to  restrictions set forth in a license
agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
agreement  specifying  the  Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
Logging Backup Server messages in file 'e:\back\back_BS.log'

Nov 19 19:23:58 2006: Backup Server: 1.70.1.1: Configuring the maximum shared memory usage to 48 MB.
Nov 19 19:23:58 2006: Backup Server: 1.69.1.2: Configuring the number of service threads to 48.
Nov 19 19:23:58 2006: Backup Server: 1.70.1.3: Configuring the shared memory per stripe to 1048576 bytes.
Nov 20 04:51:37 2006: CS-Library Error: 46.1.0
                cs_locale: cslib user api layer: external error: Can not access localization file e:\sybase\locales\message\chinese\common.loc.
Nov 20 04:51:37 2006: Open Server Error: 16323.10.0: Could not load localization information for character set <NULL> language chinese
.
Nov 20 04:51:37 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 04:51:37 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 04:51:37 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 04:51:37 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 05:53:05 2006: CS-Library Error: 46.1.0
                cs_locale: cslib user api layer: external error: Can not access localization file e:\sybase\locales\message\chinese\common.loc.
Nov 20 05:53:05 2006: Open Server Error: 16323.10.0: Could not load localization information for character set <NULL> language chinese
.
Nov 20 05:53:05 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 05:53:05 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 05:53:05 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 05:53:05 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 07:01:46 2006: Backup Server: 3.27.2.1: Invalid RPC sequence at RPC as_cmd.
Nov 20 07:01:46 2006: Backup Server: 5.7.2.7: RPC ('as_cmd') execution failed.
Nov 20 14:03:35 2006: CS-Library Error: 46.1.0
                cs_locale: cslib user api layer: external error: Can not access localization file e:\sybase\locales\message\chinese\common.loc.
Nov 20 14:03:35 2006: Open Server Error: 16323.10.0: Could not load localization information for character set <NULL> language chinese
.
Nov 20 14:03:35 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:03:35 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:03:35 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:03:35 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:03:44 2006: CS-Library Error: 46.1.0
                cs_locale: cslib user api layer: external error: Can not access localization file e:\sybase\locales\message\chinese\common.loc.
Nov 20 14:03:44 2006: Open Server Error: 16323.10.0: Could not load localization information for character set <NULL> language chinese
.
Nov 20 14:03:44 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:03:44 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:03:44 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:03:44 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:04:29 2006: CS-Library Error: 46.1.0
                cs_locale: cslib user api layer: external error: Can not access localization file e:\sybase\locales\message\chinese\common.loc.
Nov 20 14:04:29 2006: Open Server Error: 16323.10.0: Could not load localization information for character set <NULL> language chinese
.
Nov 20 14:04:29 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:04:29 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:04:29 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:04:29 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:05:45 2006: CS-Library Error: 46.1.0
                cs_locale: cslib user api layer: external error: Can not access localization file e:\sybase\locales\message\chinese\common.loc.
Nov 20 14:05:45 2006: Open Server Error: 16323.10.0: Could not load localization information for character set <NULL> language chinese
.
Nov 20 14:05:45 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:05:45 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:05:45 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:05:45 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:10:04 2006: CS-Library Error: 46.1.0
                cs_locale: cslib user api layer: external error: Can not access localization file e:\sybase\locales\message\chinese\common.loc.
Nov 20 14:10:04 2006: Open Server Error: 16323.10.0: Could not load localization information for character set <NULL> language chinese
.
Nov 20 14:10:04 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:10:04 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:10:04 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:10:04 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:10:53 2006: CS-Library Error: 46.1.0
                cs_locale: cslib user api layer: external error: Can not access localization file e:\sybase\locales\message\chinese\common.loc.
Nov 20 14:10:53 2006: Open Server Error: 16323.10.0: Could not load localization information for character set <NULL> language chinese
.
Nov 20 14:10:53 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:10:53 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:10:53 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:10:53 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:11:04 2006: CS-Library Error: 46.1.0
                cs_locale: cslib user api layer: external error: Can not access localization file e:\sybase\locales\message\chinese\common.loc.
Nov 20 14:11:04 2006: Open Server Error: 16323.10.0: Could not load localization information for character set <NULL> language chinese
.
Nov 20 14:11:04 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:11:04 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:11:04 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:11:04 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:26:44 2006: Backup Server: 1.52.1.1: Backup Server terminating because of system shutdown
Nov 20 14:26:44 2006: Backup Server: 3.48.1.1: The Backup Server will go down immediately.  Terminating sessions.
Nov 20 14:35:58 2006: Backup Server/12.5.3/EBF 13331 ESD#7/P/NT (IX86)/OS 4.0/ase1253/2344/32-bit/OPT/Thu Mar 23 21:42:16 2006
Nov 20 14:35:58 2006: Confidential property of Sybase, Inc.
Copyright 1987, 2006
Sybase, Inc.  All rights reserved.
Unpublished rights reserved under U.S. copyright laws.

This software contains confidential and trade secret information of Sybase,
Inc.   Use,  duplication or disclosure of the software and documentation by
the  U.S.  Government  is  subject  to  restrictions set forth in a license
agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
agreement  specifying  the  Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
Logging Backup Server messages in file 'e:\back\back_BS.log'

Nov 20 14:35:58 2006: Backup Server: 1.70.1.1: Configuring the maximum shared memory usage to 48 MB.
Nov 20 14:35:58 2006: Backup Server: 1.69.1.2: Configuring the number of service threads to 48.
Nov 20 14:35:58 2006: Backup Server: 1.70.1.3: Configuring the shared memory per stripe to 1048576 bytes.
Nov 20 14:37:49 2006: Backup Server: 3.1.2.1: Unrecognized RPC received--ignored.
Nov 20 14:44:31 2006: Backup Server: 1.52.1.1: Backup Server terminating because of system shutdown
Nov 20 14:44:31 2006: Backup Server: 3.48.1.1: The Backup Server will go down immediately.  Terminating sessions.
Nov 20 14:46:44 2006: Backup Server/12.5.3/EBF 13331 ESD#7/P/NT (IX86)/OS 4.0/ase1253/2344/32-bit/OPT/Thu Mar 23 21:42:16 2006
Nov 20 14:46:44 2006: Confidential property of Sybase, Inc.
Copyright 1987, 2006
Sybase, Inc.  All rights reserved.
Unpublished rights reserved under U.S. copyright laws.

This software contains confidential and trade secret information of Sybase,
Inc.   Use,  duplication or disclosure of the software and documentation by
the  U.S.  Government  is  subject  to  restrictions set forth in a license
agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
agreement  specifying  the  Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
Logging Backup Server messages in file 'e:\back\back_BS.log'

Nov 20 14:46:44 2006: Backup Server: 1.70.1.1: Configuring the maximum shared memory usage to 48 MB.
Nov 20 14:46:44 2006: Backup Server: 1.69.1.2: Configuring the number of service threads to 48.
Nov 20 14:46:44 2006: Backup Server: 1.70.1.3: Configuring the shared memory per stripe to 1048576 bytes.
Nov 20 14:47:09 2006: Backup Server: 3.27.2.1: Invalid RPC sequence at RPC as_cmd.
Nov 20 14:47:09 2006: Backup Server: 5.7.2.7: RPC ('as_cmd') execution failed.

Blackrose

大概看了看
cs_locale: cslib user api layer: external error: Can not access localization file e:\sybase\locales\message\chinese\common.loc.

你两边数据库服务器的字符集分别是？

1017of

version of remote backup server is supposed to be not lower than that of local backup server at least.

donniejeck

本地版本相关信息
1> select @@client_csname
2> go

------------------------------
cp850

(1 row affected)
1> sp_helpsort
2> go

Collation Name                 Collation ID
------------------------------ ------------
defaultml                                20
thaidict                                 21
iso14651                                 22
utf8bin                                  24
binary                                   25
altnoacc                                 39
altdict                                  45
altnocsp                                 46
scandict                                 47
scannocp                                 48
dict                                     51
nocase                                   52
nocasep                                  53
noaccent                                 54
espdict                                  55
espnocs                                  56
espnoac                                  57
rusnocs                                  59
cyrnocs                                  64
elldict                                  65
hundict                                  69
hunnoac                                  70
hunnocs                                  71
turknoac                                 73
turknocs                                 74

Loadable Sort Table Name       Collation ID
------------------------------ ------------
cp932bin                                129
dynix                                   130
gb2312bn                                137
cyrdict                                 140
turdict                                 155
euckscbn                                161
gbpinyin                                163
rusdict                                 165
sjisbin                                 179
eucjisbn                                192
big5bin                                 194

Sort Order Description

------------------------------------------------------------------
Character Set = 2, cp850
     Code Page 850 (Multilingual) character set.
Sort Order = 50, bin_cp850
     Binary ordering, for use with Code Page 850 (cp850).
Characters, in Order

------------------------------------------------------------------
     ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
   @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _
   ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ 
   

donniejeck

1> exec back_BS...sp_who
2> go
spid        status     loginame                       hostname     blk
         cmd
----------- ---------- ------------------------------ ------------ ---
         ----------------
           0 runnable   NULL                           NULL         0
         NULL
           2 runnable   NULL                           NULL         0
         CONNECT HANDLER
           3 sleeping   NULL                           NULL         0
         DEFERRED HANDLER
           8 sleeping   sa                             wzgd         0
         NULL
          14 runnable   NULL                           cq           0
         SITE HANDLER
          15 running    sa                             WZGD         0
         NULL

(6 rows affected)