How to Multiplex Redo Log Files in Oracle 11g



Step 1:- List all the current redo log file in database
SQL> Select * from v$logfile;

    GROUP#   TYPE    MEMBER                      
---------- ------- ------- --------------------------------------
         1   ONLINE  /u01/app/oracle/oradata/prim/redo01.log
         2   ONLINE  /u01/app/oracle/oradata/prim/redo02.log
         3   ONLINE  /u01/app/oracle/oradata/prim/redo03.log



Step-2: Add redo log file members for different location

ALTER DATABASE ADD LOGFILE MEMBER '/home/oracle/redolog/redo01.log' TO GROUP 1;
Database altered.

SQL> ALTER DATABASE ADD LOGFILE MEMBER '/home/oracle/redolog/redo02.log' TO GROUP 2;

Database altered.

SQL> ALTER DATABASE ADD LOGFILE MEMBER '/home/oracle/redolog/redo03.log' TO GROUP 3;

Database altered.

SQL> alter system switch logfile;

SQL> select GROUP#,SEQUENCE#,(BYTES/1024/1024)MB,MEMBERS from v$log;

    GROUP#  SEQUENCE# (BYTES/1024/1024)MB    MEMBERS
----------          ----------           -----------------                 ----------
         1                7                         50                                  2
         2                5                         50                                  2
         3                6                         50                                  2


SQL> Select * from v$logfile;

   GROUP# STATUS  TYPE    MEMBER                                             IS_
---------- ------- ------- -------------------------------------------------- ---
         3         ONLINE  /u01/app/oracle/oradata/prim/redo03.log            NO
         2         ONLINE  /u01/app/oracle/oradata/prim/redo02.log            NO
         1         ONLINE  /u01/app/oracle/oradata/prim/redo01.log            NO
         1         ONLINE  /home/oracle/redolog/redo01.log                    NO
         2         ONLINE  /home/oracle/redolog/redo02.log                    NO
         3         ONLINE  /home/oracle/redolog/redo03.log      


Done..

Nenhum comentário:

Postar um comentário

Related Posts Plugin for WordPress, Blogger...