Revision of DM - Opengist

1 file changed, 26 insertions

DM(Datei erstellt)

		@@ -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/

Neuer Älter