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
文章
阅读量
获赞