DBCREATEONLINELOGDESTn - Default disk group location - Oracle Control Files

Q.  Which initialization Parameter Specifies the default disk group location to create the following files?

1) Redo log files
2) Control files
- Published on 12 Aug 15

a. DB_CREATE_ONLINE_LOG_DEST_n
b. DB_CREATE_FILE_DEST
c. DB_RECOVERY_FILE_DEST
d. CONTROL_FILES

ANSWER: DB_CREATE_ONLINE_LOG_DEST_n

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 28 Aug 15
    - DB_CREATE_ONLINE_LOG_DEST_n - It specifies the default location for Oracle-managed control files and online redo logs.
    - If more than one DB_CREATE_ONLINE_LOG_DEST_n parameter is specified, then the control file or online redo log is multiplexed across the locations of the other DB_CREATE_ONLINE_LOG_DEST_n parameters.
    - One member of each online redo log is created in each location, and one control file is created in each location.

    -DB_CREATE_FILE_DEST - It specifies the default disk group location in which to create data and temp files.

    - DB_RECOVERY_FILE_DEST - It specifies a default disk group for a fast recovery area that contains a copy of the control file and redo log files if this parameter is specified and DB_CREATE_ONLINE_LOG_DEST_n and CONTROL_FILES are not specified.

    -CONTROL_FILES - It specifies a disk group in which to create control 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.)
▲