修改归档文件路劲

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

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> 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8541492/viewspace-768299/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8541492/viewspace-768299/