新增一个本地归档:
ALTER DATABASE MOUNT;
ALTER DATABASE ADD ARCHIVELOG 'TYPE=LOCAL,DEST=C:\software\DM\dmdbms\data\ARCH,FILE_SIZE=1024,SPACE_LIMIT=4096';
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
修改已经存在的本地归档的上限:
ALTER DATABASE MOUNT;
ALTER DATABASE NOARCHIVELOG;
ALTER DATABASE MODIFY ARCHIVELOG 'TYPE=LOCAL,DEST=C:\software\DM\dmdbms\data\ARCH,FILE_SIZE=1024,SPACE_LIMIT=10240';
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
想要修改本地归档目录,不能直接使用MODIFY语句,需要先增加一个另一个目录的本地归档,再删掉原目录的本地归档:
ALTER DATABASE MOUNT;
ALTER DATABASE NOARCHIVELOG;
ALTER DATABASE ADD ARCHIVELOG 'TYPE=LOCAL,DEST=C:\software\DM\dmdbms\data\ARCH1,FILE_SIZE=1024,SPACE_LIMIT=4096';
ALTER DATABASE DELETE ARCHIVELOG 'TYPE=LOCAL,DEST=C:\software\DM\dmdbms\data\ARCH,FILE_SIZE=1024,SPACE_LIMIT=10240';
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
可以通过V$DM_INI和V$DM_ARCH_INI来查看归档状态和归档配置。
SELECT * FROM V$DM_ARCH_INI;
SELECT * FROM V$DM_INI WHERE PARA_NAME = 'ARCH_INI';
SELECT * FROM V$ARCH_STATUS;