网站 › 『 Sybase ASE 』 › load数据出现问题，求助，在线等.......

xmm1981 发表于 2005-11-12 12:19:12

load数据出现问题，求助，在线等.......

<P>load database fydb from 'h:\fydbback\back1.dmp'<BR>stripe on 'h:\fydbback\back2.dmp'<BR>stripe on 'h:\fydbback\back3.dmp'<BR>stripe on 'h:\fydbback\back4.dmp'<BR>stripe on 'h:\fydbback\back5.dmp'<BR>stripe on 'h:\fydbback\back6.dmp'<BR>stripe on 'h:\fydbback\back7.dmp'<BR>stripe on 'h:\fydbback\back8.dmp'<BR>stripe on 'h:\fydbback\back9.dmp'<BR>stripe on 'h:\fydbback\back10.dmp'<BR>go</P>
<P>.<BR>.<BR>Backup Server: 4.58.1.1: Database fydb: 18781142 kilobytes LOADed.<BR>Backup Server: 3.42.1.1: LOAD is complete (database fydb).</P>
<P>Caution:You have set up this database to include space on disk 6 for both data<BR>and the transaction log.This can make recovery impossible if that disk fails.<BR>Caution:You have set up this database to include space on disk 19 for both<BR>data and the transaction log.This can make recovery impossible if that disk<BR>fails.</P>
<P>此二句翻译如下:<BR>小心: 你设定这个数据库包括空间在盘6 为数据和交易日 志。这可能使补救不可能如果那张盘失败。<BR>小心: 你设定这个数据 库包括空间在盘19 为数据和交易日志。这可能使补救不可能如果那 张盘失败。<BR></P>
<P>导入数据以后,出现此问题，不能online数据库....</P>
<P>请问这个问题怎么解决？</P>

ehxz 发表于 2005-11-12 15:39:20

<P>搞不清楚，你用的是10个备份出来的文件，提示为什么却是6跟19？</P>
<P>这种备份方式没用过。不过估计你的库很大了吧。</P>

xmm1981 发表于 2005-11-12 15:58:29

是啊，呜........

ehxz 发表于 2005-11-12 17:01:28

<P>你原来是如何备份的,如果不是你自己备的,是不是文件有问题啊?</P>

flybean 发表于 2005-11-13 00:29:04

日志和数据应分布在不同的设备上，但你的数据和日志在同一设备上。可调整，即将日志移到其它设备上。<br>
<br>
有两种方法：<br>
方法一：使用SYBASE　Central，建议初学者使用<br>
方法二：<br>


<oltype="1">
<li value="1" >Backup
   the database.</li><li value="2" >Sp_dropsegment
   log_segname, dbname, </li><li value="3" >Sp_logdevice
   dbname, devname</li>
</ol>

<br>

[此贴子已经被作者于2005-11-13 0:34:06编辑过]

xmm1981 发表于 2005-11-14 10:01:19

<P>能否具体点，谢谢....load后出错提示，和online之后的出错提示</P>
<P 0cm 0cm 0pt; LAYOUT-GRID-MODE: char; mso-layout-grid-align: none">.<o:p></o:p></P>
<P 0cm 0cm 0pt; LAYOUT-GRID-MODE: char; mso-layout-grid-align: none">Backup Server: 4.58.1.1: Database fydb: 18781142 kilobytes LOADed.<o:p></o:p></P>
<P 0cm 0cm 0pt; LAYOUT-GRID-MODE: char; mso-layout-grid-align: none">Backup Server: 3.42.1.1: LOAD is complete (database fydb).<o:p></o:p></P>
<P 0cm 0cm 0pt; LAYOUT-GRID-MODE: char; mso-layout-grid-align: none">Caution:You have set up this database to include space on disk 6 for both data<o:p></o:p></P>
<P 0cm 0cm 0pt; LAYOUT-GRID-MODE: char; mso-layout-grid-align: none"> <o:p></o:p></P>
<P 0cm 0cm 0pt; LAYOUT-GRID-MODE: char; mso-layout-grid-align: none">and the transaction log.This can make recovery impossible if that disk fails.<o:p></o:p></P>
<P 0cm 0cm 0pt; LAYOUT-GRID-MODE: char; mso-layout-grid-align: none">Caution:You have set up this database to include space on disk 19 for both<o:p></o:p></P>
<P 0cm 0cm 0pt; LAYOUT-GRID-MODE: char; mso-layout-grid-align: none">data and the transaction log.This can make recovery impossible if that disk fails.</P>
<P 0cm 0cm 0pt; LAYOUT-GRID-MODE: char; mso-layout-grid-align: none"> </P>
<P 0cm 0cm 0pt; LAYOUT-GRID-MODE: char; mso-layout-grid-align: none">1&gt; online database fydb<o:p></o:p></P>
<P 0cm 0cm 0pt; LAYOUT-GRID-MODE: char; mso-layout-grid-align: none">2&gt; go<o:p></o:p></P>
<P 0cm 0cm 0pt; LAYOUT-GRID-MODE: char; mso-layout-grid-align: none">Msg 930, Level 14, State 1:<o:p></o:p></P>
<P 0cm 0cm 0pt; LAYOUT-GRID-MODE: char; mso-layout-grid-align: none">Line 1:<o:p></o:p></P>
<P 0cm 0cm 0pt; LAYOUT-GRID-MODE: char; mso-layout-grid-align: none">Database 'fydb' cannot be opened because either an earlier system termination<o:p></o:p></P>
<P 0cm 0cm 0pt; LAYOUT-GRID-MODE: char; mso-layout-grid-align: none">left LOAD DATABASE incomplete or the database is created with 'for load' option.<o:p></o:p></P>
<P 0cm 0cm 0pt; LAYOUT-GRID-MODE: char; mso-layout-grid-align: none"> <o:p></o:p></P>
<P 0cm 0cm 0pt; LAYOUT-GRID-MODE: char; mso-layout-grid-align: none">Load the database or contact a user with System Administrator (SA) role.<o:p></o:p></P>
<P>1&gt;</P>

flybean 发表于 2005-11-14 11:21:40

ONLINE没成功的原因是：load database没有完成<br>
<br>

xmm1981 发表于 2005-11-14 11:42:40

<P none? mso-layout-grid-align: char; LAYOUT-GRID-MODE: 0pt; 0cm>Backup Server: 4.58.1.1: Database fydb: 18781142 kilobytes LOADed.<O:P></O:P></P><BR>
<P none? mso-layout-grid-align: char; LAYOUT-GRID-MODE: 0pt; 0cm>Backup Server: 3.42.1.1: LOAD is complete (database fydb).</P>
<P none? mso-layout-grid-align: char; LAYOUT-GRID-MODE: 0pt; 0cm> </P>
<P none? mso-layout-grid-align: char; LAYOUT-GRID-MODE: 0pt; 0cm>你没有看吗？已经complete了</P>
<P none? mso-layout-grid-align: char; LAYOUT-GRID-MODE: 0pt; 0cm> </P>

查看完整版本: load数据出现问题，求助，在线等.......