DBCREATEONLINELOGDESTn - Definition - Oracle Managed Files

Q.  Which initialization parameter Defines the location of the default file system directory for redo log files and control file creation when no file specification is given in the creation operation?
- Published on 04 Aug 15

a. DB_CREATE_FILE_DEST
b. DB_CREATE_ONLINE_LOG_DEST_n
c. DB_RECOVERY_FILE_DEST
d. None of the above

ANSWER: DB_CREATE_ONLINE_LOG_DEST_n
 

    Discussion

  • Nirja Shah   -Posted on 01 Sep 15
    - The following lists the initialization parameters that enable the use of Oracle Managed Files.

    - DB_CREATE_FILE_DEST - Defines the location of the default file system directory or Oracle ASM disk group where the database creates data files or temp files when no file specification is given in the create operation.
    - Also used as the default location for redo log and control files if DB_CREATE_ONLINE_LOG_DEST_n are not specified.

    - DB_CREATE_ONLINE_LOG_DEST_n - Defines the location of the default file system directory or Oracle ASM disk group for redo log files and control file creation when no file specification is given in the create operation. By changing n, you can use this initialization parameter multiple times, where n specifies a multiplexed copy of the redo log or control file.
    - You can specify up to five multiplexed copies.

    - DB_RECOVERY_FILE_DEST - Defines the location of the Fast Recovery Area, which is the default file system directory or Oracle ASM disk group where the database creates RMAN backups when no format option is used, archived logs when no other local destination is configured, and flashback logs.
    - Also used as the default location for redo log and control files or multiplexed copies of redo log and control files if DB_CREATE_ONLINE_LOG_DEST_n are not specified.

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