Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

log_archive_dest

user13364377Oct 20 2010 — edited Nov 29 2016
hi,

db:10.2.0.4
OS:windows 7

I am unable to set the location of archivelog file using the parameter log_archive_dest.

I am getting the following error.

SQL> alter system set log_archive_dest='location=d:\archivelog';
alter system set log_archive_dest='location=d:\archivelog'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or
DB_RECOVERY_FILE_DEST


When I use the parameter log_archive_dest_1 parameter, I am able to set the location for the archive files.

SQL> show parameter log_archive_dest_1;

NAME TYPE VALUE
------------------------------------ ----------- ---------------------------
log_archive_dest_1 string location=d:\archivelog
log_archive_dest_10 string


why is it so
This post has been answered by user13364377 on Oct 20 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 17 2010
Added on Oct 20 2010
3 comments
1,372 views