The database page size of 4096 bytes obtained from ASE is different from the database page size of 2
来源:互联网 发布:霍先生的安之知百度云 编辑:程序博客网 时间:2024/05/16 18:21
1. 问题
create database msgdb
load database msgdb from "compress::/usr/u/nweng/msgdb.cmp"
报错:
Backup Server: 4.177.2.1: The database page size of 4096 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.
2. 解决办法
需要重新安装ASE,配置page size 为2048
卸载
$SYBASE/sybuninstall/ASESuite/uninstallrm -rf /users/weng/ase
重装
3. 原因
查看 select @@maxpagesize
当前恢复server 和备份文件的server 设置的page size 不一样。 当前恢复是4096,备份是2048
pagesize是2k,它应该是默认的页大小,虚拟页大小。
maxpagesize才是用户数据库创建时的默认大小。逻辑页大小。不能在已经建立的服务器上修改。要想修改,必须重建服务器。
0 0
- The database page size of 4096 bytes obtained from ASE is different from the database page size of 2
- 关于Size of the Database Buffer Cache与Streams Pool
- Using Timer to get history values from EDNA database, an error is prompted in the page : "Sys.WebForms.PageRequestManagerTimeout
- warning: the frame size of 1456 bytes is larger than 1024 bytes
- warning: the frame size of 1040 bytes is larger than 1024 bytes
- warning: the frame size of 1040 bytes is larger than 1024 bytes
- warning: the frame size of 1040 bytes is larger than 1024 bytes
- warning: the frame size of 1104 bytes is larger than 1024 bytes [-Wframe-larger-than=]
- New Memory allocation 1046759 bytes is smaller than the minimum allocation size of 1048576 bytes.
- warning: the frame size of 1040 bytes is larger than 1024 bytes
- warning: cast to pointer from integer of different size
- Accessing the Database Home Page
- 13.You have executed this command to change the size of the database buffer cache:
- The count of VLFs for different size of transaction log
- The size of system
- InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 640 pages
- copy_from_user: Warning: the frame size of xxx bytes is larger than 1024 bytes 这个警告如何修改
- InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
- Cg per-vertex lighting
- 新版linux内核对nat的修改
- eclipse 开发常用总结
- 数据库完整性约束
- 微信iBeaconID-微信官方iBeacon蓝牙基站UUID编码
- The database page size of 4096 bytes obtained from ASE is different from the database page size of 2
- 优秀博客收集
- 机器学习 & python k-近邻算法
- hdu 4251 The Famous ICPC Team Again(划分树)
- Nginx个人调优见解
- 发布Web项目时访问域名打开首页
- iOS常用的几个动画
- java 调用webservice的各种方法总结
- poj1252 BFS