DB2 HADR Installation

-
主库服务器：12.11.0.105
主库instance：commerce
instance端口：50000
hadr端口：55001
 
备库服务器：12.11.0.108
备库instance：commerce
instance端口：50000
hadr端口：55002
 
配置
主库服务器：
1. 创建数据库commerce
db2 create database COMMERCE
 
2. 开启归档模式：
db2 update db cfg for commerce using LOGRETAIN ON
db2 update db cfg for commerce using TRACKMOD ON
 
3. 备份数据库commerce
db2 backup database COMMERCE to "/tmp"
 
4. 设置备用数据库信息：
db2 update alternate server for database COMMERCE using hostname 12.11.0.108 port 50000
 
5. 设置HADR参数：
db2 update db cfg for COMMERCE using HADR_LOCAL_HOST 12.11.0.105
db2 update db cfg for COMMERCE using HADR_LOCAL_SVC 55001
db2 update db cfg for COMMERCE using HADR_REMOTE_HOST 12.11.0.108
db2 update db cfg for COMMERCE using HADR_REMOTE_SVC 55002
db2 update db cfg for COMMERCE using HADR_REMOTE_INST commerce
db2 update db cfg for COMMERCE using HADR_SYNCMODE NEARSYNC
db2 update db cfg for COMMERCE using HADR_TIMEOUT 120
db2 connect to COMMERCE
db2 quiesce database immediate force connections
db2 unquiesce database
db2 connect reset
 
备库服务器：
1. 还原数据库commerce
db2 restore database COMMERCE from "/tmp"
 
2. 设置备用数据库信息：
db2 update alternate server for database COMMERCE using hostname 12.11.0.105 port 50000
 
3. 设置HADR参数：
db2 update db cfg for COMMERCE using HADR_LOCAL_HOST 12.11.0.108
db2 update db cfg for COMMERCE using HADR_LOCAL_SVC 55002
db2 update db cfg for COMMERCE using HADR_REMOTE_HOST 12.11.0.105
db2 update db cfg for COMMERCE using HADR_REMOTE_SVC 55001
db2 update db cfg for COMMERCE using HADR_REMOTE_INST commerce
db2 update db cfg for COMMERCE using HADR_SYNCMODE NEARSYNC
db2 update db cfg for COMMERCE using HADR_TIMEOUT 120
 
启动：
1. 启动备库：
db2set DB2_HADR_ROS=ON
db2 deactivate database COMMERCE
db2 start HADR on database COMMERCE as standby
 
2. 启动主库：
db2 deactivate database COMMERCE
db2 start HADR on database COMMERCE as primary
 
查看状态:
db2 connect to COMMERCE
db2 get snapshot for database on COMMERCE
 
检查搭建是否成功：
1. 在主库新建测试表：
db2 connect to COMMERCE
db2 create table hadrtest (id integer, name varchar(10))
db2 insert into hadrtest (1, 'abc')
db2 insert into hadrtest (2, 'bcd')
 
2. 备库接管：
db2 takeover hadr on database COMMERCE
 
3. 备库查看测试表：
db2 connect to COMMERCE
db2 select * from hadrtest
 
4. 后续：重新切换回主库：（操作在主库上）
db2 connect reset
db2 deactivate databaes COMMERCE
db2 start HADR on database COMMERCE as standby
db2 takeover hadr on database COMMERCE
 
紧急故障切换：
db2 takeover hadr on database COMMERCE by force

Comments

Post a Comment

Popular posts from this blog

Nginx Proxy & Load Balance & LNMP

-
Nginx Proxy Service E-commerce website Server 1: provide image request response (  apache / nginx ) Server 2: provide dynamic request response ( php-fpm / apache-php ) Server 3: provide static request response ( apache / nginx ) Server 4: provide data request response ( mysql ) It need one additional nginx server 1. Install nginx 2. proxy to specific server Example location / {      proxy_pass http://192.168.199.187:80/; } location /bbs/ {      proxy_pass http://192.168.199.187:80/bbs/; } location ~* \.(jpg|png|gif)$  {      proxy_pass http://172.16.100.7; } Enhance the log information and specific the hostname location / {      proxy_pass  http://192.168.199.187:80/;      proxy_set_header <parameter name>  $host;  (client requst the hostname )      proxy_set_header <parameter name> $remote_addr; ...
Read more

Snort+barnyard2+Snorby CentOS 6.5_64 Installation

-
#download packages: daq-2.0.2.tar.gz ImageMagicK-6.8.9-8.tar.gz oinkmaster-2.0.tar.gz ruby-1.9.3-p547.tar.gz snort-2.9.6.2.tar.gz snortrules-snapshot-2962.tar.gz MySQL-server-5.5.40-1.rhel5.x86_64.rpm MySQL-client-5.6.21-1.rhel5.x86_64.rpm MySQL-devel-5.6.21-1.rhel5.x86_64.rpm MySQL-shared-5.6.21-1.rhel5.x86_64.rpm epel-release-6-8.noarch.rpm barnyard2-2.1.13.tar.gz #install yum package rpm -ivh epel-release-6-8.noarch.rpm yum install gcc-c++ patch readline readline-devel zlib zlib-devel flex git yum install libyaml-devel libffi-devel openssl-devel make  yum install bzip2 autoconf automake libtool bison iconv-devel libxml2-devel libxslt  yum install gcc g++ build-essential libssl-devel libreadline5-devel zlib1g-devel linux-headers-generic libsqlite3-devel libxslt-devel curl-devel sqlite-devel yum --enablerepo=epel install jasper jasper-libs jasper-devel #Mysql install yum remove mysql mysql-libs rpm -ivh MySQL-server-5.5.40-1.rh...
Read more

ORACLE Error

-
Image
oracle official error explanation  http://docs.oracle.com/cd/E11882_01/server.112/e17766/toc.htm 从服务器下载ALERT日志文件，传输方式需要选择"ASCII" ORA-01078: failure in processing system parameters 发生场景：新建数据库第一次启动时 SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file ‘/home/oracle/oracle/product/10.2.0/db_1/dbs/initorcl.ora’ 原因：oracle_sid没有配置正确 解决方案： 1. 修改oracle用户.bash_profile文件中ORACLE_SID后的内容； 2. 重新已oracle用户登录； ORA-01157: cannot identify/lock data file string - see DBWR trace file  Cause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit access to this file but other files will be unaffected. However the first instance to open the database will need to access all online data files. Accompanying error from the operating system describes why the file could not be identified. Action: Have operating system make file ...
Read more