songst 发表于 2007-9-4 11:01:32

[原创]求助复制服务器不同步问题

<font color="#444444"><font face="宋体"><font size="2">9月1日由于饮用存储过程中存在死循环,</font><span style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Simsun; mso-hansi-font-family: Simsun;"><font size="2">临时重启了主机<span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: Simsun; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">SYBASE</span><span style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Simsun; mso-hansi-font-family: Simsun;">,发现数据不同步,而且host库由800M增加到1.5G</span></font></span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: Simsun; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">SYBASE</span><span style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Simsun; mso-hansi-font-family: Simsun;">,发现数据不同步,而且host库由800M增加到1.5G</span></font></font><font size="2"><span style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Simsun; mso-hansi-font-family: Simsun;">,</span></font><div><font size="2"><span style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Simsun; mso-hansi-font-family: Simsun;">我重新将主机与备份机都重启</span><span style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Simsun; mso-hansi-font-family: Simsun;">还是没有同步,</span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: Simsun; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">GJSC_BK </span><span style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Simsun; mso-hansi-font-family: Simsun;">启动</span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: Simsun; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">SYBASE</span><span style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Simsun; mso-hansi-font-family: Simsun;">时最后提示信息是</span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: Simsun; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">:</span></font></div><div><font size="2"><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: Simsun; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">RepAgent(4):the secondare truncation point is not valid.<br/><br/>please make sure that secondary truncation point is valid.,and then restart the repagent ...<br/></span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: Simsun; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;"><br/>谢谢!</span></font></div>

hefan 发表于 2007-9-13 00:07:35

<p>你没有说清除你的环境。</p><p>错误信息说的是你的数据库没有启用复制截断点。</p><p>use DB</p><p>go</p><p>dbcc settrunc('ltm',valid)</p><p>go</p><p>sp_start_rep_agent DB</p><p>go</p><p>试一试,如果不行,估计要重新建立一次连接。</p>
页: [1]
查看完整版本: [原创]求助复制服务器不同步问题

免责声明:
本站所发布的一切破解补丁、注册机和注册信息及软件的解密分析文章仅限用于学习和研究目的;不得将上述内容用于商业或者非法用途,否则,一切后果请用户自负。本站信息来自网络,版权争议与本站无关。您必须在下载后的24个小时之内,从您的电脑中彻底删除上述内容。如果您喜欢该程序,请支持正版软件,购买注册,得到更好的正版服务。如有侵权请邮件与我们联系处理。

Mail To:Admin@SybaseBbs.com