Post date: 02-Sep-2009 11:13:22
Oracle Server - Enterprise Edition - Version: 11.1.0.6
This problem can occur on any platform.
-- Problem Statement:
Archive logs are being written to a default location, even when the following conditions are met:
.
- LOG_ARCHIVE_DEST is not set
- LOG_ARCHIVE_DEST_n is not set
- DB_RECOVERY_FILE_DEST is set
This is contrary to the documentation:
.
"If you do not set any value for LOG_ARCHIVE_DEST, LOG_ARCHIVE_DEST_n, or DB_RECOVERY_FILE_DEST, then the redo logs are archived to a default location that is platform-specific."
-- Steps To Reproduce:
- Create 11.1.0.6 database using DBCA
- Click "enable archiving" in DBCA
.
After DBCA completes, connect to the database and issue the following queries:
SQL> show parameter log_archive_dest
-- There should be no values for log_archive_dest or log_archive_dest_n.
.
SQL> show parameter db_recover
-- There should be values for the FRA and its size, from DBCA.
.
SQL> col dest_name format a20
SQL> col destination format a48
SQL> select dest_name, destination from v$archive_dest;
-- There should be values in LOG_ARCHIVE_DEST_1 (default location), and LOG_ARCHIVE_DEST_10 (USE_DB_RECOVERY_FILE_DEST).
.
From this one can see that:
.
- LOG_ARCHIVE_DEST is not set
- LOG_ARCHIVE_DEST_n is not set (as a parameter)
- DB_RECOVERY_FILE_DEST is set
.
However, LOG_ARCHIVE_DEST_1 has a value as seen in v$archive_dest.
-- Business Impact:
This is causing higher disk space utilization by archive logs than desired.
The issue has been reported in Bug 6373164 - Abstract: LOG_ARCHIVE_DEST_1 SET TO DEFAULT EVEN WHEN DB_RECOVERY_FILE_DEST IS SET
This bug is fixed in 11.2 and in 11.1.0.7.
-- To implement the solution, please execute the following steps::
Explicitly set LOG_ARCHIVE_DEST_1 to LOCATION=USE_DB_RECOVERY_FILE_DEST.
The bug will be fixed by 11.1.0.7 patchset and in 11gR2.
Bug 6373164 - LOG_ARCHIVE_DEST_1 SET TO DEFAULT EVEN WHEN DB_RECOVERY_FILE_DEST IS SET
Note 297397.1 - How to disable use of Flash Recovery Area for Archivelogs and Backups
LOG_ARCHIVE_DEST_1 ; SIZING ; ARCHIVED~LOGS ; FRA ; DBCA ; LOG_ARCHIVE_DEST_N ; V$ARCHIVE_DEST ; SIZING ; V$ARCHIVE_DEST ;