注册
dmctlcvt工具使用
技术分享/ 文章详情 /

dmctlcvt工具使用

阳春白雪 2022/06/05 1966 0 0

dmctlcvt工具可以实现控制文件和文本文件之间的转换

下面例子是控制文件转换为文本文件:

[dmdba@dem test]$ file dm.ctl
dm.ctl: data
[dmdba@dem test]$  strings dm.ctl
test
SYSTEM
/home/dmdba/dmdbms/data/test/SYSTEM.DBF
ROLL
/home/dmdba/dmdbms/data/test/ROLL.DBF
RLOG
/home/dmdba/dmdbms/data/log01.log
/home/dmdba/dmdbms/data/log02.log
/home/dmdba/dmdbms/data/log03.log
MAIN
/home/dmdba/dmdbms/data/test/MAIN.DBF
BOOKSHOP
NORMAL
/home/dmdba/dmdbms/data/test/BOOKSHOP.DBF
DMHR
NORMAL
/home/dmdba/dmdbms/data/test/DMHR.DBF
HMAIN"
/home/dmdba/dmdbms/data/test/HMAIN
[dmdba@dem test]$ which dmctlcvt
~/dmdbms/bin/dmctlcvt
[dmdba@dem test]$ dmctlcvt help
DMCTLCVT V8

格式: ./dmctlcvt KEYWORD=value
注意: 控制文件名称必须指定为dm.ctl、dmmpp.ctl、dss.ctl

关键字              说明
--------------------------------------------------------------------------------
TYPE                1 转换控制文件为文本文件(源文件路径中控制文件名称必须是dm.ctl或dmmpp.ctl或dss.ctl)
                    2 转换文本文件为控制文件(目标文件路径中控制文件名称必须是dm.ctl或dmmpp.ctl或dss.ctl)
SRC                 源文件路径
DEST                目标文件路径
DCR_INI             dmdcr.ini文件路径
DFS_INI             dmdfs.ini文件路径
HELP                打印帮助信息

示例:
./dmctlcvt TYPE=1 SRC=/opt/dmdbms/data/dameng/dm.ctl DEST=/opt/dmdbms/data/dameng/dmctl.txt
./dmctlcvt TYPE=2 SRC=/opt/dmdbms/data/dameng/dmctl.txt DEST=/opt/dmdbms/data/dameng/dm.ctl
[dmdba@dem test]$ dmctlcvt type=1 src=dm.ctl dest=dmctl.text
DMCTLCVT V8
convert ctl to txt success!
[dmdba@dem test]$ dmctlcvt type=1 src=dm.ctl dest=dmctl.text
DMCTLCVT V8
convert ctl to txt success!
[dmdba@dem test]$ cat dmctl.text 
##############################################################################
## please do not adjust parameter order, ensure the ctl have no difference ###
##########################################################################


# database name
dbname=test
# server mode
svr_mode=0
#OGUID
oguid=0
# db server version
version=117508194
# database version
db_version=458764
# pseg version
pseg_version=0
#SGUID
sguid=362313231
#NEXT_TS_ID
next_ts_id=7
#RAC_NODES
rac_nodes=1
#NEXT_HTS_ID
next_htsid=129
#TIME_FLAG
time_flag=170
#MDIR_FLAG
mdir_flag=31
#STARTUP_CNT
startup_cnt=10
#LAST_STARTUP_TIME
last_startup_time=DATETIME '2022-5-26 19:59:11'
#DM7_DCT_VERSION
dm7_dct_version=11
#DM8_DCT_VERSION
dm8_dct_version=42
......

社区地址:https://eco.dameng.com

评论
后发表回复

作者

文章

阅读量

获赞

扫一扫
联系客服