0.日志切换

alter system switch logfile;

1.增加日志组

alter database add logfile group 4 '/uo1/dylan007/redo04.log' size 50M;

2.增加日志组成员

alter database add logfile member

'/uo1/dylan007/redo04a.log' to group 4;

3.删除日志组

alter database drop logfile group 4;

4.删除日志组成员(必须处于INACTIVE时才能删除)

alter database drop logfile member

'/uo1/dylan007/redo04a.log';

5.relocate&rename（必须shutdown immediate--startup mount --alter command--alter database open;）

备份日志文件redo01.log

alter database rename file '/uo1/dylan007/redo01.log' to'/uo1/redo01.log';

[@more@]

ITPub博客

redo logfile的维护操作