HADR 运维注意事项.

字数 1914阅读 3708评论 11赞 3

HADR 运维注意事项 1) Stop HADR Warning: Although 
the STOP HADR command can be used to stop HADR on the primary or the 
standby, or both, it should be used with caution. If you want to stop 
the specified database but still want it to maintain its role as either 
an HADR primary or a standby database, do not issue the STOP HADR 
command. If you issue the STOP HADR command, the 
database becomes a standard database and might require re-initialization
 in order to resume operations as an HADR database. Instead, issue the 
DEACTIVATE DATABASE command. 在停HADR 进行运维的时候 不失去HADR primary standby 角色的正确停止办法是 On both Primary and Standby . db2 force applications all db2 terminate db2 deactivate db xxx db2stop 启动的时候 on both server. db2start db2 activate db xxx 数据库会保持在db cfg 里面配置的HADR 信息 并自动启动HADR . 2)  LOAD in HADR. Load operations and HADR If a 
load operation is executed on the primary database with the COPY YES 
option, the command will execute on the primary database and the data 
will be replicated to the standby database as long as the copy can be 
accessed through the path or device specified by the LOAD command. If 
the standby database cannot access the data, the table space in which 
the table is stored is marked invalid on the standby database. The 
standby database will skip future log records that pertain to this table
 space. To ensure that the load operation can access the copy on the 
standby database, it is recommended that you use a shared location for 
the output file from the COPY YES option. Alternatively, you can 
deactivate the standby database while the load operation is performed, 
perform the load on the primary, place a copy of the output file in the 
standby path, and then activate the standby database. 在Primary 上面Load的时候也需要特别注意. 我们copy yes产生的那个文件应当放在一个standby by 能够访问得到的地方比如NFS的 共享目录 . 并且有相应的读的权限. 因为我们stand by上面rf 的时候需要用到这个copy yes产生的日志文件. 其他运维事项会陆续添加.

HADR

著作权归作者所有

如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！

添加新评论11 条评论

oracle12c数据库管理员**证券
2013-06-22 14:19

学习学习。

uc804数据库运维工程师企业
2013-01-09 14:24

第二部分还要琢磨消化

drdb2系统工程师se
2012-10-17 23:08

May you please add more stuff such as monitoring, general administration, backup, etc

daolin2005数据库管理员某城商行
2012-10-17 09:46

freebile: 顶顶

谢谢.

daolin2005数据库管理员某城商行
2012-10-17 09:46

drdb2: good knowledge sharing

谢谢鼓励!!!

drdb2系统工程师se
2012-10-17 02:57

good knowledge sharing

freebile数据库运维工程师金融行业
2012-09-28 09:42

顶顶

daolin2005数据库管理员某城商行
2012-09-26 14:29

田强: 顶

田老大来了(^o^)/~

2012-09-26 13:11

顶

daolin2005数据库管理员某城商行
2012-09-25 16:44

jeffbeck: 在第一点的时候：db2stop和db2start在主备机上执行的时候，有没有什么先后顺序么；还是这先后没什么关系

信息中心推荐的办法是先stop primary.

if you only want to shut down the HADR operation, this is the recommended way of shutting down the HADR pair:

1) Deactivate the primary database
2) Stop DB2 on the primary database
3) Deactivate the standby database
4) Stop DB2 on the standby database

jeffbeck数据库管理员某银行
2012-09-25 14:51

在第一点的时候：db2stop和db2start在主备机上执行的时候，有没有什么先后顺序么；还是这先后没什么关系

Ctrl+Enter 发表

匿名评论

HADR 运维注意事项.

添加新评论11 条评论

作者其他文章

相关问题