查看归档是否开启:
select arch_mode from v$database; --N为未开启,Y为已开启
一、修改文件dm.ini
[dmdba@localhost DAMENG]$ vi dm.ini
创建dmarch.ini ,ARCH_DEST 为本地归档路径
二、数据库修改-sql修改:
[dmdba@dm1 ~]$ cd /dm/bin
[dmdba@dm1 bin]$ ./disql
disql V8
username:
password:
Server[LOCALHOST:5236]:mode is normal, state is open
login used time : 42.128(ms)
SQL> select arch_mode from v$database;
LINEID ARCH_MODE
---------- ---------
1 N
used time: 38.645(ms). Execute id is 300.
SQL> alter database mount;
executed successfully
used time: 370.230(ms). Execute id is 0.
SQL> alter database archivelog;
executed successfully
used time: 6.197(ms). Execute id is 0.
SQL> alter database add archivelog 'DEST=/dm/arch,TYPE=local,FILE_SIZE=1024,SPACE_LIMIT=0';
executed successfully
used time: 2.226(ms). Execute id is 0.
SQL> alter database open; --打开数据库
SQL> select arch_mode from v$database; ---查看数据库已经开启归档
LINEID ARCH_MODE
---------- ---------
1 Y
used time: 0.621(ms). Execute id is 301.
三、界面修改
用管理工具连上数据库后,点击系统管理,选择配置状态,点击转换
转换成功后,点击归档配置,修改归档模式,添加归档目标(归档文件的路径),确定,
更多相关问题请浏览:
达梦云适配技术社区:https://eco.dameng.com/