DM
· 1.2 KiB · Text
原始文件
./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/
| 1 | ./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 |
| 2 | #初始化语句 |
| 3 | |
| 4 | ./dm_service_installer.sh -t dmserver -p DM -dm_ini /dmdata/data/DAMENG/dm.ini |
| 5 | #注册自启服务 |
| 6 | |
| 7 | |
| 8 | #这个参数为0，且在参数修改后，新建的表，才能正常查询 |
| 9 | #专门处理isnull方法问题 |
| 10 | sp_set_para_value(2,'CASE_COMPATIBLE_MODE',0); |
| 11 | |
| 12 | |
| 13 | ##5237 |
| 14 | ./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 |
| 15 | #guo初始化语句 |
| 16 | |
| 17 | ./dm_service_installer.sh -t dmserver -p DM5237 -dm_ini /dmdata/data5237/DAMENG/dm.ini #注册自启服务 |
| 18 | |
| 19 | //todo |
| 20 | 1 先把5236 数据库 备份到/bak/20240311_5236_FULL.dmp |
| 21 | ./dexp USERID=SYSDBA/SYSDBA@192.168.2.192:5236 FILE=/bak/20240311_5236_FULL.dmp LOG=/bak/20240311_5236_FULL.log FULL=Y |
| 22 | |
| 23 | ## |
| 24 | ##./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/ |
| 25 | |
| 26 | ./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/ |
| 27 |