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