1.修改参数
alter system set log_archive_dest='/arch' scope=both;
alter system set log_archive_start=TRUE scope=spfile;
alter system set log_archive_format='%%%ORACLE_SID%%%T%TS%S.ARC' scope=spfile;
2.
停止oracle
shutdown immediate
3.
启动oracle
startup mount
alter database archivelog
alter database open
4.
alter system switch logfile
阅读(903) | 评论(0) | 转发(0) |