暂无图片
暂无图片
1
暂无图片
暂无图片
暂无图片

达梦数据库 | 教程 | 5.开启归档模式

原创 喻一桓 2021-07-15
3575

概述

达梦数据库可以运行在归档状态或者非归档状态下;

如果运行在归档模式,那么联机日志中的内容会以归档日志的形式保存在硬盘中;

如果运行在非归档模式,那么联机日志文件中的内容不会在日志切换的时候形成归档日志,而是会因为联机日志的循环写,而丢失。

采用归档模式会对系统的性能造成些许的影响,但是数据库运行在归档模式下,数据会更加安全。
当出现故障的时候,数据丢失的可能性会更小,因为一旦出现介质故障(如:磁盘损坏)时,可以利用归档日志,将数据库恢复到发生故障的前一刻,也可以指定时间点还原;而如果没有昂日志,则只能利用备份文件进行还原。

需要配置归档的场景:

当你需要联机备份数据库的时候,你必须要将数据库设置为归档模式;

联机备份的时候,大量的事务处于活动状态,为了确保备份数据的一致性:

备份数据库
备份数据库过程中,还会产生一系列的REDO日志;这段时间内的REDO日志产生的归档也需要备份
因此,数据库必须配置为:

本地归档
归档状态:开启
属于联机备份的:

备份表空间
备份表(虽然这个也属于联机完全备份,但是不需要配置归档;因为表在还原之后,不需要再进行恢复操作,所以用不到归档日志,也就不需要配置归档模式)
备份归档日志(必须配置归档)
脱机备份的时候,数据库可以配置为归档模式,也可以不用配置归档模式;

正常退出库的备份不需要考虑本地归档日志的完整性,因此不需要配置归档模式;

对于由于故障退出的库的备份,则由于要求备份,因故障导致没有来得及刷盘的REDO日志,所以必须要配制归档;

如果本地归档缺失,则需要:

修复归档
再备份

查看数据库的归档状态

首先,检查当前达梦数据库的归档状态

[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的配置
开始配置:

[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状态:

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> 

然后,配置数据库:本地归档

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> 

看看数据库的数据目录中的变化:

[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

首先,停掉达梦数据库实例:

[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

查看:

[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

修改后:

[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】所在的目录中创建

[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]# 

配置好了上面的之后,然后重启启动数据库实例即可:

[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]# 

启动后,查看数据库状态:

[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 ~]$ 

验证归档

查看一下归档目录的状态:

[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]$ 

原文:http://d-prototype.com/archives/16007

最后修改时间:2021-07-15 17:28:26
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论