更改ORACLE归档模式

作者: turning  出自:

1.kill oracle 连接进程
kill -9 `ps -ef|grep LOCAL=NO|grep -v grep|awk '{print $2}'`

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参数