DB2安装及HADR配置手册 V1.0
- 格式:doc
- 大小:1.22 MB
- 文档页数:15
DB2安装操作手册一、数据库的安装db2 V10.5:
安装ESE版本数据库:./db2setup
使用图形化安装步骤:
密码:password
二、HADR配置
mkdir -p /home/db2inst1/db2_backup
mkdir -p /home/db2inst1/db2_archive
mkdir -p /home/db2inst1/db2_log
chmod -R 775 /home/db2inst1/db2_backup
chmod -R 775 /home/db2inst1/db2_archive
chmod -R 775 /home/db2inst1/db2_log
chown -R db2inst1:db2inst1 /home/db2inst1/db2_backup
chown -R db2inst1:db2inst1/home/db2inst1/db2_archive
chown -R db2inst1:db2inst1 /home/db2inst1/db2_log
2.1、服务和端口配置(注意HADR服务端口和实例端口要区分开)
DB2_HADR_1 55110/tcp
DB2_HADR_2 55111/tcp
db2 get dbm cfg | grep -i SVCENAME
db2 update dbm cfg using SVCENAME DB2_db2inst1
db2 update database manager configuration using svcename DB2_HADR _1(自定义名称)
主库
db2 update dbm cfg using SVCENAME 55110
备库
db2 update dbm cfg using SVCENAME 55111
UPDATE ALTERNATE SERVER FOR DATABASE SAMPLE USING HOS TNAME 192.168.12.107 PORT 50000
UPDATE ALTERNATE SERVER FOR DATABASE SAMPLE USING HOS TNAME 192.168.12.108 PORT 50000
2.2、开启归档模式(主库和备库都操作)
先修改归档参数,做离线备份,重启数据库后,手工测试归档
主库
db2 update db cfg for sample using logarchmeth1 disk:/home/db2inst1/db 2_archive/
db2 update db cfg for sample using NEWLOGPATH /home/db2inst1/db2_ log
db2 force applications all
db2 backup db sample to /home/db2inst1/db2_backup/
db2stop force;db2start
db2 archive log for db sample
SQL1116N A connection to or activation of database "SAMPLE" failed b ecause
the database is in BACKUP PENDING state. SQLSTATE=57019
备库:
db2 update db cfg for sample using logarchmeth1 disk:/home/db2inst1/db 2_archive/
db2 update db cfg for sample using NEWLOGPATH /home/db2inst1/db2_ log
db2 force applications all
db2 backup db sample to /home/db2inst1/db2_backup/
db2stop force;db2start
db2 archive log for db sample
2.3、备份和还原从库
主库离线全备份
1.db2 backup database sample to /home/db1inst1/db2_backup
3.scp /home/db2inst1/db2_backup/SAMPLE.0.db2inst1.DBPART000.201712 2016540
4.001 ****************.12.108:/home/db2inst1/db2_backup/
备库还原数据
db2 restore database sample from "/home/db2inst1/db2_backup/" taken a t 20171220165404 replace history file
2.SQL2523W Warning! Restoring to an existing database that is different from
3.the database on the backup image, but have matching names. The tar get database
4.will be overwritten by the backup version. The Roll-forward recovery lo gs
5.associated with the target database will be deleted.
6.Do you want to continue ? (y/n) y
7.DB20000I The RESTORE DATABASE command completed successfull y.
2.4、主库参数配置
db2 get db cfg for sample | grep -i HAD
R
[db2inst1@107-sqlcheck db2_backup]$ db2 get db cfg for sample | grep -i HADR
HADR database role = STANDARD
HADR local host name (HADR_LOCAL_HOST) =
HADR local service name (HADR_LOCAL_SVC) =
HADR remote host name (HADR_REMOTE_HOST) =