./dminit path=/dmdata/data page_size=32 extent_size=32 length_in_char=1 case_sensitive=0 charset=0 log_size=2048 port_num=5236 #初始化语句 ./dm_service_installer.sh -t dmserver -p DM -dm_ini /dmdata/data/DAMENG/dm.ini #注册自启服务 #这个参数为0,且在参数修改后,新建的表,才能正常查询 #专门处理isnull方法问题 sp_set_para_value(2,'CASE_COMPATIBLE_MODE',0); ##5237 ./dminit path=/dmdata/data5237 page_size=32 extent_size=32 length_in_char=1 case_sensitive=0 charset=0 log_size=2048 port_num=5237 #guo初始化语句 ./dm_service_installer.sh -t dmserver -p DM5237 -dm_ini /dmdata/data5237/DAMENG/dm.ini #注册自启服务 //todo 1 先把5236 数据库 备份到/bak/20240311_5236_FULL.dmp ./dexp USERID=SYSDBA/SYSDBA@192.168.2.192:5236 FILE=/bak/20240311_5236_FULL.dmp LOG=/bak/20240311_5236_FULL.log FULL=Y ## ##./dimp USERID=SYSDBA/SYSDBA@192.168.2.193:5236 FILE=/media/rdf/c2fba3b2-3454-4f6d-b437-55e7dbb3c6ed/20240311_5236_FULL.dmp LOG=dimp5236.log FULL=Y DIRECTORY=/mnt/data/ ./dimp USERID=SYSDBA/SYSDBA@192.168.2.193:5237 FILE=/media/rdf/c2fba3b2-3454-4f6d-b437-55e7dbb3c6ed/20240229_5237_FULL.dmp LOG=dimp5237.log FULL=Y DIRECTORY=/dmdata/data5237/