重庆思庄Oracle、Redhat认证学习论坛

标题: 添加redolog组成员 [打印本页]

作者: jiawang 时间: 2019-7-25 17:22
标题: 添加redolog组成员
查询当前状态redolog

SQL> select group#,sequence#,bytes,members,status from v$log;

GROUP#  SEQUENCE#    BYTES MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
      1       61 52428800       1 INACTIVE
      2       64 52428800       1 CURRENT
      3       0 52428800       1 UNUSED

SQL> alter database add logfile member 'D:\oracle\oradata\test\REDO03_B.log' to group 3;
Database altered.

SQL> select * from v$logfile;

GROUP# STATUS  TYPE MEMBER                                  IS_
---------- ------- ------- ---------------------------------------- ---
      3       ONLINE  D:\ORACLE\ORADATA\TEST\REDO03.LOG       NO
      2       ONLINE  D:\ORACLE\ORADATA\TEST\REDO02.LOG       NO
      1       ONLINE  D:\ORACLE\ORADATA\TEST\REDO01.LOG       NO
      3 INVALID ONLINE  D:\ORACLE\ORADATA\TEST\REDO03_B.LOG    NO

SQL> select group#,sequence#,bytes,members,status from v$log;

GROUP#  SEQUENCE#    BYTES MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
      1       61 52428800       1 INACTIVE
      2       64 52428800       1 CURRENT
      3       0 52428800       2 UNUSED

切换logfile到第三组；
SQL> alter system switch logfile ;
System altered.

SQL> select group#,sequence#,bytes,members,status from v$log;

GROUP#  SEQUENCE#    BYTES MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
      1       61 52428800       1 INACTIVE
      2       64 52428800       1 ACTIVE
      3       65 52428800       2 CURRENT

将redolog日志归档

SQL> alter system checkpoint;
System altered.

SQL> select group#,sequence#,bytes,members,status from v$log;

GROUP#  SEQUENCE#    BYTES MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
      1       61 52428800       1 INACTIVE
      2       64 52428800       1 INACTIVE
      3       65 52428800       2 CURRENT

为前两组添加组成员

SQL> alter database add logfile member 'D:\oracle\oradata\test\REDO01_B.log' to group 1;
Database altered.

SQL> alter database add logfile member 'D:\oracle\oradata\test\REDO02_B.log' to group 2;
Database altered.

SQL> select group#,member from v$logfile;

GROUP# MEMBER
---------- ----------------------------------------
      3 D:\ORACLE\ORADATA\TEST\REDO03.LOG
      2 D:\ORACLE\ORADATA\TEST\REDO02.LOG
      1 D:\ORACLE\ORADATA\TEST\REDO01.LOG
      3 D:\ORACLE\ORADATA\TEST\REDO03_B.LOG
      1 D:\ORACLE\ORADATA\TEST\REDO01_B.LOG
      2 D:\ORACLE\ORADATA\TEST\REDO02_B.LOG

6 rows selected.

SQL> select * from v$logfile;

GROUP# STATUS  TYPE MEMBER                                  IS_
---------- ------- ------- ---------------------------------------- ---
      3       ONLINE  D:\ORACLE\ORADATA\TEST\REDO03.LOG       NO
      2       ONLINE  D:\ORACLE\ORADATA\TEST\REDO02.LOG       NO
      1       ONLINE  D:\ORACLE\ORADATA\TEST\REDO01.LOG       NO
      3       ONLINE  D:\ORACLE\ORADATA\TEST\REDO03_B.LOG    NO
      1 INVALID ONLINE  D:\ORACLE\ORADATA\TEST\REDO01_B.LOG    NO
      2 INVALID ONLINE  D:\ORACLE\ORADATA\TEST\REDO02_B.LOG    NO

6 rows selected.

SQL> alter system switch logfile;
System altered.

SQL> alter system switch logfile;
System altered.

SQL> select * from v$logfile;

GROUP# STATUS  TYPE MEMBER                                  IS_
---------- ------- ------- ---------------------------------------- ---
      3       ONLINE  D:\ORACLE\ORADATA\TEST\REDO03.LOG       NO
      2       ONLINE  D:\ORACLE\ORADATA\TEST\REDO02.LOG       NO
      1       ONLINE  D:\ORACLE\ORADATA\TEST\REDO01.LOG       NO
      3       ONLINE  D:\ORACLE\ORADATA\TEST\REDO03_B.LOG    NO
      1       ONLINE  D:\ORACLE\ORADATA\TEST\REDO01_B.LOG    NO
      2       ONLINE  D:\ORACLE\ORADATA\TEST\REDO02_B.LOG    NO

6 rows selected.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)