oracle 中跟日志有关的几个语句

切换日志生成检查点:alter system switch logfile;

归档当前日志:alter system archive log current;

归档所有日志:ALTER SYSTEM ARCHIVE LOG ALL;

指定归档日志从现在开始归档位置:ALTER SYSTEM ARCHIVE LOG START TO  ‘C: \ Oracle \ ARCH’
归档所有日志到指定位置:alter system archive log all to '/databack/arch_temp';

暂时停止归档:alter system disable thread 2;
清除联机日志:alter system clear logfile '/oradata/orcl/rkxt_log3aa.log';

清除未归档的日志:alter system clear unarchived logfile group 3;
删除日志组:alter database drop logfile group 6;

删除日志组成员:alter database drop logfile member '---------';

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8258133/viewspace-483620/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8258133/viewspace-483620/