Oracle重做日志成员（文件）-新增、删除

来源：互联网发布：淘宝上免运费怎么赚钱编辑：程序博客网时间：2024/05/16 23:53

分别给日志组1/2各增加一个成员

SQL> alter database add logfile member
2 'C:\ORACEL\BASE\ORADATA\ORCL\REDO04.LOG' to group 1,
3   'C:\ORACEL\BASE\ORADATA\ORCL\REDO05.LOG' to group 2;
Database altered
查看
SQL> select * from v$log;
    GROUP#    THREAD# SEQUENCE#      BYTES BLOCKSIZE    MEMBERS ARCHIVED STATUS           FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
         1          1         13   52428800        512          2 NO       INACTIVE           21995736819 2017-9-21 9 21995740613 2017-9-21 1
         2          1         14   52428800        512          2 NO       CURRENT            21995740613 2017-9-21 1 281474976710
         3          1         12   52428800        512          1 NO       INACTIVE           21995708930 2017-9-21 7 21995736819 2017-9-21 9

删除：
删除前查看是否当前组如果是则不能删除进行切换 alter system switch logfile;

查看     state 为current的是当前组
QL> select * from v$log;
    GROUP#    THREAD# SEQUENCE#      BYTES BLOCKSIZE    MEMBERS ARCHIVED STATUS           FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
         1          1         13   52428800        512          2 NO       INACTIVE           21995736819 2017-9-21 9 21995740613 2017-9-21 1
         2          1         14   52428800        512          2 NO       CURRENT            21995740613 2017-9-21 1 281474976710
         3          1         12   52428800        512          1 NO       INACTIVE           21995708930 2017-9-21 7 21995736819 2017-9-21 9

删除 group 1 的一个文件

SQL> alter database drop logfile member 'C:\ORACEL\BASE\ORADATA\ORCL\REDO04.LOG';
Database altered

查看确认是否删除

SQL> select * from v$log;
    GROUP#    THREAD# SEQUENCE#      BYTES BLOCKSIZE    MEMBERS ARCHIVED STATUS           FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
         1          1         13   52428800        512          1 NO       INACTIVE           21995736819 2017-9-21 9 21995740613 2017-9-21 1
         2          1         14   52428800        512          2 NO       CURRENT            21995740613 2017-9-21 1 281474976710
         3          1         12   52428800        512          1 NO       INACTIVE           21995708930 2017-9-21 7 21995736819 2017-9-21 9

SQL>

阅读全文

0 0