Resize the size of redo log files

METALINK ID --- ID 1035935.6

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

    GROUP# STATUS
---------- -------
MEMBER
--------------------------------------------------------------------------------
         2
/erpdata21/CLN03/data/log02a.log

         2
/erpdata21/CLN03/data/log02b.log

         1
/erpdata21/CLN03/data/log01a.log


    GROUP# STATUS
---------- -------
MEMBER
--------------------------------------------------------------------------------
         1
/erpdata21/CLN03/data/log01b.log

/erpdata21/CLN03/data/log03a.log

         3
/erpdata21/CLN03/data/log03b.log

--------------------








alter database add logfile group 1 ('/erpdata21/CLN03/data/newredo01a.log', '/erpdata21/CLN03/data/newredo01b.log') size 1024M reuse;

alter database add logfile group 2 ('/erpdata21/CLN03/data/newredo02a.log', '/erpdata21/CLN03/data/newredo02b.log') size 1024M reuse;

alter database add logfile group 3 ('/erpdata21/CLN03/data/newredo03a.log', '/erpdata21/CLN03/data/newredo03b.log') size 1024M reuse;


SQL> alter database open;

Database altered.

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

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

SQL> alter system switch logfile;

System altered.

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

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

SQL> alter system switch logfile;

System altered.

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

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

SQL> alter  system switch logfile;

System altered.

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

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

SQL> alter system switch logfile;

System altered.

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

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

SQL> alter system checkpoint;

System altered.

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

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

SQL> alter database drop logfile group 1;

Database altered.

SQL> alter database add logfile group 1 ('/erpdata21/CLN03/data/newredo01a.log', '/erpdata21/CLN03/data/newredo01b.log') size 1024M reuse;

Database altered.

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

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

SQL> alter system switch logfile;

System altered.

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

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

SQL> alter database drop logfile group 2;

Database altered.

SQL> alter database add logfile group 2 ('/erpdata21/CLN03/data/newredo02a.log', '/erpdata21/CLN03/data/newredo02b.log') size 1024M reuse;

Database altered.

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

    GROUP# STATUS
---------- ----------------
         1 CURRENT
         2 UNUSED
         3 ACTIVE

SQL> alter system switch logfile;

System altered.

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

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

SQL> alter system checkpoint;

System altered.

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

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

SQL> alter database drop logfile group 3;

Database altered.

SQL> alter database add logfile group 3 ('/erpdata21/CLN03/data/newredo03a.log', '/erpdata21/CLN03/data/newredo03b.log') size 1024M reuse;

Database altered.

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

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

SQL> alter system switch logfile;

System altered.

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

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

SQL> select group#, members, sum(bytes)/1024/1024 from v$log group by group#,members;

    GROUP#    MEMBERS SUM(BYTES)/1024/1024
---------- ---------- --------------------
         1          2                 1024
         2          2                 1024
         3          2                 1024

SQL>