redo日志管理（二）10g中MAXLOGFILES参数的变化

1.首先dump出trace文件，查看原来的MAXLOGFILES参数设置。
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "EBANK" NORESETLOGS  ARCHIVELOG
    MAXLOGFILES 5
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 '/oracle/oradata/ebank/10g_redo01.log'  SIZE 10M,
  GROUP 2 '/oracle/oradata/ebank/10g_redo02.log'  SIZE 10M,
  GROUP 3 '/oracle/oradata/ebank/10g_redo03.log'  SIZE 10M
-- STANDBY LOGFILE
DATAFILE
  '/oracle/oradata/ebank/10g_system01.dbf',
  '/oracle/oradata/ebank/users01.dbf',
  '/oracle/oradata/ebank/10g_sysaux01.dbf',
  '/oracle/oradata/ebank/10g_undotbs01.dbf',
  '/oracle/oradata/ebank/tools01.dbf',
  '/oracle/oradata/ebank/tsa01.dbf',
  '/oracle/oradata/ebank/tsb01.dbf',
  '/oracle/oradata/ebank/tsc01.dbf',
  '/oracle/oradata/ebank/tsd01.dbf',
  '/ora10g/oradata/ebank/users02.dbf',
  '/ora10g/oradata/ebank/users03.dbf'
CHARACTER SET US7ASCII
;

可见，原来建库的时候设置了该参数为5，接下来进行测试，手动添加6组redo日志：

SQL> alter database add logfile GROUP 4 '/oracle/oradata/ebank/10g_redo04.log'  SIZE 10M;

Database altered.

SQL> alter database add logfile GROUP 5 '/oracle/oradata/ebank/10g_redo05.log'  SIZE 10M;
alter database add logfile GROUP 6 '/oracle/oradata/ebank/10g_redo06.log'  SIZE 10M;
alter database add logfile GROUP 7 '/oracle/oradata/ebank/10g_redo07.log'  SIZE 10M;
alter database add logfile GROUP 8 '/oracle/oradata/ebank/10g_redo08.log'  SIZE 10M;
alter database add logfile GROUP 9 '/oracle/oradata/ebank/10g_redo09.log'  SIZE 10M;

Database altered.

SQL>

Database altered.

SQL>
Database altered.

SQL>
Database altered.

SQL>
Database altered.

SQL> SQL> SQL>

添加成功后，再次dump出控制文件，查看trace内容：

SQL>  alter database backup controlfile to trace;

Database altered.

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "EBANK" NORESETLOGS  ARCHIVELOG
    MAXLOGFILES 21
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 '/oracle/oradata/ebank/10g_redo01.log'  SIZE 10M,
  GROUP 2 '/oracle/oradata/ebank/10g_redo02.log'  SIZE 10M,
  GROUP 3 '/oracle/oradata/ebank/10g_redo03.log'  SIZE 10M,
  GROUP 4 '/oracle/oradata/ebank/10g_redo04.log'  SIZE 10M,
  GROUP 5 '/oracle/oradata/ebank/10g_redo05.log'  SIZE 10M,
  GROUP 6 '/oracle/oradata/ebank/10g_redo06.log'  SIZE 10M,
  GROUP 7 '/oracle/oradata/ebank/10g_redo07.log'  SIZE 10M,
  GROUP 8 '/oracle/oradata/ebank/10g_redo08.log'  SIZE 10M,
  GROUP 9 '/oracle/oradata/ebank/10g_redo09.log'  SIZE 10M
-- STANDBY LOGFILE
DATAFILE
  '/oracle/oradata/ebank/10g_system01.dbf',
  '/oracle/oradata/ebank/users01.dbf',
  '/oracle/oradata/ebank/10g_sysaux01.dbf',
  '/oracle/oradata/ebank/10g_undotbs01.dbf',
  '/oracle/oradata/ebank/tools01.dbf',
  '/oracle/oradata/ebank/tsa01.dbf',
  '/oracle/oradata/ebank/tsb01.dbf',
  '/oracle/oradata/ebank/tsc01.dbf',
  '/oracle/oradata/ebank/tsd01.dbf',
  '/ora10g/oradata/ebank/users02.dbf',
  '/ora10g/oradata/ebank/users03.dbf'
CHARACTER SET US7ASCII
;

发现MAXLOGFILES 已经变为21，可见，oracle 10g中，该参数已经可以自动调整。

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

转载于:http://blog.itpub.net/10972173/viewspace-584290/