1
SQL> alter system set log_archive_dest_1='/u02/oracle/arch/' scope=spfile;
alter system set log_archive_dest_1='/u02/oracle/arch/' 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
2
SQL> alter system set log_archive_dest_state_1='/u02/oracle/arch/' scope=spfile;
alter system set log_archive_dest_state_1='/u02/oracle/arch/' scope=spfile
*
ERROR at line 1:
ORA-
00096: invalid value /u02/oracle/arch/ for parameter
log_archive_dest_state_1, must be from among alternate, reset, defer, enable
解决： 少了一个
location
SQL> alter system set log_archive_dest_1='
location=/u02/oracle/arch/' scope=spfile;
System altered
