oracle添加删除重做日志成员

来源：互联网发布：php无限分类处理类编辑：程序博客网时间：2024/06/06 11:52

1.添加新的重做日志成员的语法:
alter database [数据库]
add logfile member ['文件名' [reuse][,'文件名'] [reuse]].. to {group 正整数}
2.添加日志成员的实例:
SQL> alter database add logfile member
2 '/oradata/law/law/redo01a.log'to group 1,
3 '/oradata/law/law/redo02a.log' to group 2,
4 '/oradata/law/law/redo03a.log' to group 3;

Database altered.
SQL> select group#,members from v$log;

GROUP#    MEMBERS
------ ----------
     1          2
     2          2
     3          2

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

1 INVALID ONLINE /oradata/law/law/redo01a. NO
log

GROUP# STATUS TYPE MEMBER IS_
------ ------- ------- ------------------------- ---

2 INVALID ONLINE /oradata/law/law/redo02a. NO
log

3 INVALID ONLINE /oradata/law/law/redo03a. NO
log

6 rows selected.
3.删除日志成员的实例:

SQL> alter database drop logfile member
2 '/oradata/law/law/redo03a.log';

Database altered.

SQL> select group#,members from v$log;

GROUP#    MEMBERS
------ ----------
     1          2
     2          2
     3          1

SQL> select group#,member from v$logfile
2 where group#=3;

GROUP# MEMBER
------ -------------------------
3 /oradata/law/law/redo03.l
og
删除的时候，不能删除当前组。
如果想删除的话，需要先进行日志组切换。
命令删除后，请手动删除操作系统上得日志文件。