Automatic Storage Management (ASM) - Oracle Control Files

Q.  You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. You have two disk groups, DG1 and DG2, with one device each. In the parameter file of the production database, the following parameters have been specified

DB_CREATE_ONLINE_LOG_DEST_1 = '+dg1'
DB_CREATE_ONLINE_LOG_DEST_2 = '+dg2'

What would be the impact of this setting?

- Published on 03 Aug 15

a. When a new log group is added, it would have one member in each disk group
b. When a new log group is added, it would have two members in each disk group
c. When a new tablespace is added, it would have one data file in each disk group
d. When a new log file is added, it would have one member spread across the disk groups

ANSWER: When a new log group is added, it would have one member in each disk group

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