增大redo.log

Redo Log的增大的方法：

 

列子：比如从原有50M增大到2G。

 

 SYS > col member for a30;
 SYS > select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                         IS_
---------- ------- ------- ------------------------------ ---
         3         ONLINE  /u01/app/oracle/oradata/orcl/r NO
                           edo03.log

         2         ONLINE  /u01/app/oracle/oradata/orcl/r NO
                           edo02.log

         1         ONLINE  /u01/app/oracle/oradata/orcl/r NO
                           edo01.log

SYS > alter database drop logfile group 3;

Database altered.

 SYS > alter database add logfile group 3 ('/u01/app/oracle/oradata/orcl/redo03.log') size 2048M reuse;

Database altered.

 SYS > select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                         IS_
---------- ------- ------- ------------------------------ ---
         3         ONLINE  /u01/app/oracle/oradata/orcl/r NO
                           edo03.log

         2         ONLINE  /u01/app/oracle/oradata/orcl/r NO
                           edo02.log

         1         ONLINE  /u01/app/oracle/oradata/orcl/r NO
                           edo01.log

 SYS > select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------
         1          1        221   52428800          1 YES INACTIVE               2833319 20-JAN-10
         2          1        222   52428800          1 NO  CURRENT                2842173 21-JAN-10
         3          1          0 2147483648          1 YES UNUSED                       0

 SYS > alter system switch logfile;

System altered.
SYS > select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------
         1          1        224   52428800          1 NO  CURRENT                2842505 21-JAN-10
         2          1        222   52428800          1 YES ACTIVE                 2842173 21-JAN-10
         3          1        223 2147483648          1 YES ACTIVE                 2842503 21-JAN-10

同理其他日志增大。

遇到问题：

SYS > alter database drop logfile group 1;

alter database drop logfile group 1

*

ERROR at line 1:

ORA-01624: log 1 needed for crash recovery of instance orcl (thread 1)

ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log'

 

 

查找原因：

SYS > select * from v$log;

 

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME

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

         1          1        227   52428800          1 YES ACTIVE                 2842818 21-JAN-10

         2          1        228 2147483648          1 NO  CURRENT                2842830 21-JAN-10

         3          1        226 2147483648          1 YES INACTIVE               2842814 21-JAN-10

 

说明：redo log只有处于Inactive的状态下，才可以drop。

 

解决办法：

 

SYS > alter system checkpoint;

 

System altered.

 

 SYS > select * from v$log;

 

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME

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

         1          1        227   52428800          1 YES INACTIVE               2842818 21-JAN-10

         2          1        228 2147483648          1 NO  CURRENT                2842830 21-JAN-10

         3          1        226 2147483648          1 YES INACTIVE               2842814 21-JAN-10

 

 SYS > alter database drop logfile group 1;

 

Database altered.

 

 SYS > alter database add logfile group 1 ('/u01/app/oracle/oradata/orcl/redo01.log') size 2048m reuse;

 

Database altered.

 

 SYS > select * from v$log;

 

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME

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

         1          1          0 2147483648          1 YES UNUSED                       0

         2          1        228 2147483648          1 NO  CURRENT                2842830 21-JAN-10

         3          1        226 2147483648          1 YES INACTIVE               2842814 21-JAN-10

 

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23203417/viewspace-625711/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23203417/viewspace-625711/