WARNING: db_recovery_file_dest is same as db_create_online_log_dest_2

 

The warning message on Alert log file mean both the FRA – Flash Recovery Area and Online Log are same.

It can be verified by

SQL> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +DG_DEV_FLASH_01
db_recovery_file_dest_size         big integer 220G
recovery_parallelism                 integer     0

SQL> show parameter online

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_create_online_log_dest_1          string      +DG_DEV_DATA_01
db_create_online_log_dest_2          string      +DG_DEV_FLASH_01
db_create_online_log_dest_3          string
db_create_online_log_dest_4          string
db_create_online_log_dest_5          string