请教大家个关于load的问题 请指教。。

yls9310

我在load一个库的时候 报这个错误 请问是为啥呢？

Server Message:  Number  3216, Severity  10
Server 'DSFY600', Line 1:
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.
Server Message:  Number  602801, Severity  1
Server 'SYB_BACKUP', Procedure 'bs_read_header', Line 0:
Backup Server: 6.28.1.1: Dumpfile name 'K_ZS1132614A39   ' section number 1 mounted on disk file 'c:\K_ZS.dat'
Server Message:  Number  3105, Severity  16
Server 'DSFY600', Line 1:
Data on dump will not fit into current database. Need 7250 Mbyte database.

Eisen

说你要load的库大小不够，应该要7250M大小。

yls9310

回复 2# Eisen


    谢谢 是还需要7250M是吗？

Eisen

是你建这个要load的库的总大小。

yls9310

回复 4# Eisen


    那我应该扩在哪个段上呢 default 还是 logsegment ？

Eisen

这个你要具体看你那个备份的情况了
你先load database .... from .... with headeronly看看情况然后根据你这样查到的segmap来创建db

yls9310

回复 6# Eisen


   

我执行了load database K_ZS from "c:\K_ZS.dat" with headeronly

报以下信息，何解啊？

Server Message:  Number  3216, Severity  10
Server 'DSFY600', Line 1:
Backup Server session id is:  16.  Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Server Message:  Number  602801, Severity  1
Server 'SYB_BACKUP', Procedure 'bs_read_header', Line 0:
Backup Server: 6.28.1.1: Dumpfile name 'K_ZS1132614A39   ' section number 1 mounted on disk file 'c:\K_ZS.dat'
Server Message:  Number  3124, Severity  10
Server 'DSFY600', Line 1:
This is a database dump of database ID 8, name 'K_ZS', from Nov 22 2011 11:28PM. SQL Server version: Adaptive Server Enterprise/12.5.3/EBF 13327 ESD#7/P/RS6000/AIX 5.1/ase1253/1951/64-bit/FBO/Fri Mar 2. Backup Server version: Backup Server/12.5.3/EBF 13326 ESD#7/P/RS6000/AIX 4.3.3/ase1253/2344/32-bit/OPT/Thu Mar 23 21:34:06. Database page size is 4096.
Server Message:  Number  3125, Severity  10
Server 'DSFY600', Line 1:
Database contains 1856000 pages; checkpoint RID=(Rid pageid = 0x2cff4; row num = 0x1; next object ID=1767674314; sort order ID=50, status=0; charset ID=2.
Server Message:  Number  3136, Severity  10
Server 'DSFY600', Line 1:
Database log version=6; database upgrade version=31.

Eisen

哦。你是12.5.3的，里面没有segmap信息。
那就只能先按这个设置来创建一个db然后load进去之后再查它的segmap了.

总的说来，就是告诉你，这个备份是在ase12.5.3 ESD#7上生成的，这个db的pagesize 是4K，总大小是7250M。

junmeiguo

如果你当时dump的数据库服务还能启动，可以连进去查看一下 K_XX的段分布情况

use K_XX
go
sp_helpdb K_XX

根据时间可以判断出段大小和顺序