一、环境检查
1、本次示例环境：
1）CPU：x86
2）操作系统：麒麟 10
安装前需要检查操作系统内核版本和CPU架构是否匹配
2、环境检查
1）操作系统内核版本
[dmdba@localhost root]$ uname -a
Linux localhost.localdomain 4.19.90-24.4.v2101.ky10.x86_64 #1 SMP Mon May 24 12:14:55 CST 2021 x86_64 x86_64 x86_64 GNU/Linux
[dmdba@localhost root]$ uname -srm
Linux 4.19.90-24.4.v2101.ky10.x86_64 x86_64
2）检查CPU架构
[dmdba@localhost root]$ lscpu
架构： x86_64
CPU 运行模式： 32-bit, 64-bit
字节序： Little Endian
Address sizes: 45 bits physical, 48 bits virtual
CPU: 1
在线 CPU 列表： 0
每个核的线程数： 1
每个座的核数： 1
座： 1
NUMA 节点： 1
厂商 ID： GenuineIntel
CPU 系列： 6
型号： 186
型号名称： 13th Gen Intel(R) Core(TM) i5-1340P
步进： 2
CPU MHz： 2188.809
BogoMIPS： 4377.61
超管理器厂商： VMware
虚拟化类型： 完全
L1d 缓存： 48 KiB
L1i 缓存： 32 KiB
L2 缓存： 1.3 MiB
L3 缓存： 12 MiB
NUMA 节点0 CPU： 0
Vulnerability Itlb multihit: Not affected
Vulnerability L1tf: Mitigation; PTE Inversion
Vulnerability Mds: Mitigation; Clear CPU buffers; SMT Host state unknown
Vulnerability Meltdown: Mitigation; PTI
Vulnerability Spec store bypass: Mitigation; Speculative Store Bypass disabled via prctl and seccomp
Vulnerability Spectre v1: Mitigation; usercopy/swapgs barriers and __user pointer sanitization
Vulnerability Spectre v2: Mitigation; Full generic retpoline, IBPB conditional, IBRS_FW, STIBP disabled,
RSB filling
Vulnerability Srbds: Not affected
Vulnerability Tsx async abort: Not affected
标记： fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush
mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon re
p_good nopl xtopology tsc_reliable nonstop_tsc cpuid pni pclmulqdq ssse3 fma cx
16 pcid sse4_1 sse4_2 x2apic movbe popcnt aes xsave avx f16c rdrand hypervisor
lahf_lm abm 3dnowprefetch invpcid_single pti ssbd ibrs ibpb stibp fsgsbase tsc_
adjust bmi1 avx2 smep bmi2 erms invpcid rdseed adx smap clflushopt clwb sha_ni
xsaveopt xsavec xgetbv1 xsaves arat umip gfni vaes vpclmulqdq rdpid md_clear fl
ush_l1d arch_capabilities
[dmdba@localhost root]$
3）检查当前数据库版本
SQL> select id_code;
行号 ID_CODE
---------- ------------------------------------------
1 --03134284132-20240507-227386-20081 Pack21
已用时间: 17.427(毫秒). 执行号:802.
4）检查数据库配置路径
[root@localhost ~]# ps -elf | grep dmdba
0 S dmdba 1020 1 0 80 0 - 861167 - 22:12 ? 00:00:08 /home/dmdba/dmdbms/bin/dmserver path=/dmdata/data/DMSERVER/dm.ini -noconsole
0 S dmdba 1022 1 0 80 0 - 34336 - 22:12 ? 00:00:00 /home/dmdba/dmdbms/bin/dmap
0 R root 1683 1505 0 80 0 - 53288 - 22:30 pts/0 00:00:00 grep dmdba
[root@localhost ~]#
5）检查DMAP服务
[root@localhost ~]# ps -elf|grep dmap
0 S dmdba 1022 1 0 80 0 - 34336 - 22:12 ? 00:00:00 /home/dmdba/dmdbms/bin/dmap
0 R root 1685 1505 0 80 0 - 53288 - 22:32 pts/0 00:00:00 grep dmap
[root@localhost ~]#6）检查是否开启归档
v$arch_status视图状态时VALID代表数据库已经开启归档
SQL> select * from v$arch_status;
行号 ARCH_TYPE ARCH_DEST ARCH_STATUS ARCH_SRC
---------- --------- ------------ ----------- --------
1 LOCAL /dmdata/arch VALID DBSERVER
已用时间: 5.082(毫秒). 执行号:601.
SQL>二、新版本安装包准备
1、将安装包.iso文件放置在服务器任意目录下
[root@localhost ~]# cd /opt
[root@localhost opt]# ls
'dm8_20240529_x86_kylin10_64_ent_8.1.3.100_pack21 (1).iso'
dm8_20240703_x86_kylin10_64.iso
patch_workspace
unixODBC-2.3.0
unixODBC-2.3.0.tar.gz2、用root用户挂在iso安装包文件到/mnt目录下
[root@localhost opt]# mount -o loop dm8_20240703_x86_kylin10_64.iso /mnt
mount: /mnt: WARNING: source write-protected, mounted read-only.三、停止旧版数据库服务
[dmdba@localhost bin]$ ./DmServiceDMSERVER stop
Stopping DmServiceDMSERVER: [ OK ]
[dmdba@localhost bin]$ ./DmServiceDMSERVER status
DmServiceDMSERVER is stopped
[dmdba@localhost bin]$四、脱机备份旧版本
1、创建备份文件夹
[root@localhost ~]# mkdir -p /dm/backup/
[root@localhost ~]# chown -R dmdba:dinstall /dm
[root@localhost ~]# ls -ltr /dm
总用量 0
drwxr-xr-x 2 dmdba dinstall 43 7月 20 19:51 backup
[root@localhost ~]#
2、执行脱机备份
[root@localhost ~]# su dmdba
[dmdba@localhost root]$ cd /home/dmdba/dmdbms/bin
[dmdba@localhost bin]$ ./dmrman
dmrman V8
RMAN> backup database '/dmdata/data/DMSERVER/dm.ini' backupset '/dm/backup';
backup database '/dmdata/data/DMSERVER/dm.ini' backupset '/dm/backup';
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[43000], file_lsn[43000]
Processing backupset /dm/backup
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:11][Remaining:00:00:00]
backup successfully!
time used: 00:00:13.129
RMAN>3、备份旧版本bin目录
打包数据库安装目录下旧版本bin目录：
[dmdba@localhost bin]$ cd /home/dmdba/dmdbms/
[dmdba@localhost dmdbms]$ tar -zcvf bin_old bin
bin/
bin/OPENSSL_VERSION
bin/SYSWORD.UTF8.LIB
bin/client_ssl/
bin/client_ssl/DEVELOP/
bin/client_ssl/DEVELOP/.keystore
bin/client_ssl/DEVELOP/ca-cert.pem
bin/client_ssl/DEVELOP/client-cert.pem
...4、备份数据库安装目录下旧版本bin目录
[dmdba@localhost dmdbms]$ mv bin/ ./bin_old5、备份数据库实例
[dmdba@localhost data]$ cp -r DAMENG DAMENG202408016、备份数据库安装目录
[dmdba@localhost ~]$ mv dmdbms dmdbms20240801五、安装新版本
[root@localhost ~]# su dmdba
[dmdba@localhost root]$ cd /mnt
[dmdba@localhost mnt]$ ls
'DM8 Install.pdf' DMInstall.bin
[dmdba@localhost mnt]$ ./DMInstall.bin -i六、启动新版本数据库
[dmdba@localhost bin]$ ./DmServiceDMSERVER start
Starting DmServiceDMSERVER: [ OK ]
[dmdba@localhost bin]$七、查看数据库版本
SQL> select id_code;
行号 ID_CODE
---------- -----------------------------------
1 --05134284194-20240621-232765-20108
已用时间: 1.431(毫秒). 执行号:501.
SQL>
扫一扫
2449
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
