ITPub博客

首页 > Linux操作系统 > Linux操作系统 > informix HDR 配置

informix HDR 配置

原创 Linux操作系统 作者:tonykorn97 时间:2008-03-24 00:00:00 0 删除 编辑

一,首先安装两台相同版本操作系统的服务器


二,服务器配置文件信息

主机名和ip地址信息
/etc/hosts
172.25.1.114 test01
172.25.1.115 test02

配置数据信任关系
/home/informix/.rhosts
test01
test02

三,配置操作系统rsh服务

四,安装数据库
informix的实例名配置如下:
ontest01 onsoctcp test01 6666
ontest02 onsoctcp test02 6666

数据库配置文件中主要的配置如下:

为了实现通过管道备份恢复,配置TAPEDEV和LTAPEDEV的值STDIO

企业复制的参数暂时按照默认设置
# Data Replication Variables
# DRAUTO: 0 manual, 1 retain type, 2 reverse type
DRAUTO 0 # DR automatic switchover
DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)
DRTIMEOUT 30 # DR network timeout (in sec)
DRLOSTFOUND /home/informix/etc/dr.lostfound # DR lost+found file path
DRIDXAUTO 0 # DR automatic index repair. 0=off, 1=on


五,开始配置HDR
为了测试方便,在test01上面建立一个数据库做为主,test02服务器上的数据库做为从。

1,使用onmode -d 将test01的类型设置为主类型并指示相关联的辅助数据库服务器的名称(这个名称指的是从服务器的数据库的实例名)。

[informix@test01 informix]$ onmode -d primary ontest02

出现的日志信息为:
[informix@test01 informix]$ onstat -m

14:51:55 DR: Reservation of the last logical log for log backup turned on
14:51:55 DR: new type = primary, secondary server name = ontest02
14:51:55 DR: Trying to connect to secondary server = ontest02
14:51:55 DR: Cannot connect to secondary server
14:51:55 DR: Turned off on primary server


2,在test01上执行备份通过管道直接在test02上面执行物理恢复
[informix@test01 informix]$ ontape -s -L 0 -F | rsh test02 "ontape -p "


3,通过下面的日志信息可以看到test02上面的物理恢复已经完成
[informix@test02 informix]$ onstat -m

IBM Informix Dynamic Server Version 10.00.UC4 -- Fast Recovery -- Up 00:01:23 -- 229336 Kbytes

Message Log File: /home/informix/test02.log

14:54:02 DR: Reservation of the last logical log for log backup turned on
14:54:02 Data replication type and state information reset. To start DR, use
the 'onmode -d' command and wait for the pair to be operational,
before shutting down the database server

14:54:02 Dataskip is now OFF for all dbspaces
14:54:02 Restartable Restore has been ENABLED
14:54:02 Recovery Mode
14:54:04 Physical Restore of rootdbs started.

14:54:05 Checkpoint Completed: duration was 0 seconds.
14:54:05 Checkpoint loguniq 4, logpos 0x17c018, timestamp: 0xed4a

14:54:05 Maximum server connections 0
14:54:07 Physical Restore of rootdbs Completed.
14:54:07 Checkpoint Completed: duration was 0 seconds.
14:54:07 Checkpoint loguniq 4, logpos 0x17c018, timestamp: 0xed4e

14:54:07 Maximum server connections 0

[informix@test02 informix]$


4,在test02上执行:
[informix@test02 informix]$ onmode -d secondary ontest01

系统提示:
[informix@test02 informix]$ onstat -m
14:56:46 DR: Reservation of the last logical log for log backup turned off
14:56:46 DR: new type = secondary, primary server name = ontest01
14:56:46 DR: Trying to connect to primary server = ontest01
14:56:49 DR: Secondary server connected
14:56:49 DR: Secondary server needs failure recovery

5,此时数据库继续执行逻辑恢复,日志信息:
14:56:50 DR: Failure recovery from disk in progress ...
14:56:50 Logical Recovery Started.
14:56:50 10 recovery worker threads will be started.
14:56:50 Dynamically allocated new virtual shared memory segment (size 8192KB)
14:56:50 Start Logical Recovery - Start Log 4, End Log ?
14:56:50 Starting Log Position - 4 0x17c018
14:56:50 Clearing the physical and logical logs has started
14:56:51 Cleared 40 MB of the physical and logical logs in 0 seconds
14:56:56 DR: Secondary server operational
14:56:57 Checkpoint Completed: duration was 0 seconds.
14:56:57 Checkpoint loguniq 5, logpos 0x1018, timestamp: 0xedaa

14:56:57 Maximum server connections 0


而另外一台主服务器上面的日志信息为:
14:56:49 DR: Primary server connected
14:56:49 DR: Secondary server needs failure recovery

14:56:52 Logical Log 4 Complete, timestamp: 0xed84.
14:56:53 DR: Sending log 4, size 1000 pages, 38.30 percent used
14:56:53 DR: Sending log 5 (current), size 1000 pages, 0.00 percent used
14:56:55 DR: Sending Logical Logs Completed
14:56:56 DR: Primary server operational

从上面可以看到数据库之间的执行步骤。


6,此时数据库的状态为:
[informix@test02 informix]$ onstat -

IBM Informix Dynamic Server Version 10.00.UC4 -- Read-Only (Sec) -- Up 00:04:58 -- 237528 Kbytes

[informix@test02 informix]$

主服务器的数据库状态为:

[informix@test01 informix]$ onstat -

IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line (Prim) -- Up 00:09:36 -- 229336 Kbytes

[informix@test01 informix]$


7,此时在test01上面执行的ontape -s -L 0 -F | rsh test02 "ontape -p " 命令还没有结束,在test02上面执行onmode -ky关闭数据库,然后重新启动,此时test01上面的任务完成退出。

8,在test01上面重新建立一个库,然后在test02上面查看是否有新的库,测试HDR是否成功。

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/312079/viewspace-245838/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: HDR 中一些说明
请登录后发表评论 登录
全部评论

注册时间:2007-12-05

  • 博文量
    1854
  • 访问量
    2088332