Última atividade 1717640151

rdf revisou este gist 1717640151. Ir para a revisão

1 file changed, 26 insertions

DM(arquivo criado)

@@ -0,0 +1,26 @@
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/
Próximo Anterior