控制文件MAXDATAFILES, MAXLOGFILES, MAXLOGMEMBERS等参数的说明?

在创建数据库时，注意到这样几个参数：
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100

创建后的控制文件中包含参数：
    MAXLOGFILES 5
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 292

查询后备注留记录：
1、MAXLOGFILES

MaxLogFiles can be defined when the database is created or when the controlfile is recreated. 
The default value, if not especified, is 32, and the maximun value is 256.

2、MAXLOGMEMBERS

MaxLogMembers can be defined when the database is created or when the controlfile is recreated. 
The default value, if not especified, is 2, and the maximun value is 5.

In Oracle10g, now you can also specify the following parameters:

3、 MAXINSTANCES 

The MAXINSTANCES option of CREATE DATABASE limits the number of instances that can access a database concurrently. 
The default value for this option under z/OS is 15. Set MAXINSTANCES to a value greater than the
maximum number of instances you expect to run concurrently.


4、MAXLOGHISTORY 

The MAXLOGHISTORY option of CREATE DATABASE specifies the maximum number of redo log files that can be recorded in the log
history of the control file. The log history is used for automatic media recovery of
Oracle Real Application Clusters.
For Oracle Real Application Clusters, set MAXLOGHISTORY to a large value, such
as 100. The control file can then store information about this number of redo log
files. When the log history exceeds this limit, the Oracle server overwrites the oldest
entries in the log history. 
Setting the MAXLOGHISTORY to 0 (zero), disables log history.

5、MAXDATAFILES
    
MAXDATAFILES 在控制文件中自动扩展，但必须小于spfile中的“db_files”；


==========================================================
对这些参数11G官方文档额限定值：

Table A-1 CREATE CONTROLFILE and CREATE DATABASE Parameters

Parameter	Default	Maximum Value
MAXLOGFILES	16	255
MAXLOGMEMBERS	2	5
MAXLOGHISTORY	100	65534
MAXDATAFILES	30	65534
MAXINSTANCES	1	63

Table A-2 lists the Oracle Database file size limits in bytes.

File Type	Maximum SIze
Data files	4,194,303 multiplied by the value of the DB_BLOCK_SIZE parameter
Import/Export files and SQL*Loader files	Unlimited
Control files	192000 database blocks

==================================================================================

需要修改控制文件中的值，重建控制文件解决

1. Shutdown database; Backup database
2. Start up database
3. From sqlplus as sysdba, type: alter database backup controlfile to trace;
4. Type: shutdown immediate:
5. Go to the operating system and go to the USER_DUMP_DEST directory
6. Find the newest trace file
7. Edit the trace file and change MAXDATAFILES to the new value. You will also need to delete all of the lines prior to the line that begins: STARTUP NOMOUNT. See sample text below (the example is for a database using ARCHIVELOG):


STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "PROD3" NORESETLOGS  NOARCHIVELOG
    MAXLOGFILES 5
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 (
    '/u01/app/oracle/oradata/PROD3/redo01a.log',
    '/u01/app/oracle/oradata/PROD3/redo01b.log'
  ) SIZE 100M BLOCKSIZE 512,
  GROUP 2 (
    '/u01/app/oracle/oradata/PROD3/redo02a.log',
    '/u01/app/oracle/oradata/PROD3/redo02b.log'
  ) SIZE 100M BLOCKSIZE 512,
  GROUP 3 (
    '/u01/app/oracle/oradata/PROD3/redo03a.log',
    '/u01/app/oracle/oradata/PROD3/redo03b.log'
  ) SIZE 100M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '/u01/app/oracle/oradata/PROD3/system01.dbf',
  '/u01/app/oracle/oradata/PROD3/sysaux01.dbf',
  '/u01/app/oracle/oradata/PROD3/undotbs01.dbf',
  '/u01/app/oracle/oradata/PROD3/users01.dbf'
CHARACTER SET US7ASCII;


RECOVER DATABASE
ALTER DATABASE OPEN;
ALTER TABLESPACE TEMPTS1 ADD TEMPFILE '/u01/app/oracle/oradata/PROD3/temp01.dbf' SIZE 20971520  REUSE AUTOEXTEND OFF;


8. From sqlplus as sysdba, run the edited trace file from step 7.
9. Shutdown database and backup database

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

转载于:http://blog.itpub.net/29519108/viewspace-2143803/