几个语句"/>
oracle 如何跟日志,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 '---------';
更多推荐
oracle 如何跟日志,oracle 中跟日志有关的几个语句
发布评论