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