[dmdba@dmdb1 DAMENG]$
[dmdba@dmdb1 DAMENG]$ cat dm0509.txt
################################################################################ please do not adjust parameter order, ensure the ctl have no difference ############################################################################## database name
dbname=DAMENG
# server mode
svr_mode=0
#OGUID
oguid=0
# db server version
version=117508180
# database version
db_version=458764
# pseg version
pseg_version=458762
#SGUID
sguid=400761439
#NEXT_TS_ID
next_ts_id=6
#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=7
#LAST_STARTUP_TIME
last_startup_time=DATETIME '2022-5-9 15:23:16'#DM7_DCT_VERSION
dm7_dct_version=11
#DM8_DCT_VERSION
dm8_dct_version=38
#===============================================#===============================================# table space name
ts_name=SYSTEM
# table space ID
ts_id=0
# table space status
ts_state=0
# table space cache
ts_cache=
# DSC node number
ts_nth=0
# DSC optimized node number
ts_opt_node=0
# table space create time
ts_create_time=DATETIME '2022-5-7 17:19:17'# table space modify time
ts_modify_time=DATETIME '2022-5-9 15:24:59'# table space encrypt flag
ts_encrypt_flag=0
# table space copy num
ts_copy_num=0
# table space region size flag
ts_size_flag=0
#-----------------------------------------------# file path
fil_path=/dm8/dmdbms/data/DAMENG/SYSTEM.DBF ###期望调整为/dm8/dmdbms/DAMENG/SYSTEM01.DBF# mirror path
mirror_path=
# file id
fil_id=0
# whether the file is auto extend
autoextend=1
# file create time
fil_create_time=DATETIME '2022-5-7 17:19:17'# file modify time
fil_modify_time=DATETIME '2022-5-7 17:19:17'# the max size of file
fil_max_size=0
# next size of file
fil_next_size=0
# file path
fil_path=/dm8/dmdbms/data/DAMENG/SYSTEM02.DBF
# mirror path
mirror_path=
# file id
fil_id=1
# whether the file is auto extend
autoextend=1
# file create time
fil_create_time=DATETIME '2022-5-9 15:24:59'# file modify time
fil_modify_time=DATETIME '2022-5-9 15:24:59'# the max size of file
fil_max_size=0
# next size of file
fil_next_size=5
#===============================================# table space name
ts_name=ROLL
# table space ID
ts_id=1
# table space status
ts_state=0
# table space cache
ts_cache=
# DSC node number
ts_nth=0
# DSC optimized node number
ts_opt_node=0
# table space create time
ts_create_time=DATETIME '2022-5-7 17:19:17'# table space modify time
ts_modify_time=DATETIME '2022-5-9 15:14:18'# table space encrypt flag
ts_encrypt_flag=0
# table space copy num
ts_copy_num=0
# table space region size flag
ts_size_flag=0
#-----------------------------------------------# file path
fil_path=/dm8/dmdbms/data/DAMENG/ROLL.DBF ###期望调整为/dm8/dmdbms/DAMENG/ROLL01.DBF# mirror path
mirror_path=
# file id
fil_id=0
# whether the file is auto extend
autoextend=1
# file create time
fil_create_time=DATETIME '2022-5-7 17:19:17'# file modify time
fil_modify_time=DATETIME '2022-5-7 17:19:17'# the max size of file
fil_max_size=0
# next size of file
fil_next_size=0
# file path
fil_path=/dm8/dmdbms/data/DAMENG/ROLL02.DBF
# mirror path
mirror_path=
# file id
fil_id=1
# whether the file is auto extend
autoextend=1
# file create time
fil_create_time=DATETIME '2022-5-9 15:14:18'# file modify time
fil_modify_time=DATETIME '2022-5-9 15:14:18'# the max size of file
fil_max_size=100
# next size of file
fil_next_size=5
#===============================================# table space name
ts_name=RLOG
# table space ID
ts_id=2
# table space status
ts_state=0
# table space cache
ts_cache=
# DSC node number
ts_nth=0
# DSC optimized node number
ts_opt_node=0
# table space create time
ts_create_time=DATETIME '2022-5-7 17:19:17'# table space modify time
ts_modify_time=DATETIME '2022-5-7 17:19:17'# table space encrypt flag
ts_encrypt_flag=0
# table space copy num
ts_copy_num=0
# table space region size flag
ts_size_flag=0
#-----------------------------------------------# file path
fil_path=/dm8/dmdbms/data/DAMENG/DAMENG01.log
# mirror path
mirror_path=
# file id
fil_id=0
# whether the file is auto extend
autoextend=1
# file create time
fil_create_time=DATETIME '2022-5-7 17:19:17'# file modify time
fil_modify_time=DATETIME '2022-5-7 17:19:17'# the max size of file
fil_max_size=0
# next size of file
fil_next_size=0
# file path
fil_path=/dm8/dmdbms/data/DAMENG/DAMENG02.log
# mirror path
mirror_path=
# file id
fil_id=1
# whether the file is auto extend
autoextend=1
# file create time
fil_create_time=DATETIME '2022-5-7 17:19:17'# file modify time
fil_modify_time=DATETIME '2022-5-7 17:19:17'# the max size of file
fil_max_size=0
# next size of file
fil_next_size=0
#===============================================# table space name
ts_name=MAIN
# table space ID
ts_id=4
# table space status
ts_state=0
# table space cache
ts_cache=
# DSC node number
ts_nth=0
# DSC optimized node number
ts_opt_node=0
# table space create time
ts_create_time=DATETIME '2022-5-7 17:19:17'# table space modify time
ts_modify_time=DATETIME '2022-5-7 17:19:17'# table space encrypt flag
ts_encrypt_flag=0
# table space copy num
ts_copy_num=0
# table space region size flag
ts_size_flag=0
#-----------------------------------------------# file path
fil_path=/dm8/dmdbms/data/DAMENG/MAIN.DBF
# mirror path
mirror_path=
# file id
fil_id=0
# whether the file is auto extend
autoextend=1
# file create time
fil_create_time=DATETIME '2022-5-7 17:19:17'# file modify time
fil_modify_time=DATETIME '2022-5-7 17:19:17'# the max size of file
fil_max_size=0
# next size of file
fil_next_size=0
#===============================================# HUGE table space name
htsname=HMAIN
# HUGE table space id
htsid=128
#HUGE table space share flag
htsflag=0
# HUGE table space copy num
hts_copy_num=0
# HUGE table space region size flag
hts_size_flag=0
# HUGE table space create time
hts_create_time=DATETIME '2022-5-7 17:19:17'# HUGE table space modify time
hts_modify_time=DATETIME '2022-5-7 17:19:17'# HUGE table space path
htspath=/dm8/dmdbms/data/DAMENG/HMAIN
#===============================================[dmdba@dmdb1 DAMENG]$
SYSTEM 表空间和ROLL表空间SYSTEM 表空间存放了有关 DM 数据库的字典信息,用户不能在 SYSTEM 表空间创建表和索引。ROLL表空间完全由DM数据库自动维护,用户无需干预。ROLL表空间用来存放事务运行过程中执行DML作之前的值,从而为访问该表的其他用户提供表数据的读一致性视图。迁移SYSTEM和ROLL表空间SYSTEM表空间从/dm8/dmdbms/data/DAMENG/SYSTEM.DBF期望调整为/dm8/dmdbms/DAMENG/SYSTEM01.DBFROL