达梦数据库开启归档

?

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

[root@node01 ~]# mkdir -p /dm8/dmarch [root@node01 ~]# chown -R dmdba.dinstall /dm8 [root@node01 ~]# [root@node01 ~]# [root@node01 ~]# su - dmdba Last login: Tue Aug 16 10:02:55 CST 2022 on pts/5 [dmdba@node01 ~]$ [dmdba@node01 ~]$ disql sysdba/passwordfordmdba   Server[LOCALHOST:5236]:mode is normal, state is open login used time : 1.959(ms) disql V8 SQL> alter database mount; executed successfully used time: 2.749(ms). Execute id is 0. SQL> alter database add archivelog 'type=local,dest=/dm8/dmarch,file_size=1024,space_limit=102400'; executed successfully used time: 2.515(ms). Execute id is 0. SQL> alter database archivelog; executed successfully used time: 5.144(ms). Execute id is 0. SQL> alter database open; executed successfully used time: 51.351(ms). Execute id is 0. SQL> SQL> select NAME,ARCH_MODE,STATUS$ from v$database;   LINEID     NAME   ARCH_MODE STATUS$ ---------- ------ --------- ----------- 1          DAMENG Y         4   used time: 0.697(ms). Execute id is 2501.