This content has been marked as final. Show 3 replies
The biggest advantage of using ASM is that you don't have the need to multiplex redo as it is automatically striped across all the disks in your disk group. I don't believe you have to make a choice, however, between your Data and FRA diskgroups. If you are concerned about create two disk members per group for your redo logs. Set the following parameters in your spfile:
db_create_online_log_dest_1 = +DATA_DG
db_create_online_log_dest_2 = +FRA
Once set, you can greate redo logs - mirrored across both DGs.
- alter database add logfile size 100m;
Which will add the next logical redo log group, mirrored across both the DGs listed in the parameters above.
Control files can also be put across diskgroups if you like, however, if you lost your DATA_DG you would be SOL anyway, but there is no reason not to.
Allocation of separate physical_disk as disk to disk groups gives better performance. It's suggested to avoid creating partitions in physical disk and allocating to disk groups....Just my 2 cents.