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!

Archive Dest error

AAPFeb 23 2012 — edited Feb 23 2012

Hi,

Oracle 10g on windows xp
When trying to add new 4rth archive dest...after 1, 2, and use_db_recovery_dest, Which I had given throuhg EM, following error erupts when trying to give from command prompt and when my database is up...

SQL> alter system set log_archive_dest_3="d:\arch\ optional reopen=300" scope=both;
alter system set log_archive_dest_3="d:\arch\ optional reopen=300" scope=both
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_3" not allowed with SPFILE

what is wrong....
Thanks and Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 22 2012

Added on Feb 23 2012

#error, #general-database-discussions

4 comments

862 views