修改log_archive_dest_1参数出错:ORA-16179

修改log_archive_dest_1参数时出错

SQL> alter system set log_archive_dest_1='/u01/app/oracle/fra';
*alter system set log_archive_dest_1='/u01/app/oracle/fra'
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE

第 1 行出现错误:
ORA-32017: 更新 SPFILE 时失败
ORA-16179: 不允许使用 SPFILE 对 “log_archive_dest_1” 进行增量更改

[oracle@localhost bin]$ oerr ora 16179
16179, 00000, "incremental changes to \"%s\" not allowed with SPFILE"
// *Cause:  Incremental changes to a log_archive_dest_n parameter cannot
//          be made when using an SPFILE.
// *Action: Specify either LOCATION or SERVICE plus all other attributes
//          to be set in one ALTER SYSTEM/SESSION SET command.

更改为:
alter system set log_archive_dest_1=‘location=e:\oracle11g\archivelog’;

姚远ACE CSDN认证博客专家 ACE 华为云 MVP
Oracle ACE,华为云 MVP,Oracle10g,12c OCM; MySQL 5.6,5.7,8.0 OCP;CCNA; EMC Certified; IBM P Certified; RHCE; SQLServer 764; DB2 Certified; TOEIC 890;获得过两次国家部级科技进步奖;发明过两项计算机专利。微信:yaoyuanace 邮箱:yaoyuanace(at)qq.com
已标记关键词 清除标记
©️2020 CSDN 皮肤主题: Age of Ai 设计师:meimeiellie 返回首页