发布时间 : 星期六 文章DB2数据库的备份与恢复(windows)更新完毕开始阅读
CommVault DB2数据库的备份与恢复
for Windows
北京同有飞骥科技有限公司
上海分公司技术部
DB2数据库备份恢复手册
目 录
1、实施前提 ........................................................................................................................................... 3
1.1需修改主机地方 ....................................................................................................................... 3 1.2支持操作系统 ........................................................................................................................... 3 1.3内存需求 ................................................................................................................................... 3 1.4硬盘容量需求 ........................................................................................................................... 4 1.5外围设备需求 ........................................................................................................................... 4 2、安装配置 ........................................................................................................................................... 5 3、DB2数据备份 ................................................................................................................................ 18
3.1实例配置方法 ......................................................................................................................... 18 3.2备份集创建 ............................................................................................................................. 20 3.3创建备份作业 ......................................................................................................................... 22 4、数据恢复 ......................................................................................................................................... 27
4.1浏览备份数据 ......................................................................................................................... 27 4.2选择需恢复数据 ..................................................................................................................... 27
2
DB2数据库备份恢复手册
1、实施前提
1.1需修改主机地方
? 在客户端修改HOSTS文件,添加备份服务器IP和主机名 ? 关闭防火墙设置,包括系统自带(如XP SP2、2003 SP1)
1.2支持操作系统
DB2 7.2 Universal Database 32-bit w/FixPak 13 on:
? Microsoft Windows 2000 Server with Service Pack 2, 3 or 4
? Microsoft Windows 2000 Advanced Server with Service Pack 2, 3 or 4 ? Microsoft Windows Server 2003 Enterprise Edition up to Service Pack 1 DB2 8.1 Universal Database 32-bit w/FixPak 6 on:
? Microsoft Windows 2000 Advanced Server with Service Pack 2, 3 or 4 ? Microsoft Windows Server 2003 Enterprise Edition up to Service Pack 1 DB2 8.2 Universal Database 32-bit w/FixPak 6 on:
? Microsoft Windows 2000 Server with Service Pack 2, 3 or 4
? Microsoft Windows 2000 Advanced Server with Service Pack 2, 3 or 4 ? Microsoft Windows Server 2003 Enterprise Edition up to Service Pack 1
1.3内存需求
? 32 MB RAM minimum required beyond the requirements of the operating
system and running applications
3
DB2数据库备份恢复手册
1.4硬盘容量需求
? 95 MB minimum of hard disk space for software ? 100 MB of additional hard disk space for log file growth
? 20 MB of temp space required for install or upgrade (where the temp folder
resides)
1.5外围设备需求
? CD-ROM drive ? Network Interface Card
4