Alert Log Warning : Warnings: Db_recovery_file_dest Is Same As Db_create_onli...

刘泽宇

目标：
This Doc explains about the warning message in the alert log "Warnings: db_recovery_file_dest is same as db_create_online_log_dest_2"


处理方法：
Oracle recommends that DB_RECOVERY_FILE_DEST not same as DB_CREATE_FILE_DEST or any of the DB_CREATE_ONLINE_LOG_DEST_n parameters. A warning will appear in the alert log if it is done .


This is harmless warning ,can be ignored. But please keep in mind that db_recovery_file_dest is Flash recovery area, It is always recommended to put database(controlfile, datafiles, redo) in a different location that is DB_CREATE_FILE_DEST, and better to put archives & backups in recovery location that is DB_RECOVERY_FILE_DEST.


A sample test result shows the same

This is the current setting

SQL> show parameter db_create_file

NAME                                   TYPE                     VALUE
------------------------------------ -----------              --------------------------
db_create_file_dest                    string                  /u02/oracle/oradata
db_create_online_log_dest_1            string

SQL> show parameter recovery

NAME                                   TYPE                    VALUE
------------------------------------ -----------              ------------------------------
db_recovery_file_dest                 string                  /u02/oracle/ora11204/fast_recovery_area



db_create_online_log_dest_1 value is not set here.

Now after setting it same as db_recovery_file_dest

SQL> alter system set db_create_online_log_dest_1='/u02/oracle/ora11204/fast_recovery_area' scope=BOTH;

System altered.

SQL> host date
Fri Nov 4 04:58:48 EDT 2016

Alert log showing warning

Fri Nov 04 04:58:46 2016
WARNING: db_create_online_log_dest_1 is same as db_recovery_file_dest
ALTER SYSTEM SET db_create_online_log_dest_1='/u02/oracle/ora11204/fast_recovery_area' SCOPE=BOTH;