1.使用sysdba登录,添加新的日志组
SQL> alter database add logfile
2 ('/oradata/law/law/redo04A.log') size 10m;
Database altered.
2.查询新添加日志组4
SQL> select group#,sequence#,members,status from v$log;
GROUP# SEQUENCE# MEMBERS STATUS
------ ---------- ---------- ----------------
1 8 1 CURRENT
2 6 1 INACTIVE
3 7 1 INACTIVE
4 0 1 UNUSED
发现新的日志组添加成功,组号为4,有一个成员
3.查询新添加的日志组中的日志成员
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
------ ------- ------- ------------------------- ---
3 ONLINE /oradata/law/law/redo03.l NO
og
2 STALE ONLINE /oradata/law/law/redo02.l NO
og
1 ONLINE /oradata/law/law/redo01.l NO
og
4 ONLINE /oradata/law/law/redo04A. NO
log
4.添加日志组的语法
alter database [数据库名]
add logfile [group 正整数] 文件名
[,[group 正整数] 文件名...]
5.删除日志组的语法:
alter database [数据库名]
drop logfile [group 正整数]
例如:删掉日志组4
SQL> alter database drop logfile group 4;
Database altered.
查询验证一下,是否删除成功:
SQL> select group#,sequence#,members,status from v$log;
GROUP# SEQUENCE# MEMBERS STATUS
------ ---------- ---------- ----------------
1 8 1 CURRENT
2 6 1 INACTIVE
3 7 1 INACTIVE
SQL> select * from v$Logfile;
GROUP# STATUS TYPE MEMBER IS_
------ ------- ------- ------------------------- ---
3 ONLINE /oradata/law/law/redo03.l NO
og
2 STALE ONLINE /oradata/law/law/redo02.l NO
og
1 ONLINE /oradata/law/law/redo01.l NO
og
注:虽然oracle上得日志组删除了,但是操作系统上的日志文件还是存在,需要手动删掉。