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

Q.  Which parameter is used in the CREATE DATABASE statement that determines the maximum number of groups of redo log files for each database?
- Published on 30 Jul 15

a. MAXLOGMEMBERS
b. MAXLOGFILES
c. DEFAULT
d. Both A & B

ANSWER: MAXLOGFILES
 

    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


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)