DB20000I TheUPDATE DATABASE CONFIGURATION command completed successfully.
db2inst2@DB2server2:~> db2 update db cfg for ogausing hadr_remote_host 192.168.5.151
DB20000I TheUPDATE DATABASE CONFIGURATION command completed successfully.
db2inst2@DB2server2:~> db2 update db cfg for ogausing hadr_remote_svc 33344
DB20000I TheUPDATE DATABASE CONFIGURATION command completed successfully.
db2inst2@DB2server2:~> db2 update db cfg for ogausing hadr_syncmode nearsync
DB20000I TheUPDATE DATABASE CONFIGURATION command completed successfully.
db2inst2@DB2server2:~> db2 update db cfg for ogausing HADR_REMOTE_INST db2inst1
DB20000I TheUPDATE DATABASE CONFIGURATION command completed successfully.
db2 UPDATE ALTERNATE SERVER FOR DATABASE SAMPLE USINGHOSTNAME 192.168.5.152 PORT 50001
db2inst1@DB2server2:~> db2 get db cfg for oga | grep-i hadr
db2inst2@DB2server2:/opt/bak> cd /opt/bak/
重定向恢复
db2 restore db oga on /data_inst2/db2inst2/oga/ dbpathon /data_inst2/db2inst2/ into oga
db2 rollforward db oga stop ——这个不需要执行，否则在启动备库的时候会提示SQL1767N Start HADR cannot complete. Reason code ="1".
将表恢复到了db2inst1下面，保证db2inst2可以看到这些表
db2inst2@DB2server2:~> db2 connect to sample userdb2inst1 using db2inst
db2inst2@DB2server2:/opt/bak> db2 connect to sample
b2inst1@DB2server1:/opt/bak> db2 grant dbadm ondatabase to db2inst2
DB20000I The SQLcommand completed successfully.
db2inst1@DB2server1:/opt/bak> db2 grant secadm ondatabase to db2inst2
DB20000I The SQLcommand completed successfully.
db2inst2@DB2server2:~> db2 "select * from db2inst1.cert"
ORGID ENTID CERTNUM ISSUEDATE
----------- ----------- -------------------- ----------
1 2 cert1 12/05/2009
2 2 cert2 03/05/2010
3 2 cert3 03/23/2012
启动standby
db2inst2@DB2server2：~>db2 deactivate database sample
SQL1496W Deactivate database is successful, but the database was not
activated.是断开关闭数据库
db2inst2@DB2server2:~> db2 start hadr on db oga asstandby
SQL1032N Nostart database manager command was issued.
注意：此时standby不可以连接数据库，否则会造成主库不一致的。
db2inst2@DB2server2:~> db2 get snapshot for db onoga | grep Role
Role = Standby
db2inst2@DB2server2:~>
启动主机
db2inst1@DB2server1:/opt/bak> db2 activate db oga
DB20000I TheACTIVATE DATABASE command completed successfully.
db2inst2@DB2server1:~> db2 start hadr on db oga as primary
db2inst1@DB2server1:~> db2 get snapshot for db onsample | grep Role
Role = Primary
验证两台机的状态：
db2inst1@DB2server1:~> db2 get snapshot for db onoga | grep state
Commit statements attempted = 16
Rollback statements attempted = 0
Dynamic statements attempted = 479
Static statements attempted = 30
Failed statement operations = 0
Select SQL statements executed = 152
Xquery statements executed = 0
Update/Insert/Delete statements executed = 9
DDL statements executed = 0
停止
db2inst2@DB2server2:~> db2 deactivate database oga
DB20000I TheDEACTIVATE DATABASE command completed successfully.
db2inst2@DB2server2:~> db2 stop hadr on database oga
DB20000I TheSTOP HADR ON DATABASE command completed successfully.
db2inst2@DB2server1: