博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
informix数据空间镜像操作步骤
阅读量:2452 次
发布时间:2019-05-10

本文共 7162 字,大约阅读时间需要 23 分钟。

1,建立镜像文件
[root@tonykorn97 root]# cd /informix.links/
[root@tonykorn97 root]# mkdir m_front
[root@tonykorn97 root]# cd m_front
[root@tonykorn97 root]# touch rootdbs
[root@tonykorn97 root]# touch plogdbs
[root@tonykorn97 root]# touch llogdbs
[root@tonykorn97 root]# touch tempdbs
[root@tonykorn97 root]# touch datadbs
[root@tonykorn97 root]# chmod 660 *
[root@tonykorn97 root]# cd ..
[root@tonykorn97 root]# chown -R informix:informix m_front

2,数据文件统一性操作

onbar -b -l -c
onmode -c
弹出磁带

3,运行中,没有修改onconfig文件

[informix@tonykorn97 informix]$ ls -al /informix.links/m_front/*
-rw-rw---- 1 informix informix 0 Feb 12 22:23 /informix.links/m_front/datadbs
-rw-rw---- 1 informix informix 0 Feb 12 22:23 /informix.links/m_front/llogdbs
-rw-rw---- 1 informix informix 0 Feb 12 22:23 /informix.links/m_front/plogdbs
-rw-rw---- 1 informix informix 0 Feb 12 22:23 /informix.links/m_front/rootdbs
-rw-rw---- 1 informix informix 0 Feb 12 22:32 /informix.links/m_front/tempdbs
[informix@tonykorn97 informix]$ onspaces -m rootdbs -p /informix.links/front/rootdbs -o 0 -m /informix.links/m_front/rootdbs 0
IBM Informix Dynamic Server was initialized with no mirroring.

4,修改onconfig文件。

MIRROR 1 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH /informix.links/m_front/rootdbs # Path for device containing mirrored root
启动是报:
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 1 flushers...succeeded
SENDER IS NULL NO MAIL WILL BE SENT
Initializing log/checkpoint information...succeeded
Opening primary chunks...succeeded
Opening mirror chunks...succeeded
Initializing dbspaces...Mismatch in configuration file : MIRRORPATH = /informix.links/m_front/rootdbs.
Root chunk was not mirrored.
Add mirroring using onspaces or onmonitor.
FAILED
oninit: Fatal error in shared memory initialization

5,修改onconfig文件

只修改:
MIRROR 1 # Mirroring flag (Yes = 1, No = 0)
正常启动
23:45:16 Onconfig parameter MIRROR modified from 0 to 1.
23:45:16 Dataskip is now OFF for all dbspaces
23:45:16 Checkpoint Completed: duration was 0 seconds.
23:45:16 Checkpoint loguniq 2328, logpos 0x10018, timestamp: 0xa7aebdc

23:45:16 Maximum server connections 0

23:45:16 On-Line Mode

6,添加rootdbs镜像
[informix@tonykorn97 etc]$ onspaces -m rootdbs -p /informix.links/front/rootdbs -o 0 -m /informix.links/m_front/rootdbs 0
WARNING: Turning mirror on for 'rootdbs'.

Do you really want to continue? (y/n)y

Verifying physical disk space, please wait ...
The Space "rootdbs" is now mirrored.
[informix@tonykorn97 etc]$

日志信息

23:48:42 Checkpoint Completed: duration was 0 seconds.
23:48:42 Checkpoint loguniq 2328, logpos 0x111fc, timestamp: 0xa7aebed

23:48:42 Maximum server connections 0

23:48:42 The Space "rootdbs" is now mirrored.

23:48:42 Space 'rootdbs' -- Recovery Begins(0x523bb4c8)

23:48:42 Chunk Number 1 - '/informix.links/m_front/rootdbs' -- Recovery Begins(0x523bb4c8)
23:49:38 Chunk Number 1 - '/informix.links/m_front/rootdbs' -- Online
23:49:38 Checkpoint Completed: duration was 0 seconds.
23:49:38 Checkpoint loguniq 2328, logpos 0x13018, timestamp: 0xa7aebf7

23:49:38 Maximum server connections 0

23:49:38 Space 'rootdbs' -- Recovery Complete(0x523bb4c8)

7,增加其它数据空间

onspaces -m plogdbs -p /informix.links/front/plogdbs -o 0 -m /informix.links/m_front/plogdbs 0
onspaces -m llogdbs -p /informix.links/front/llogdbs -o 0 -m /informix.links/m_front/llogdbs 0
onspaces -m tempdbs -p /informix.links/front/tempdbs -o 0 -m /informix.links/m_front/tempdbs 0
onspaces -m datadbs -p /informix.links/front/datadbs -o 0 -m /informix.links/m_front/datadbs 0

[informix@tonykorn97 etc]$ onspaces -m tempdbs -p /informix.links/front/tempdbs -o 0 -m /informix.links/m_front/tempdbs 0
Cannot mirror a temporary DBspace.

此时数据空间的状态是:

address chunk/dbs offset size free bpages flags pathname
5e0fd948 1 1 5 64000 58932 PO-B /informix.links/front/rootdbs
5e0fdad0 1 1 5 64000 0 MO-B /informix.links/m_front/rootdbs
5e90e258 2 2 5 256000 447 PO-B /informix.links/front/plogdbs
5ea0ec28 2 2 5 256000 0 MO-B /informix.links/m_front/plogdbs
5e90e3e0 3 3 5 512000 1947 PO-B /informix.links/front/llogdbs
5ea0edb0 3 3 5 512000 0 MX-B /informix.links/m_front/llogdbs
5e90e568 4 4 5 512000 511947 PO-B /informix.links/front/tempdbs
5e90e6f0 5 5 5 4008000 3971340 PO-B /informix.links/front/datadbs

8,备份

onbar -b -L 0
数据空间状态变为:
5e0fd948 1 1 5 64000 58932 PO-B /informix.links/front/rootdbs
5e0fdad0 1 1 5 64000 0 MO-B /informix.links/m_front/rootdbs
5e90e258 2 2 5 256000 447 PO-B /informix.links/front/plogdbs
5ea0ec28 2 2 5 256000 0 MO-B /informix.links/m_front/plogdbs
5e90e3e0 3 3 5 512000 1947 PO-B /informix.links/front/llogdbs
5ea0edb0 3 3 5 512000 0 MO-B /informix.links/m_front/llogdbs
5e90e568 4 4 5 512000 511947 PO-B /informix.links/front/tempdbs
5e90e6f0 5 5 5 4008000 3971340 PO-B /informix.links/front/datadbs
5ea23e58 5 5 5 4008000 0 MO-B /informix.links/m_front/datadbs

镜像删除

[informix@test ~]$ onspaces -r plogdbs
WARNING: Turning mirror off for 'plogdbs'.

Do you really want to continue? (y/n)y

The Space "plogdbs" is no longer mirrored.
[informix@test ~]$ onstat -d

IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line -- Up 00:24:06 -- 237528 Kbytes

Dbspaces

address number flags fchunk nchunks pgsize flags owner name
5111e7e8 1 0x60002 1 1 2048 M B informix rootdbs
5124d7b8 2 0x60001 2 1 2048 N B informix plogdbs
5124d918 3 0x40001 3 1 2048 N B informix llogdbs
5124da78 4 0x40001 4 1 2048 N B informix datadbs
5124dbd8 5 0x42001 5 1 2048 N TB informix tempdbs
5 active, 2047 maximum

Chunks

address chunk/dbs offset size free bpages flags pathname
5111e948 1 1 0 500000 497212 PO-B /informix.link/front/rootdbs
5111ead0 1 1 0 500000 0 MO-B /informix.link/m_front/rootdbs
5125edf0 2 2 50 500000 399947 PO-B /informix.link/front/plogdbs
5111eca0 3 3 50 500000 299947 PO-B /informix.link/front/llogdbs
5111ee28 4 4 50 2500000 2499947 PO-B /informix.link/front/datadbs
5124d630 5 5 0 500000 499947 PO-B /informix.link/front/tempdbs
5 active, 32766 maximum

NOTE: The values in the "size" and "free" columns for DBspace chunks are

displayed in terms of "pgsize" of the DBspace to which they belong.

更改镜像块的状态

1,关闭镜像块

[informix@test ~]$ onspaces -s rootdbs -p /informix.link/m_front/rootdbs -o 0 -D
Warning: bringing down a chunk.
Do you really want to continue? (y/n)y
Chunk status successfully changed.
[informix@test ~]$ onstat -d

IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line -- Up 00:37:13 -- 237528 Kbytes

Dbspaces

address number flags fchunk nchunks pgsize flags owner name
5111e7e8 1 0x60002 1 1 2048 M B informix rootdbs
5124d7b8 2 0x60001 2 1 2048 N B informix plogdbs

Chunks

address chunk/dbs offset size free bpages flags pathname
5111e948 1 1 0 500000 497212 PO-B /informix.link/front/rootdbs
5111ead0 1 1 0 500000 0 MD-B /informix.link/m_front/rootdbs

2,恢复镜像块并使它联机

[informix@test ~]$ onspaces -s rootdbs -p /informix.link/m_front/rootdbs -o 0 -O
WARNING: bringing a down chunk into recovery state.
Do you really want to continue? (y/n)y
Verifying physical disk space, please wait ...
Chunk status successfully changed.

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

转载于:http://blog.itpub.net/312079/viewspace-245619/

你可能感兴趣的文章
万圣节 数据_万圣节的五个3D打印项目
查看>>
ipsec加密技术谁提出的_如何提出技术问题以获得高质量的答案
查看>>
《工程师文化行为自我分享》_文化对于鼓励创新行为至关重要
查看>>
ros开源课程_如何将开源纳入计算机科学课程
查看>>
编程语言在中国哪种职位最多_您使用最多的是哪种“古老”编程语言?
查看>>
开源战略游戏源码_开源的历史告诉我们关于战略优势的知识
查看>>
git查看提交者提交历史_如何维护您的提交者
查看>>
mqa插件_为什么专有的MQA音乐编码系统比DRM更好,但仍然不好
查看>>
程序员项目_您如何让程序员加入您的项目?
查看>>
华为epg-sms 多cp_Linux桌面上的SMS,Linux 25岁生日以及更多开源新闻
查看>>
tarball_如何在墙上扔一个tarball
查看>>
html标记语言图像标记_为什么我喜欢这些标记语言
查看>>
你知道配置管理工具是什么吗_什么是配置管理工具?
查看>>
数字签名开源_开源如何推动数字艺术时代
查看>>
viito为什么不去新说唱_为什么问责制的说唱不好
查看>>
非传统营销 text_传统营销已死
查看>>
python 重复执行任务_使用Python自动执行数字艺术家的重复任务
查看>>
软件开发安全性_开发具有有效安全性的软件的最佳方法
查看>>
周末总是被工作打扰_如何在不打扰任何人的情况下问为什么在工作中
查看>>
java同事只有竞争吗_如何防止同事竞争破坏公司文化
查看>>