The Instance Initialization parameters are set to:
DB_CREATE_FILE_DEST = +DATA
DB_CREATE_ONLlNE_LOG_DEST_1 = +LOGS
DB_CREATE_ONLlNE_LOG_DEST_2 = +FRA
The SQL* Plus command ALTER DATABASE ADD LOGFILE; will create:
A.
a new log file in the +DATA disk group, or a log file in the + FRA disk group, if +DATA is not available
B.
a new log file in the +DATA disk group and a log file in the + FRA disk group
C.
a new log file in the +LOGS disk group and a log file in the + FRA disk group
D.
a new log file in the +LOGS disk group, or a log file in the +FRA dls* available
E.
a new log file in the +DATA disk group, a log file in the +LOGS disk group, and a log file in the +FRA disk group
F.
a new log file in the +LOGS disk group, or a log file in the +FRA disk group, if+LOGS is not available