1SQL命令开启关闭归档
开启归档:
SQL> alter database mount;
SQL> ALTER DATABASE ADD ARCHIVELOG 'DEST=/dm8/dmarch,TYPE=local,FILE_SIZE=256,SPACE_LIMIT=2048';
SQL> ALTER DATABASE ARCHIVELOG;
SQL> ALTER DATABASE OPEN;
SQL> select * from v$dm_arch_ini;
关闭归档:
SQL> alter database mount;
SQL> alter database noarchivelog;
SQL> alter database delete archivelog 'DEST=/dm8/dmarch';
SQL> alter database open;
2修改配置文件开启关闭归档
开启归档:
[dmdba@dm8 bin]$ vim /dm8/data/DAMENG/dm.ini
[dmdba@dm8 bin]$ vim /dm8/data/DAMENG/dmarch.ini
[ARCHIVE_LOCAL]
ARCH_TYPE=LOCAL
ARCH_DEST=/dm8/dmarch
ARCH_FILE_SIZE=256
ARCH_SPACE_LIMIT=2048
[dmdba@dm8 bin]$ ./DmServiceDMSERVER stop
[dmdba@dm8 bin]$ ./DmServiceDMSERVER start
SQL> select * from v$arch_status;
关闭归档:
[dmdba@dm8 bin]$ vim /dm8/data/DAMENG/dm.ini
[dmdba@dm8 bin]$ vim /dm8/data/DAMENG/dmarch.ini
[dmdba@dm8 bin]$ ./DmServiceDMSERVER restart
3DM管理工具开启关闭归档
打开管理服务器:
转换为配置模式: