更改Oracle数据库的归档模式

2014-11-24 17:29:55 · 作者: · 浏览: 0

2.修改参数
alter system set log_archive_dest='/arch' scope=both;
alter system set log_archive_start=TRUE scope=spfile;


3.停止Oracle
shutdown immediate


4.启动Oracle
startup mount
alter database archivelog
alter database open


5.测试归档切换
alter system switch logfile
/
/


6.注:Oracle10不用加log_archive_start参数