达梦数据库如何开启归档/关闭归档

开启归档的方法：

SQL 开启归档

SQL> alter database mount;

SQL> alter database archivelog;

SQL> select arch_mode from v$database;

SQL> alter database add archivelog 'type=local,dest=/dm8/arch,file_size=64,space_limit=10240';

SQL> alter database open;

SQL> select * from v$dm_arch_ini;

SQL 关闭归档

SQL> alter database mount;

SQL> alter database noarchivelog;

SQL> alter database delete archivelog 'type=local,dest=/dm8/arch';

SQL> alter database open;

SQL> select arch_mode from v$database;

SQL> select * from v$dm_arch_ini;