今天在刚安装完的应用上面，修改归档日志的路劲，顺便记录下：

SQL> alter system set log_archive_dest_1='/u01/archive' scope=both;

alter system set log_archive_dest_1='/u01/archive' scope=both

*

ERROR at line 1:

ORA-32017: failure in updating SPFILE

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

后来发现，在该修改的参数后面，需要增加location

SQL> alter system set log_archive_dest_1='location=/u01/archive' scope=both;

System altered.

SQL>

SQL> alter system set log_archive_format='arch_%s_%R_%T.arc' scope=spfile;

System altered.

SQL>

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /u01/archive

Oldest online log sequence 9

Next log sequence to archive 11

Current log sequence 11

SQL>