What would be the impact of this setting?

You are using an Automatic Storage Management (ASM) instance to manage the files of
your production database. You have two disk groups, DG1and DG2with 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?

You are using an Automatic Storage Management (ASM) instance to manage the files of
your production database. You have two disk groups, DG1and DG2with 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 table space 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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *