DBCREATEONLINELOGDESTn initialization parameter - Oracle Managed Files

Q.  What does the DB_CREATE_ONLINE_LOG_DEST_n initialization parameter in your initialization parameter file to identify the default location for the database server to create?
- Published on 30 Jul 15

a. Datafiles
b. Redo log files
c. Control files
d. Both A & B
e. Both B & C

ANSWER: Both B & C
 

    Discussion

  • Nirja Shah   -Posted on 01 Sep 15
    - Include the DB_CREATE_ONLINE_LOG_DEST_n initialization parameters in your initialization parameter file to identify the default locations for the database server to create:

    1. Redo log files - The most crucial structure for recovery operations is the redo log, which consists of two or more preallocated files that store all changes made to the database as they occur. Every instance of an Oracle Database has an associated redo log to protect the database in case of an instance failure.

    2. Control files - A control file is a small binary file that records the physical structure of the database and includes: The database name. Names and locations of associated datafiles and online redo log files. The timestamp of the database creation.

    - You specify the name of a file system directory or Oracle ASM disk group that becomes the default location for the creation of the files for these entities.

    - You can specify up to five multiplexed locations.

    - For the creation of redo log files and control files only, this parameter overrides any default location specified in the DB_CREATE_FILE_DEST and DB_RECOVERY_FILE_DEST initialization parameters.

    -If you do not specify a DB_CREATE_FILE_DEST parameter, but you do specify the DB_CREATE_ONLINE_LOG_DEST_n parameter, then only redo log files and control files can be created as Oracle Managed Files.

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.)