ORA-16179 incremental changes to “log_archive_dest_10” not allowed with SPFILE

You might encounter ORA-16179 error while changing the archive destination.

SQL> alter system set log_archive_dest_10='d:\oracle\arc\dbtest\';
alter system set log_archive_dest_10='d:\oracle\arc\dbtest\'
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_10" not allowed with SPFILE

There is syntax error in above command .

It should be like log_archive_dest_n [n is a integer from 1 to 31]=’LOCATION=path_for_archive_log’

example :

SQL> alter system set log_archive_dest_10='LOCATION=d:\oracle\arc\dbtest\';

System altered.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp