Examine the following parameter settings from an initialization (init.oraa)file:
DB_CREATE_FILE_DEST = ‘/u01/oradata/’
DB_CREATE_ONLINE_LOGDEST 1 = ‘/u02/oradata/’
DB_CREATE_ONLINE_LOG_DEST2 = ‘/u03/oradata/’
If you create an Oracle Managed Files (OMF) database using these settings, what is the result?
A.
The data files, temp files, and control file will be on device/u01; one online redo log group will be on device /u02; another redo log group will be on device/u03.
B.
The data files and temp files will be on device /u02; another copy of the control file and one online redo log group will be on device /u02; another copy of the control file and a second redo log group will be on device /u03.
C.
The data filesm temp files, online redo log files and control file will be on device/u01;multiplexed copies of the archive log files will be created; one set on device /u02, and another set on device /u03.
D.
The data files and temp files will be on device/u01; one copy of the control file and the first member in each online redo log group will be on device/u02; another copy of the control file and a second member of each redo log group will be on device /u03.
Explanation:
a – DB_CREATE_FILE_DEST sets the default location for datafile, control file, and online log creation.
* Datafiles
* Tempfiles
* Redo log files
* Control files
* Block change tracking files
You specify the name of a file system directory that becomes the default location for the creation of the operating system files for these entities. b – DB_CREATE_ONLINE_LOG_DEST_n initialization parameter in your initialization parameter identify the default location for the database server to create:* Redo log files
* Control files
You specify the name of a file system directory that becomes the default location for the creation of the operating system 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.
REF.: Oracle(r) 10g Administrator Guide, 11-5