- é
置信æ¯
- ä¿¡æ¯è¡¨
主æºå | ipï¼ç§ç½ï¼ | ipï¼å¤ç½ï¼ | å®ä¾å | æå¡ç«¯å£ | å¿è·³ç«¯å£ | å®æ¤çå¬ç«¯å£ | å®æ¤è¿ç¨ç«¯å£ |
dm-dw1 | 192.168.1.25 | 192.168.2.25 | DMWAT | 5236 | 5238 | 5237 | 5239 |
dm-dw2 | 192.168.1.26 | 192.168.2.26 | DMWAT2 | 5236 | 5238 | 5237 | 5239 |
dm-mon | 192.168.1.27 | 5239 |
-
- hosts表
192.168.1.25 dm-dw1 192.168.1.26 dm-dw2 192.168.1.27 dm-mon 192.168.2.25 dm-dw1-pub 192.168.2.26 dm-dw2-pub |
-
- æ¦å¿µè¯´æ
æå¡ç«¯å£ï¼å¯¹å¤æä¾æ°æ®åºæå¡ç端å£
å¿è·³ç«¯å£ï¼ç¨äºæ°æ®åæ¥ç端å£
å®æ¤çå¬ç«¯å£ï¼æ°æ®å®æ¤çå¬æ°æ®åºç端å£
å®æ¤è¿ç¨ç«¯å£ï¼datawatchæ¶éæ°æ®å®æ¤ä¿¡æ¯ç端å£
- åºç¡åå¤
- æ¶é´åæ¥
#èææºæ æä½ï¼ä» ä¿®æ¹äºæ¶åº timedatectl set-timezone Asia/Shanghai |
-
- åçæ¬è½¯ä»¶å®è£
æææ°æ®åºèç¹åéè¦å®è£ æ°æ®åºè½¯ä»¶
åå®ä¾éé»å®è£ 示è
#ç» groupadd dinstall #ç¨æ· useradd -g dinstall dmdba #ç®å½ mkdir -p /opt/dm8 chown dmdba:dinstall /opt/dm8 #ä»è´¨æè½½ mount dm8_20210818_x86_rh6_64_ent_8.4.2.18_pack14.iso /mnt cd /mnt #å®è£ [[email protected] mnt]$ ./DMInstall.bin -i Please select the installer's language (E/e:English C/c:Chinese) [E/e]: Extract install files.......... core file size         (blocks, -c) 0 data seg size          (kbytes, -d) unlimited scheduling priority            (-e) 0 file size              (blocks, -f) unlimited pending signals                (-i) 31096 max locked memory      (kbytes, -l) 64 max memory size        (kbytes, -m) unlimited open files                     (-n) 1024 pipe size           (512 bytes, -p) 8 POSIX message queues    (bytes, -q) 819200 real-time priority             (-r) 0 stack size             (kbytes, -s) 8192 cpu time              (seconds, -t) unlimited max user processes             (-u) 4096 virtual memory         (kbytes, -v) unlimited file locks                     (-x) unlimited The max number of open files is too little, suggest to set 65536 or more to number of open files. Welcome to DM DBMS Installer Whether to input the path of Key File? (Y/y:Yes N/n:No) [Y/y]:n Whether to Set The TimeZone? (Y/y:Yes N/n:No) [Y/y]:n Installation Type: 1 Typical 2 Server 3 Client 4 Custom Please Input the number of the Installation Type [1 Typical]: Require Space: 1178M Please Input the install path [/home/dmdba/dmdbms]:/opt/dm8 No write permission! Please Input the install path [/home/dmdba/dmdbms]:/opt/dm8 Available Space:47G Please Confirm the install path(/opt/dm8)? (Y/y:Yes N/n:No) [Y/y]:y Pre-Installation Summary Installation Location: /opt/dm8 Require Space: 1178M Available Space: 47G Version Information: Expire Date: Installation Type: Typical Confirm to Install? (Y/y:Yes N/n:No): Confirm to Install? (Y/y:Yes N/n:No):y 2022-08-26 16:24:15 [INFO] Installing DM DBMS... 2022-08-26 16:24:15 [INFO] Installing BASE Module... 2022-08-26 16:24:17 [INFO] Installing SERVER Module... 2022-08-26 16:24:18 [INFO] Installing CLIENT Module... 2022-08-26 16:24:19 [INFO] Installing DRIVERS Module... 2022-08-26 16:24:19 [INFO] Installing MANUAL Module... 2022-08-26 16:24:19 [INFO] Installing SERVICE Module... 2022-08-26 16:24:20 [INFO] Move log file to log directory. 2022-08-26 16:24:20 [INFO] Installed DM DBMS completely. Please execute the commands by root: /opt/dm8/script/root/root_installer.sh End [[email protected] mnt]$ exit logout [[email protected] soft]# /opt/dm8/script/root/root_installer.sh Move /opt/dm8/bin/dm_svc.conf to /etc Modify the files' mode of DM Server Create the DmAPService service Created symlink from /etc/systemd/system/multi-user.target.wants/DmAPService.service to /usr/lib/systemd/system/DmAPService.service. Finished to create the service (DmAPService) Start the DmAPService service #ç¯å¢åé vi /home/dmdba/.bash_profile export PATH=$PATH:$DM_HOME/bin #å¢å ä¸é¢ç¯å¢åé |
- æ建主å¤
- 主åºé¶æ®µ
- 主åºåå§å
- 主åºé¶æ®µ
#åå§åæ°æ®åº dminit PATH=/opt/dm8/data DB_NAME=dmwat INSTANCE_NAME=dmwat PORT_NUM=5236 PAGE_SIZE=32 EXTENT_SIZE=32 CHARSET=1 CASE_SENSITIVE=0 LENGTH_IN_CHAR=0 BLANK_PAD_MODE=1 #å次å¯å¨ dmserver /opt/dm8/data/dmwat/dm.ini â¦â¦. ctrl+c éåº #é ç½®æå¡åï¼å¯ä»¥ç¨DmService 管ç DmServicedmwat start |
-
-
- 主åºå¼å¯é ç½®å½æ¡£
-
#ç»å½ï¼éé»å®è£ å¯ä»¥ç¨ä»¥ä¸æ¹å¼ç»å½ disql sysdba #åæ¢å°mount alter database mount; #æ·»å å½æ¡£è·¯å¾ alter database add archivelog 'DEST=/opt/dm8/data/dmwat/arch,TYPE=local,FILE_SIZE=128,space_limit=0'; #å¼å¯å½æ¡£ alter database archivelog; #å¼å¯æ°æ®åº alter database open; #æ¥è¯¢å½æ¡£ç¶æ SQL> select arch_mode from v$database; LINEID    arch_mode ---------- --------- 1         Y |
-
-
- 主åºå¤ä»½
-
#å ³éæ°æ®åº DmServicedmwat stop #å¤ä»½æ°æ®åº RMAN> backup database '/opt/dm8/data/dmwat/dm.ini' full; backup database '/opt/dm8/data/dmwat/dm.ini' full; file dm.key not found, use default license! Database mode = 0, oguid = 0 Normal of FAST Normal of DEFAULT Normal of RECYCLE Normal of KEEP Normal of ROLL EP[0]'s cur_lsn[29710], file_lsn[29710] Processing backupset /opt/dm8/data/dmwat/bak/DB_dmwat_FULL_20220826_153412_280474                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    [Percent:100.00%][Speed:0.00M/s][Cost:00:00:00][Remaining:00:00:00] backup successfully! time used: 00:00:01.358 RMAN> |
-
-
- é ç½®æå¡ï¼å¯éï¼disableæï¼
-
#é ç½®æå¡ /opt/dm8/script/root/dm_service_installer.sh -t dmserver -dm_ini /opt/dm8/data/dmwat/dm.ini -p dmwat [[email protected] yum.repos.d]# /opt/dm8/script/root/dm_service_installer.sh -t dmserver -dm_ini /opt/dm8/data/dmwat/dm.ini -p dmwat Created symlink from /etc/systemd/system/multi-user.target.wants/DmServicedmwat.service to /usr/lib/systemd/system/DmServicedmwat.service. Finished to create the service (DmServicedmwat) [r[email protected] yum.repos.d]# systemctl enable DmServicedmwat.service [r[email protected] yum.repos.d]# systemctl status DmServicedmwat.service â DmServicedmwat.service - Dameng Database Service(DmServicedmwat).   Loaded: loaded (/usr/lib/systemd/system/DmServicedmwat.service; enabled; vendor preset: disabled)   Active: inactive (dead) [[email protected] yum.repos.d]# systemctl start DmServicedmwat.service [r[email protected] yum.repos.d]# systemctl status DmServicedmwat.service â DmServicedmwat.service - Dameng Database Service(DmServicedmwat).   Loaded: loaded (/usr/lib/systemd/system/DmServicedmwat.service; enabled; vendor preset: disabled)   Active: active (running) since Fri 2022-08-26 15:21:24 CST; 9s ago  Process: 2021 ExecStart=/opt/dm8/bin/DmServicedmwat start (code=exited, status=0/SUCCESS)  Main PID: 2045 (dmserver)   CGroup: /system.slice/DmServicedmwat.service           ââ2045 /opt/dm8/bin/dmserver /opt/dm8/data/dmwat/dm.ini -noconsol... Aug 26 15:21:09 dm-dw1.novalocal systemd[1]: Starting Dameng Database Servi.... Aug 26 15:21:24 dm-dw1.novalocal DmServicedmwat[2021]: [36B blob data] Aug 26 15:21:24 dm-dw1.novalocal systemd[1]: Started Dameng Database Servic.... Hint: Some lines were ellipsized, use -l to show in full. [ro[email protected] yum.repos.d]# systemctl disable DmServicedmwat.service |
-
- å¤åºé¶æ®µ
- åå§åå®ä¾
- å¤åºé¶æ®µ
dminit PATH=/opt/dm8/data DB_NAME=dmwat INSTANCE_NAME=dmwat2 PORT_NUM=5236Â PAGE_SIZE=32 EXTENT_SIZE=32 CHARSET=1 CASE_SENSITIVE=0 LENGTH_IN_CHAR=0 BLANK_PAD_MODE=1 |
-
-
- æ¢å¤å¤åº
-
#æ·è´å¤ä»½ [[email protected] bak]$ scp -r DB_dmwat_FULL_20220826_153412_280474 dm-dw2:/home/dmdba [email protected]'s password: DB_dmwat_FULL_20220826_153412_280474.bak    100%  16MB 63.2MB/s  00:00 DB_dmwat_FULL_20220826_153412_280474.meta   100%  77KB 16.4MB/s  00:00 #åå¤æ°æ®åº dmrman restore database '/opt/dm8/data/dmwat/dm.ini' from backupset '/home/dmdba/DB_dmwat_FULL_20220826_153412_280474'; recover database '/opt/dm8/data/dmwat/dm.ini' from backupset '/home/dmdba/DB_dmwat_FULL_20220826_153412_280474'; recover database '/opt/dm8/data/dmwat/dm.ini' update db_magic; |
-
-
- é ç½®æå¡ï¼å¯éï¼disableæï¼
-
#é ç½®æå¡ /opt/dm8/script/root/dm_service_installer.sh -t dmserver -dm_ini /opt/dm8/data/dmwat/dm.ini -p dmwat #disableæå¡ [ro[email protected] yum.repos.d]# systemctl disable DmServicedmwat.service |
-
- é
ç½®é¶æ®µ
- é ç½®åæ°æ件dm.ini
- é
ç½®é¶æ®µ
主å¤åä¿®æ¹
vi /opt/dm8/data/dmwat/dm.ini |
主åº
INSTANCE_NAMEÂ Â Â Â Â Â Â Â Â Â Â =DMWAT MAL_INIÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â =1 ARCH_INI Â Â Â Â Â Â Â =1 PORT_NUM Â Â Â Â Â =5236 ALTER_MODE_STATUSÂ Â Â =0 ENABLE_OFFLINE_TSÂ Â Â Â Â =2 |
å¤åº
INSTANCE_NAMEÂ Â Â Â Â Â Â Â Â Â Â =DMWAT2 MAL_INIÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â =1 ARCH_INI Â Â Â Â Â Â Â =1 PORT_NUM Â Â Â Â Â =5236 ALTER_MODE_STATUSÂ Â Â =0 ENABLE_OFFLINE_TSÂ Â Â Â Â =2 |
-
-
- é ç½®åæ°æ件dmmal.ini
-
主å¤åä¿®æ¹ï¼ä¸»å¤ä¸è´
vi /opt/dm8/data/dmwat/dmmal.ini |
主å¤ä¸è´
[MAL_INST1] MAL_INST_NAME = DMWATÂ Â Â Â Â Â Â Â MAL_HOST = 192.168.1.25Â Â Â Â MAL_PORT = 5238Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â MAL_DW_PORT = 5239Â Â Â Â Â Â Â Â Â Â Â Â Â MAL_INST_HOST = 192.168.2.25Â Â MAL_INST_PORT = 5236Â Â Â Â Â Â Â Â Â Â Â MAL_INST_DW_PORT = 5237Â Â Â Â Â [MAL_INST2] MAL_INST_NAME = DMWAT2Â Â Â Â Â Â Â Â MAL_HOST = 192.168.1.26Â Â Â Â MAL_PORT = 5238Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â MAL_DW_PORT = 5239Â Â Â Â Â Â Â Â Â Â Â Â Â MAL_INST_HOST = 192.168.2.26Â Â MAL_INST_PORT = 5236Â Â Â Â Â Â Â Â Â Â Â MAL_INST_DW_PORT = 5237Â |
-
-
- é ç½®åæ°æ件dmarch.ini
-
主å¤åä¿®æ¹
vi /opt/dm8/data/dmwat/dmarch.ini |
主åº
#DaMeng Database Archive Configuration file #this is comments [ARCHIVE_LOCAL1]        ARCH_TYPE           = LOCAL        ARCH_DEST           = /opt/dm8/data/dmwat/arch        ARCH_FILE_SIZE      = 128        ARCH_SPACE_LIMIT    = 0        ARCH_FLUSH_BUF_SIZE = 0 [ARCHIVE_REALTIME]        ARCH_TYPE      = REALTIME        ARCH_DEST      = DMWAT2 |
å¤åº
#DaMeng Database Archive Configuration file #this is comments [ARCHIVE_LOCAL1]        ARCH_TYPE           = LOCAL        ARCH_DEST           = /opt/dm8/data/dmwat/arch        ARCH_FILE_SIZE      = 128        ARCH_SPACE_LIMIT    = 0        ARCH_FLUSH_BUF_SIZE = 0 [ARCHIVE_REALTIME]        ARCH_TYPE      = REALTIME        ARCH_DEST      = DMWAT |
-
- åæ¥é¶æ®µ
- å¯å¨ä¸»å¤åºå°mount
- åæ¥é¶æ®µ
å¯å¨æ°æ®åºå°mount
#ä¸»åº DmServicedmwat start mount #å¤åº DmServicedmwat start mount |
-
-
- 设置oguidä¸æ°æ®åºè§è²
-
主åº
[[email protected] dmwat]$ disql sysdba Server[LOCALHOST:5236]:mode is normal, state is mount login used time : 3.867(ms) disql V8 SQL> sp_set_oguid(3721886); DMSQL executed successfully used time: 18.406(ms). Execute id is 0. SQL>alter database parimary; |
å¤åº
[[email protected] ~]$ disql sysdba Server[LOCALHOST:5236]:mode is normal, state is mount login used time : 4.093(ms) disql V8 SQL> SQL> sp_set_oguid(3721886); DMSQL executed successfully used time: 19.548(ms). Execute id is 0. SQL> alter database standby; SQL> |
-
-
- å ³é主å¤åº
-
- æ建datawatch
- é ç½®åæ°æ件dmwatch.ini
主å¤ä¿®æ¹dmwatch.iniï¼ä¸»å¤ä¸è´
vi /opt/dm8/data/dmwat/dmwatch.ini |
主å¤ä¸è´
 [GRP1] DW_TYPE = GLOBAL                           DW_MODE = MANUAL                           DW_ERROR_TIME = 10                         INST_RECOVER_TIME = 60                     INST_ERROR_TIME = 10                       INST_OGUID = 3721886                        INST_INI = /opt/dm8/data/dmwat/dm.ini     INST_AUTO_RESTART = 1                     INST_STARTUP_CMD = /opt/dm8/bin/dmserver   RLOG_SEND_THRESHOLD = 0                    RLOG_APPLY_THRESHOLD = 0       |
