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

几个语句"/>

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 '---------';