达梦数据库 | 教程 | 5.开启归档模式
概述
达梦数据库可以运行在归档状态或者非归档状态下;
如果运行在归档模式,那么联机日志中的内容会以归档日志的形式保存在硬盘中;
如果运行在非归档模式,那么联机日志文件中的内容不会在日志切换的时候形成归档日志,而是会因为联机日志的循环写,而丢失。
采用归档模式会对系统的性能造成些许的影响,但是数据库运行在归档模式下,数据会更加安全。
当出现故障的时候,数据丢失的可能性会更小,因为一旦出现介质故障(如:磁盘损坏)时,可以利用归档日志,将数据库恢复到发生故障的前一刻,也可以指定时间点还原;而如果没有昂日志,则只能利用备份文件进行还原。
需要配置归档的场景:
当你需要联机备份数据库的时候,你必须要将数据库设置为归档模式;
联机备份的时候,大量的事务处于活动状态,为了确保备份数据的一致性:
- 备份数据库
- 备份数据库过程中,还会产生一系列的REDO日志;这段时间内的REDO日志产生的归档也需要备份
因此,数据库必须配置为:
- 本地归档
- 归档状态:开启
属于联机备份的:
- 备份表空间
- 备份表(虽然这个也属于联机完全备份,但是不需要配置归档;因为表在还原之后,不需要再进行恢复操作,所以用不到归档日志,也就不需要配置归档模式)
- 备份归档日志(必须配置归档)
脱机备份的时候,数据库可以配置为归档模式,也可以不用配置归档模式;
正常退出库的备份不需要考虑本地归档日志的完整性,因此不需要配置归档模式;
对于由于故障退出的库的备份,则由于要求备份,因故障导致没有来得及刷盘的REDO日志,所以必须要配制归档;
如果本地归档缺失,则需要:
- 修复归档
- 再备份
查看数据库的归档状态
首先,检查当前达梦数据库的归档状态
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
[root@node1 ~]# ps -ef | grep dmserver root 82407 81628 0 00:30 pts/2 00:00:00 grep --color=auto dmserver [root@node1 ~]# [root@node1 ~]# service DmServiceDMSERVER start Redirecting to /bin/systemctl start DmServiceDMSERVER.service [root@node1 ~]# [root@node1 ~]# su - dmdba Last login: Wed Jul 14 20:30:10 PDT 2021 on pts/2 [dmdba@node1 ~]$ [dmdba@node1 ~]$ disql disql V8 username:sysdba password: Server[LOCALHOST:5236]:mode is normal, state is open login used time : 4.291(ms) SQL> SQL> select name,arch_mode from v$database; LINEID NAME ARCH_MODE ---------- ------ --------- 1 DAMENG N used time: 4.080(ms). Execute id is 4. SQL> |
可以看到,当前达梦数据库是处于:非归档状态的
配置归档
在达梦数据库中,与归档模式相关的配置文件有两个:
- dm.ini
- dmarch.ini
归档配置有两种方式:
- 联机归档配置
- 手动配置归档
联机归档配置
在数据库实例启动的情况下,使用SQL语句完成配置:
- 对dm.ini中的ARCH_INI的配置
- 对dmarch.ini的配置
开始配置:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 |
[root@node1 DAMENG]# ls -ltr total 334840 drwxr-xr-x 2 dmdba dinstall 6 Jul 14 20:04 bak -rw-r--r-- 1 dmdba dinstall 479 Jul 14 20:04 sqllog.ini -rw-r--r-- 1 dmdba dinstall 633 Jul 14 20:04 dm_service.prikey drwxr-xr-x 2 dmdba dinstall 6 Jul 14 20:04 HMAIN -rw-r--r-- 1 dmdba dinstall 853 Jul 14 20:04 dminit20210714200402.log drwxr-xr-x 2 dmdba dinstall 6 Jul 14 20:07 trace -rw-r--r-- 1 dmdba dinstall 12 Jul 14 20:07 rep_conflict.log -rw-r--r-- 1 dmdba dinstall 134217728 Jul 14 20:08 DMHR.DBF -rw-r--r-- 1 dmdba dinstall 157286400 Jul 14 20:08 BOOKSHOP.DBF -rw-r--r-- 1 dmdba dinstall 134217728 Jul 14 20:12 MAIN.DBF -rw-r--r-- 1 dmdba dinstall 701 Jul 15 01:30 dmarch.ini_old_20210715 -rw-r--r-- 1 dmdba dinstall 49826 Jul 15 01:42 dm.ini -rw-r--r-- 1 dmdba dinstall 10485760 Jul 15 01:50 TEMP.DBF -rw-r--r-- 1 dmdba dinstall 6144 Jul 15 01:50 dm.ctl drwxr-xr-x 2 dmdba dinstall 4096 Jul 15 01:50 ctl_bak -rw-r--r-- 1 dmdba dinstall 24117248 Jul 15 01:51 SYSTEM.DBF -rw-r--r-- 1 dmdba dinstall 134217728 Jul 15 01:51 ROLL.DBF -rw-r--r-- 1 dmdba dinstall 268435456 Jul 15 01:51 DAMENG02.log -rw-r--r-- 1 dmdba dinstall 268435456 Jul 15 01:51 DAMENG01.log [root@node1 DAMENG]# [root@node1 DAMENG]# ps -ef | grep dmserver root 84232 81628 0 01:51 pts/2 00:00:00 grep --color=auto dmserver [root@node1 DAMENG]# [root@node1 DAMENG]# service DmServiceDMSERVER status Redirecting to /bin/systemctl status DmServiceDMSERVER.service ● DmServiceDMSERVER.service - DM database instance service Loaded: loaded (/usr/lib/systemd/system/DmServiceDMSERVER.service; enabled; vendor preset: disabled) Active: inactive (dead) since Thu 2021-07-15 01:51:35 PDT; 22s ago Process: 84176 ExecStop=/opt/dmdbms/bin/DmServiceDMSERVER stop (code=exited, status=0/SUCCESS) Process: 84057 ExecStart=/opt/dmdbms/bin/DmServiceDMSERVER start (code=exited, status=0/SUCCESS) Main PID: 84082 (code=exited, status=0/SUCCESS) Jul 15 01:50:31 node1 systemd[1]: Starting DM database instance service... Jul 15 01:50:46 node1 DmServiceDMSERVER[84057]: [39B blob data] Jul 15 01:50:46 node1 systemd[1]: Started DM database instance service. Jul 15 01:51:30 node1 systemd[1]: Stopping DM database instance service... Jul 15 01:51:35 node1 DmServiceDMSERVER[84176]: [39B blob data] Jul 15 01:51:35 node1 systemd[1]: Stopped DM database instance service. [root@node1 DAMENG]# [root@node1 DAMENG]# service DmServiceDMSERVER start Redirecting to /bin/systemctl start DmServiceDMSERVER.service [root@node1 DAMENG]# [root@node1 DAMENG]# ps -ef | grep dmserver dmdba 84286 1 0 01:52 ? 00:00:00 /opt/dmdbms/bin/dmserver /data/dameng/DAMENG/dm.ini -noconsole root 84364 81628 0 01:52 pts/2 00:00:00 grep --color=auto dmserver [root@node1 DAMENG]# [root@node1 DAMENG]# service DmServiceDMSERVER status Redirecting to /bin/systemctl status DmServiceDMSERVER.service ● DmServiceDMSERVER.service - DM database instance service Loaded: loaded (/usr/lib/systemd/system/DmServiceDMSERVER.service; enabled; vendor preset: disabled) Active: active (running) since Thu 2021-07-15 01:52:15 PDT; 10s ago Process: 84176 ExecStop=/opt/dmdbms/bin/DmServiceDMSERVER stop (code=exited, status=0/SUCCESS) Process: 84260 ExecStart=/opt/dmdbms/bin/DmServiceDMSERVER start (code=exited, status=0/SUCCESS) Main PID: 84286 (dmserver) Tasks: 51 CGroup: /system.slice/DmServiceDMSERVER.service └─84286 /opt/dmdbms/bin/dmserver /data/dameng/DAMENG/dm.ini -noconsole Jul 15 01:52:00 node1 systemd[1]: Starting DM database instance service... Jul 15 01:52:15 node1 DmServiceDMSERVER[84260]: [39B blob data] Jul 15 01:52:15 node1 systemd[1]: Started DM database instance service. [root@node1 DAMENG]# [root@node1 DAMENG]# su - dmdba Last login: Thu Jul 15 01:43:26 PDT 2021 on pts/2 [dmdba@node1 ~]$ [dmdba@node1 ~]$ disql disql V8 username:sysdba password: Server[LOCALHOST:5236]:mode is normal, state is open login used time : 4.134(ms) SQL> SQL> select name,arch_mode from v$database; LINEID NAME ARCH_MODE ---------- ------ --------- 1 DAMENG N used time: 2.173(ms). Execute id is 4. SQL> SQL> select name,instance_name,start_time,status$ from v$instance; LINEID NAME INSTANCE_NAME ---------- -------- ------------- START_TIME ---------------------------------------------------------------------------------------------------- STATUS$ ------- 1 DMSERVER DMSERVER 2021-07-15 01:52:00 OPEN used time: 0.637(ms). Execute id is 7. SQL> |
将数据库修改为MOUNT状态:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
SQL> alter database mount; executed successfully used time: 00:00:01.784. Execute id is 0. SQL> SQL> select name,instance_name,start_time,status$ from v$instance; LINEID NAME INSTANCE_NAME ---------- -------- ------------- START_TIME ---------------------------------------------------------------------------------------------------- STATUS$ ------- 1 DMSERVER DMSERVER 2021-07-15 01:52:00 MOUNT used time: 0.447(ms). Execute id is 8. SQL> |
然后,配置数据库:本地归档
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 |
SQL> alter database add archivelog 'dest=/data/dameng/arch, type=local, file_size=1024, space_limit=2048'; executed successfully used time: 0.710(ms). Execute id is 0. SQL> SQL> alter database archivelog; executed successfully used time: 2.610(ms). Execute id is 0. SQL> SQL> select name,instance_name,start_time,status$ from v$instance; LINEID NAME INSTANCE_NAME ---------- -------- ------------- START_TIME ---------------------------------------------------------------------------------------------------- STATUS$ ------- 1 DMSERVER DMSERVER 2021-07-15 01:52:00 MOUNT used time: 0.303(ms). Execute id is 9. SQL> SQL> alter database open; executed successfully used time: 00:00:01.765. Execute id is 0. SQL> SQL> select name,instance_name,start_time,status$ from v$instance; LINEID NAME INSTANCE_NAME ---------- -------- ------------- START_TIME ---------------------------------------------------------------------------------------------------- STATUS$ ------- 1 DMSERVER DMSERVER 2021-07-15 01:52:00 OPEN used time: 0.183(ms). Execute id is 11. SQL> SQL> select name,arch_mode from v$database; LINEID NAME ARCH_MODE ---------- ------ --------- 1 DAMENG Y used time: 0.486(ms). Execute id is 12. SQL> |
看看数据库的数据目录中的变化:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
[dmdba@node1 DAMENG]$ ls -ltr total 335256 drwxr-xr-x 2 dmdba dinstall 6 Jul 14 20:04 bak -rw-r--r-- 1 dmdba dinstall 479 Jul 14 20:04 sqllog.ini -rw-r--r-- 1 dmdba dinstall 633 Jul 14 20:04 dm_service.prikey drwxr-xr-x 2 dmdba dinstall 6 Jul 14 20:04 HMAIN -rw-r--r-- 1 dmdba dinstall 853 Jul 14 20:04 dminit20210714200402.log drwxr-xr-x 2 dmdba dinstall 6 Jul 14 20:07 trace -rw-r--r-- 1 dmdba dinstall 12 Jul 14 20:07 rep_conflict.log -rw-r--r-- 1 dmdba dinstall 134217728 Jul 14 20:08 DMHR.DBF -rw-r--r-- 1 dmdba dinstall 157286400 Jul 14 20:08 BOOKSHOP.DBF -rw-r--r-- 1 dmdba dinstall 134217728 Jul 14 20:12 MAIN.DBF -rw-r--r-- 1 dmdba dinstall 701 Jul 15 01:30 dmarch.ini_old_20210715 -rw-r--r-- 1 dmdba dinstall 10485760 Jul 15 01:52 TEMP.DBF -rw-r--r-- 1 dmdba dinstall 268435456 Jul 15 01:52 DAMENG02.log -rw-r--r-- 1 dmdba dinstall 6144 Jul 15 01:52 dm.ctl drwxr-xr-x 2 dmdba dinstall 4096 Jul 15 01:52 ctl_bak -rw-r--r-- 1 dmdba dinstall 243 Jul 15 02:01 dmarch.ini -rw-r--r-- 1 dmdba dinstall 49831 Jul 15 02:01 dm.ini -rw-r--r-- 1 dmdba dinstall 24117248 Jul 15 02:02 SYSTEM.DBF -rw-r--r-- 1 dmdba dinstall 134217728 Jul 15 02:02 ROLL.DBF -rw-r--r-- 1 dmdba dinstall 268435456 Jul 15 02:02 DAMENG01.log [dmdba@node1 DAMENG]$ [dmdba@node1 DAMENG]$ cat dmarch.ini #DaMeng Database Archive Configuration file #this is comments [ARCHIVE_LOCAL1] ARCH_TYPE = LOCAL ARCH_DEST = /data/dameng/arch ARCH_FILE_SIZE = 1024 ARCH_SPACE_LIMIT = 2048 [dmdba@node1 DAMENG]$ |
可以从结果看到,数据库实例已经被设置为了:本地归档。
并且,自动创建了一个归档的配置文件:dmarch.ini。
手动归档配置
在数据库实例没有启动的情况下,手动完成配置:
- 对dm.ini的ARCH_INI的配置
- 对dmarch.ini的配置
dm.ini中需要打开归档参数:ARCH_INI,设置为1
首先,停掉达梦数据库实例:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 |
[root@node1 ~]# service DmServiceDMSERVER status Redirecting to /bin/systemctl status DmServiceDMSERVER.service ● DmServiceDMSERVER.service - DM database instance service Loaded: loaded (/usr/lib/systemd/system/DmServiceDMSERVER.service; enabled; vendor preset: disabled) Active: active (running) since Thu 2021-07-15 00:30:21 PDT; 18min ago Process: 82201 ExecStop=/opt/dmdbms/bin/DmServiceDMSERVER stop (code=exited, status=0/SUCCESS) Process: 82425 ExecStart=/opt/dmdbms/bin/DmServiceDMSERVER start (code=exited, status=0/SUCCESS) Main PID: 82450 (dmserver) Tasks: 51 CGroup: /system.slice/DmServiceDMSERVER.service └─82450 /opt/dmdbms/bin/dmserver /data/dameng/DAMENG/dm.ini -noconsole Jul 15 00:30:06 node1 systemd[1]: Starting DM database instance service... Jul 15 00:30:21 node1 DmServiceDMSERVER[82425]: [39B blob data] Jul 15 00:30:21 node1 systemd[1]: Started DM database instance service. [root@node1 ~]# [root@node1 ~]# service DmServiceDMSERVER stop Redirecting to /bin/systemctl stop DmServiceDMSERVER.service [root@node1 ~]# [root@node1 ~]# service DmServiceDMSERVER status Redirecting to /bin/systemctl status DmServiceDMSERVER.service ● DmServiceDMSERVER.service - DM database instance service Loaded: loaded (/usr/lib/systemd/system/DmServiceDMSERVER.service; enabled; vendor preset: disabled) Active: inactive (dead) since Thu 2021-07-15 00:49:15 PDT; 3s ago Process: 82763 ExecStop=/opt/dmdbms/bin/DmServiceDMSERVER stop (code=exited, status=0/SUCCESS) Process: 82425 ExecStart=/opt/dmdbms/bin/DmServiceDMSERVER start (code=exited, status=0/SUCCESS) Main PID: 82450 (code=exited, status=0/SUCCESS) Jul 15 00:30:06 node1 systemd[1]: Starting DM database instance service... Jul 15 00:30:21 node1 DmServiceDMSERVER[82425]: [39B blob data] Jul 15 00:30:21 node1 systemd[1]: Started DM database instance service. Jul 15 00:49:10 node1 systemd[1]: Stopping DM database instance service... Jul 15 00:49:15 node1 DmServiceDMSERVER[82763]: [39B blob data] Jul 15 00:49:15 node1 systemd[1]: Stopped DM database instance service. [root@node1 ~]# [root@node1 ~]# ps -ef | grep dmserver root 82835 81628 0 00:49 pts/2 00:00:00 grep --color=auto dmserver [root@node1 ~]# |
可以看到,达梦数据库的实例已经停止了。
修改文件:dm.ini中的参数:ARCH_INI
查看:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
[root@node1 ~]# cd /data/dameng/DAMENG/ [root@node1 DAMENG]# ls -ltr total 334304 drwxr-xr-x 2 dmdba dinstall 6 Jul 14 20:04 bak -rw-r--r-- 1 dmdba dinstall 479 Jul 14 20:04 sqllog.ini -rw-r--r-- 1 dmdba dinstall 633 Jul 14 20:04 dm_service.prikey drwxr-xr-x 2 dmdba dinstall 6 Jul 14 20:04 HMAIN -rw-r--r-- 1 dmdba dinstall 853 Jul 14 20:04 dminit20210714200402.log -rw-r--r-- 1 dmdba dinstall 49826 Jul 14 20:04 dm.ini drwxr-xr-x 2 dmdba dinstall 6 Jul 14 20:07 trace -rw-r--r-- 1 dmdba dinstall 12 Jul 14 20:07 rep_conflict.log -rw-r--r-- 1 dmdba dinstall 134217728 Jul 14 20:08 DMHR.DBF -rw-r--r-- 1 dmdba dinstall 157286400 Jul 14 20:08 BOOKSHOP.DBF -rw-r--r-- 1 dmdba dinstall 134217728 Jul 14 20:12 MAIN.DBF -rw-r--r-- 1 dmdba dinstall 10485760 Jul 15 00:30 TEMP.DBF -rw-r--r-- 1 dmdba dinstall 6144 Jul 15 00:30 dm.ctl drwxr-xr-x 2 dmdba dinstall 4096 Jul 15 00:30 ctl_bak -rw-r--r-- 1 dmdba dinstall 24117248 Jul 15 00:35 SYSTEM.DBF -rw-r--r-- 1 dmdba dinstall 134217728 Jul 15 00:49 ROLL.DBF -rw-r--r-- 1 dmdba dinstall 268435456 Jul 15 00:49 DAMENG02.log -rw-r--r-- 1 dmdba dinstall 268435456 Jul 15 00:49 DAMENG01.log [root@node1 DAMENG]# [root@node1 DAMENG]# cat dm.ini | grep ARCH_INI ARCH_INI = 0 #dmarch.ini [root@node1 DAMENG]# |
可以看到,当前的配置是:0
修改后:
1 2 3 4 5 |
[root@node1 DAMENG]# vi dm.ini [root@node1 DAMENG]# [root@node1 DAMENG]# cat dm.ini | grep ARCH_INI ARCH_INI = 1 #dmarch.ini [root@node1 DAMENG]# |
然后,准备配置归档配置文件:dmarch.ini
需要注意的是,文件【dmarch.ini】需要在【dm.ini】所在的目录中创建
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
[root@node1 DAMENG]# pwd /data/dameng/DAMENG [root@node1 DAMENG]# [root@node1 DAMENG]# ls -ltr | grep dm.ini -rw-r--r-- 1 dmdba dinstall 49826 Jul 15 00:52 dm.ini [root@node1 DAMENG]# [root@node1 DAMENG]# touch dmarch.ini [root@node1 DAMENG]# [root@node1 DAMENG]# chown -R dmdba.dinstall dmarch.ini [root@node1 DAMENG]# [root@node1 DAMENG]# ls -ltr | grep dmarch.ini -rw-r--r-- 1 dmdba dinstall 0 Jul 15 01:20 dmarch.ini [root@node1 DAMENG]# [root@node1 DAMENG]# vi dmarch.ini [root@node1 DAMENG]# [root@node1 DAMENG]# cat dmarch.ini [ARCHIVE_LOCAL] # Redo日志归档名 ARCH_TYPE=LOCAL # Redo日志归档类型 / LOCAL本地归档 REMOTE远程归档 ARCH_DEST=/data/dameng/arch # Redo日志归档目标 / Local归档文件存放路径 REMOTE远程目标节点实例名 ARCH_FILE_SIZE=1024 # Redo日志归档文件 单个文件大小 / 取值范围 64M - 2048M / 默认 1024M ARCH_SPACE_LIMIT=2048 # Redo日志归档空间限制 当本地归档文件达到限制时,系统自动删除最老的归档文件 / 0 无空间限制 / 取值范围 1024M - 4294967294M #ARCH_INCOMING_PATH # 仅对REMOTE归档有效,对应远程归档存放在本地节点的实际路径 [root@node1 DAMENG]# |
配置好了上面的之后,然后重启启动数据库实例即可:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
[root@node1 DAMENG]# service DmServiceDMSERVER status Redirecting to /bin/systemctl status DmServiceDMSERVER.service ● DmServiceDMSERVER.service - DM database instance service Loaded: loaded (/usr/lib/systemd/system/DmServiceDMSERVER.service; enabled; vendor preset: disabled) Active: inactive (dead) since Thu 2021-07-15 00:49:15 PDT; 47min ago Process: 82763 ExecStop=/opt/dmdbms/bin/DmServiceDMSERVER stop (code=exited, status=0/SUCCESS) Process: 82425 ExecStart=/opt/dmdbms/bin/DmServiceDMSERVER start (code=exited, status=0/SUCCESS) Main PID: 82450 (code=exited, status=0/SUCCESS) Jul 15 00:30:06 node1 systemd[1]: Starting DM database instance service... Jul 15 00:30:21 node1 DmServiceDMSERVER[82425]: [39B blob data] Jul 15 00:30:21 node1 systemd[1]: Started DM database instance service. Jul 15 00:49:10 node1 systemd[1]: Stopping DM database instance service... Jul 15 00:49:15 node1 DmServiceDMSERVER[82763]: [39B blob data] Jul 15 00:49:15 node1 systemd[1]: Stopped DM database instance service. [root@node1 DAMENG]# [root@node1 DAMENG]# ps -ef | grep dmserver root 83386 81628 0 01:36 pts/2 00:00:00 grep --color=auto dmserver [root@node1 DAMENG]# [root@node1 DAMENG]# service DmServiceDMSERVER start Redirecting to /bin/systemctl start DmServiceDMSERVER.service [root@node1 DAMENG]# [root@node1 DAMENG]# ps -ef | grep dmserv dmdba 78657 76999 0 Jul14 pts/4 00:00:00 /bin/sh ./dmservice.sh dmdba 78661 78657 0 Jul14 pts/4 00:00:33 /opt/dmdbms/jdk/bin/java -XX:+PerfDisableSharedMem -DDM_HOME=/opt/dmdbms -Djava.library.path=/opt/dmdbms/bin -Ddameng.log.file=/opt/dmdbms/tool/log4j.xml -DeclipseHome=/opt/dmdbms/tool -Dnl=en_US -Dapp.name=dmservice -Djava.ext.dirs=/opt/dmdbms/jdk/jre/lib/ext:/opt/dmdbms/tool/plugins:/opt/dmdbms/tool/dropins/com.dameng/plugins:/opt/dmdbms/tool/dropins/com.dameng/plugins/com.dameng.third com.dameng.serviceviewer.Startup dmdba 83428 1 1 01:36 ? 00:00:00 /opt/dmdbms/bin/dmserver /data/dameng/DAMENG/dm.ini -noconsole root 83502 81628 0 01:37 pts/2 00:00:00 grep --color=auto dmserv [root@node1 DAMENG]# |
启动后,查看数据库状态:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
[dmdba@node1 ~]$ disql disql V8 username:sysdba password: Server[LOCALHOST:5236]:mode is normal, state is open login used time : 3.560(ms) SQL> SQL> select name,arch_mode from v$database; LINEID NAME ARCH_MODE ---------- ------ --------- 1 DAMENG Y used time: 2.539(ms). Execute id is 4. SQL> SQL> exit [dmdba@node1 ~]$ |
可以看到,现在已经是归档模式了。
验证归档
查看一下归档目录的状态:
1 2 3 4 5 6 7 8 9 10 |
[dmdba@node1 ~]$ cd /data/dameng/ [dmdba@node1 dameng]$ ls -ltr total 4 drwxr-xr-x 6 dmdba dinstall 4096 Jul 15 01:36 DAMENG drwxr-xr-x 2 dmdba dinstall 65 Jul 15 01:36 arch [dmdba@node1 dameng]$ [dmdba@node1 dameng]$ ls -ltr arch/ total 1048576 -rw-r--r-- 1 dmdba dinstall 1073741824 Jul 15 01:37 ARCHIVE_LOCAL_0x3B086692[0]_2021-07-15_01-36-43.log [dmdba@node1 dameng]$ |