MAXLOGFILES determines maximum number of groups of redo log files - Oracle Redo Log

Discussion

• Nirja Shah   -Posted on 24 Sep 15
  - Consider the parameters that can limit the number of redo log files before setting up or altering the configuration of an instance redo log.
  
  - The following parameters limit the number of redo log files that you can add to a database:
  
  - MAXLOGFILES parameter - It is used in the CREATE DATABASE statement determines the maximum number of groups of redo log files for each database.
  - Group values can range from 1 to MAXLOGFILES.
  - When the compatibility level is set earlier than 10.2.0, the only way to override this upper limit is to re-create the database or its control file.
  - Therefore, it is important to consider this limit before creating a database.
  - When compatibility is set to 10.2.0 or later, you can exceed the MAXLOGFILES limit, and the control files expand as needed.
  - If MAXLOGFILES is not specified for the CREATE DATABASE statement, then the database uses an operating system specific default value.
  
  - MAXLOGMEMBERS parameter - It is used in the CREATE DATABASE statement determines the maximum number of members for each group.
  - As with MAXLOGFILES, the only way to override this upper limit is to re-create the database or control file.
  - Therefore, it is important to consider this limit before creating a database.
  - If no MAXLOGMEMBERS parameter is specified for the CREATE DATABASE statement, then the database uses an operating system default value.

➨ Post your comment / Share knowledge