设置oguidï¼sp_set_oguid(3721886) ä¸è´ |
-
- é ç½®datawatchæå¡
主å¤åºåé 置该æå¡ï¼ç±è¯¥æå¡æ¥å¯åæ°æ®åº
#主å¤ä¸è´ /opt/dm8/script/root/dm_service_installer.sh -t dmwatcher -watcher_ini /opt/dm8/data/dmwat/dmwatcher.ini -p mon |
-
- é ç½®datawatchçæ§å°
å¨dm-monä¸é ç½®
é ç½®çæ§å°åæ°
[[email protected] data]$ mkdir -p /opt/dm8/data/dmmon [[email protected] data]$ cd /opt/dm8/data/dmmon [[email protected] mon]$ vi dmmonitor.ini |
åæ°é ç½®
MON_DW_CONFIRM = 1                  MON_LOG_PATH = /opt/dm8/log         MON_LOG_INTERVAL = 60               MON_LOG_FILE_SIZE = 32             MON_LOG_SPACE_LIMIT = 0             [GRP1] MON_INST_OGUID = 3721886            MON_DW_IP = 192.168.1.25:5239 MON_DW_IP = 192.168.1.26:5239 |
ä¸è®¾ç½®oguidï¼sp_set_oguid(3721886) ä¸è´ |
使ç¨dmmonitorçæ§
[[email protected] data]$ dmmonitor /opt/dm8/data/dmmon/dmmonitor.ini [monitor]        2022-08-26 16:49:43: DMMONITOR[4.0] V8 [monitor]        2022-08-26 16:49:43: DMMONITOR[4.0] IS READY. Input command illegal, please input help to get the help information! Input command illegal, please input help to get the help information! [monitor]        2022-08-26 16:54:38: Received message from(DMWAT2) [monitor]        2022-08-26 16:54:46: Received message from(DMWAT) |
-
- 使ç¨datawatchæå¡å¯å¨ä¸»å¤
å ³é主å¤åº
#å å ³éæ°æ®åº DmServicedmwat stop |
å¯å¨watcheræå¡
#å¯å¨datawatchæå¡ systemctl start DmWatcherServicemon |
- éªè¯åæ¥
- datawatchéªè¯
çæ§å°å½ä»¤ï¼dm-monä¸
[[email protected] data]$ dmmonitor /opt/dm8/data/dmmon/dmmonitor.ini [monitor]        2022-08-26 16:49:43: DMMONITOR[4.0] V8 [monitor]        2022-08-26 16:49:43: DMMONITOR[4.0] IS READY. Input command illegal, please input help to get the help information! Input command illegal, please input help to get the help information! [monitor]        2022-08-26 16:54:38: Received message from(DMWAT2) [monitor]        2022-08-26 16:54:46: Received message from(DMWAT) show global info 2022-08-26 16:57:19 #================================================================================# GROUP           OGUID      MON_CONFIRM    MODE           MPP_FLAG GRP1            3721886    TRUE           MANUAL         FALSE <<DATABASE GLOBAL INFO:>> DW_IP              MAL_DW_PORT WTIME               WTYPE    WCTLSTAT WSTATUS       INAME           INST_OK  N_EP N_OK ISTATUS    IMODE    DSC_STATUS    RTYPE    RSTAT 192.168.1.25       5239        2022-08-26 16:57:18 GLOBAL   VALID    OPEN          DMWAT           OK       1    1    OPEN       PRIMARY  DSC_OPEN      REALTIME VALID DW_IP              MAL_DW_PORT WTIME               WTYPE    WCTLSTAT WSTATUS       INAME           INST_OK  N_EP N_OK ISTATUS    IMODE    DSC_STATUS    RTYPE    RSTAT 192.168.1.26       5239        2022-08-26 16:57:18 GLOBAL   VALID    OPEN          DMWAT2          OK       1    1    OPEN       STANDBY  DSC_OPEN      REALTIME VALID #================================================================================# ####该çé¢å¯éæ¶éåºï¼åªæ¯ä¸ªçæ§çé¢è¾åº |
-
- sqléªè¯
建表éªè¯
##ä¸»åº SQL> create table wzy(x int); executed successfully used time: 20.814(ms). Execute id is 304. SQL> insert into wzy values(123); affect rows 1 used time: 1.402(ms). Execute id is 305. SQL> commit; executed successfully used time: 3.339(ms). Execute id is 306. SQL> select mode$ from v$instance; LINEID    mode$ ---------- ------- 1         PRIMARY ##å¤åº SQL> select * from wzy; LINEID    x ---------- ----------- 1         123 used time: 3.325(ms). Execute id is 1. SQL> insert into wzy values(321); insert into wzy values(321); [-2018]:Error in line: 1 Try to insert/update/delete table table is not temporary or contains lob on standby mode. used time: 0.624(ms). Execute id is 0. SQL> select mode$ from v$instance; LINEID    mode$ ---------- ------- 1         STANDBY ------ |