Oracle重做日志文件组-新增、删除

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

导读：查看日志文件组信息 SQL select * from v$log; GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME ---------- ---------- ---------- ---------- ---------- ---------- -------- -------

查看日志文件组信息

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 1 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> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- -------------------------------------------------------------------------------- ---------------------
3 ONLINE C:ORACELBASEORADATAORCLREDO03.LOG NO
2 ONLINE C:ORACELBASEORADATAORCLREDO02.LOG NO
1 ONLINE C:ORACELBASEORADATAORCLREDO01.LOG NO

新增日志组：

SQL> alter database add logfile
2 ('C:orcl1122disk1REDO04.LOG','C:orcl1122disk1REDO05.LOG') size 50M;
Database altered

SQL> select * from v$log
2 ;
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 1 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
4 1 0 52428800 512 2 YES UNUSED 0 0

SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- -------------------------------------------------------------------------------- ---------------------
3 ONLINE C:ORACELBASEORADATAORCLREDO03.LOG NO
2 ONLINE C:ORACELBASEORADATAORCLREDO02.LOG NO
1 ONLINE C:ORACELBASEORADATAORCLREDO01.LOG NO
4 ONLINE C:ORCL1122DISK1REDO04.LOG NO
4 ONLINE C:ORCL1122DISK1REDO05.LOG NO

删除日志组： SQL> alter database drop logfile group 4;

（编辑：李大同）

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