Search This Blog

Total Pageviews

Monday, 31 October 2016

ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE

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:

Oracle DBA

anuj blog Archive