Monday, April 14, 2008

Increase size of online redo logs

SQL> SELECT group#, bytes, members FROM sys.v$log;

    GROUP#      BYTES    MEMBERS
---------- ---------- ----------
         1   52428800          2
         2   52428800          2
         3   52428800          2
         4 1048576000          2

You must add larger redo log files and then drop the existing small ones. There's no way to resize a log file, whether the database is up or down. Just add new ones, issue an alter system switch logfile statement to use the new ones, and then drop the old small ones.

No comments:

Post a Comment