19. You are using an Automatic Storage Management (ASM) instance to m

anage the files of your production database. You have two disk groups

, DG1and DG2 with one device each. In the parameter file of the produ

ction 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 di

sk group.

B. When a new log group is added, it would have two members in each d

isk group.

C. When a new tablespace is added, it would have one data file in eac

h disk group.

D. When a new log file is added, it would have one member spread acro

ss the disk groups.

Answer: A

DB_CREATE_ONLINE_LOG_DEST_1 = '+dg1'

DB_CREATE_ONLINE_LOG_DEST_2 = '+dg2'

当一个新的日志组加入了以后，会在每个磁盘组中有个成员。

Editor’s notes:

DB_CREATE_ONLINE_LOG_DEST_n (where n = 1, 2, 3, ... 5) 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.

ITPub博客

043-019