ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE ...
SQL> alter system set log_archive_dest_1='+LOGS' SCOPE=SPFILE;
alter system set log_archive_dest_1='+LOGS' SCOPE=SPFILE
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE
------ use "LOCATION" variable with LOG_ARCHIVE_DEST_1 parameter
SQL> ALTER SYSTEM SET log_archive_dest_1='LOCATION=+LOGS';
System altered.
No comments:
Post a Comment