ERROR:
SQL> alter system set log_archive_dest_1='/oradata/archive' scope=spfile;
alter system set log_archive_dest_1='/oradata/archive' 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
Solutions:
SQL> alter system set log_archive_dest_1='location=/oradata/archive' scope=both;
System altered.
No comments:
Post a Comment