实验环境:
OEL5.6 Oracle11.2.0.1
实验开始:
数据库运行状态,删除所有日志:
[oracle@ITAA TEST]$ ls
control01.ctl redo01.log sysaux01.dbf undotbs01.dbf
data_ol01.dbf redo02.log system01.dbf users01.dbf
example01.dbf redo03.log temp01.dbf
[oracle@ITAA TEST]$ rm -rf *.log
在数据库中切换日志组:
SYS@TEST>alter system switch logfile;
System altered.
SYS@TEST>/
System altered.