oracle增加一个日志组

最新推荐文章于 2024-05-02 18:10:48 发布

董小姐yyds

最新推荐文章于 2024-05-02 18:10:48 发布

阅读量2k

点赞数

分类专栏： oracle 文章标签： oracle

本文链接：https://blog.csdn.net/qq961573863/article/details/107735370

版权

oracle 专栏收录该内容

62 篇文章 0 订阅

订阅专栏

关键步骤
1、查v$log  v$logfile
2、增加日志组
3、验证
具体操作如下：
--查v$log  v$logfile
SYS@PROD> select group#,sequence#,bytes/1024/1024 m,archived,status from v$log;

    GROUP#  SEQUENCE#           M ARC STATUS
---------- ---------- ---------- --- ----------------
     1        1         200 NO  INACTIVE
     2        2         200 NO  CURRENT
     3        0         200 YES UNUSED
SYS@PROD> select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                            IS_    CON_ID
---------- ------- ------- ------------------------------------------------------------ --- ----------
     3       ONLINE  /u01/app/oracle/oradata/PROD/redo03.log            NO         0
     2       ONLINE  /u01/app/oracle/oradata/PROD/redo02.log            NO         0
     1       ONLINE  /u01/app/oracle/oradata/PROD/redo01.log            NO         0
--增加日志组
SYS@PROD> alter database add logfile group 4 '/u01/app/oracle/oradata/PROD/redo04.log' size 50m;

Database altered.
--验证
SYS@PROD> select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                            IS_    CON_ID
---------- ------- ------- ------------------------------------------------------------ --- ----------
     3       ONLINE  /u01/app/oracle/oradata/PROD/redo03.log            NO         0
     2       ONLINE  /u01/app/oracle/oradata/PROD/redo02.log            NO         0
     1       ONLINE  /u01/app/oracle/oradata/PROD/redo01.log            NO         0
     4       ONLINE  /u01/app/oracle/oradata/PROD/redo04.log            NO         0

SYS@PROD> select group#,sequence#,bytes/1024/1024 m,archived,status from v$log;

    GROUP#  SEQUENCE#           M ARC STATUS
---------- ---------- ---------- --- ----------------
     1        1         200 NO  INACTIVE
     2        2         200 NO  ACTIVE
     3        3         200 NO  CURRENT
     4        0         200 YES UNUSED

说明：UNUSED：新添加的日志组，还没有使用