Oracle学习（六）之增加日志组成员

最新推荐文章于 2024-04-16 19:27:35 发布

木子果果

最新推荐文章于 2024-04-16 19:27:35 发布

阅读量1.8k

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle数据库学习文章标签： Oracle数据库增加日志组成员数据库日志文件管理

本文链接：https://blog.youkuaiyun.com/lzg1169350237/article/details/46271097

Oracle数据库学习专栏收录该内容

21 篇文章

订阅专栏

1.查询日志状态
select * from v$log;

2.查询日志文件存放位置
select * from v$logfile;

3.增加日志组成员（状态为INACTIVE的组如下，状态为CURRENT的组需要切换日志组）
SQL> alter database add logfile member
2 ‘日志成员1’,
3 ‘日志成员2’ to group 组号;

例如：
1)查询日志状态
  SQL> select GROUP#,STATUS from v$log;

     GROUP# STATUS
      ---------- ----------------
        1 CURRENT
        2 INACTIVE
        3 INACTIVE

2）查询日志文件存放位置
SQL> select GROUP#,MEMBER from v$logfile;

    GROUP#  MEMBER
 ---------- -----------------------------------------
         1  /u03/ora11g/student/redo0101.rdo
         2  /u04/ora11g/student/redo0202.rdo
         3  /u05/ora11g/student/redo0303.rdo

3）找到日志状态为INACTIVE(即第2组和第3组可以修改，以第二组为例)
SQL> alter database add logfile member
  2  '/u04/ora11g/student/redo0102.rdo',
  3  '/u04/ora11g/student/redo0302.rdo' to group 2;

Database altered.

   查看是否修改成功
SQL> select GROUP#,MEMBER from v$logfile order by 1,2;

    GROUP#  MEMBER
 ---------- -----------------------------------------
         1  /u03/ora11g/student/redo0101.rdo
         2  /u04/ora11g/student/redo0202.rdo
         2  /u04/ora11g/student/redo0102.rdo
         2  /u04/ora11g/student/redo0302.rdo
         3  /u05/ora11g/student/redo0303.rdo

这样就修改完成了。

4）修改处于CURRENT状态的日志文件
step1：切换日志文件
  SQL>alter system switch logfile；

step2：查询日志状态
      SQL> select GROUP#,STATUS from v$log;

         GROUP# STATUS
          ---------- ----------------
              1 INACTIVE
              2 CURRENT
              3 INACTIVE

step3：为第1个日志组增加成员
SQL> alter database add logfile member
  2  '/u03/ora11g/student/redo0201.rdo',
  3  '/u03/ora11g/student/redo0301.rdo' to group 1;

step4：查询结果
SQL> select GROUP#,MEMBER from v$logfile order by 1,2;

    GROUP#  MEMBER
 ---------- -----------------------------------------
         1  /u03/ora11g/student/redo0101.rdo
         1  /u03/ora11g/student/redo0201.rdo
         1  /u03/ora11g/student/redo0301.rdo
         2  /u04/ora11g/student/redo0202.rdo
         2  /u04/ora11g/student/redo0102.rdo
         2  /u04/ora11g/student/redo0302.rdo
         3  /u05/ora11g/student/redo0303.rdo

显示这样就修改成功了。