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

发布时间：2020-12-12 14:26:59 所属栏目：百科来源：网络整理

导读：分别给日志组1/2各增加一个成员 SQL alter database add logfile member 2 'C:ORACELBASEORADATAORCLREDO04.LOG' to group 1, 3 'C:ORACELBASEORADATAORCLREDO05.LOG' to group 2; Database altered 查看 SQL select * from v$log; GROUP# THREAD#

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

SQL> alter database add logfile member
2 'C:ORACELBASEORADATAORCLREDO04.LOG' to group 1,
3 'C:ORACELBASEORADATAORCLREDO05.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:ORACELBASEORADATAORCLREDO04.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>

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!