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_1" not allowed with SPFILE

521578Aug 7 2007 — edited Aug 7 2007

Good day,

I am trying the following commaind in my oracle 9i

alter system set log_archive_dest_1 ='D:\archive1 MANDATORY' SCOPE=BOTH;

and getting following error message
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE

My database is already in archive log mode using Archive_log_dest ='D:\archive'

Please guide me how to achive this.

Regards
Anshuman

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 4 2007

Added on Aug 7 2007

#general-database-discussions

7 comments

800 views