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

LOG_ARCHIVE_DEST_11 through LOG_ARCHIVE_DEST_31 不支持location参数,只能使用service。

SQL> alter system set log_archive_dest_31=’/home/oracle/app/oracle/fast_recovery_area1/ORCL2/log_archive_dest_31′;

alter system set log_archive_dest_31=’/home/oracle/app/oracle/fast_recovery_area1/ORCL2/log_archive_dest_31′
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_31" not allowed with SPFILE
SQL> alter system set log_archive_dest_31=’service=orcl2′;

System altered.

Destinations LOG_ARCHIVE_DEST_11 through LOG_ARCHIVE_DEST_31 do not support the SYNC, ARCH, LOCATION, MANDATORY, or ALTERNATE attributes, and cannot be specified as the target of the ALTERNATE attribute. LOG_ARCHIVE_DEST_11 through LOG_ARCHIVE_DEST_31 can
only be used when the COMPATIBLE initialization parameter is set to 11.2.0 or higher.

Syntax       LOG_ARCHIVE_DEST_[1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 |
23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31] =
{ null_string |
{ LOCATION=path_name | SERVICE=service_name }
[ MANDATORY ]
[ REOPEN[=seconds] ]
[ DELAY[=minutes] ]
[ NOREGISTER ]
[ TEMPLATE=template ]
[ ALTERNATE=destination ]
[ MAX_FAILURE=count ]
[ SYNC | ASYNC ]
[ AFFIRM | NOAFFIRM ]
[ NET_TIMEOUT=seconds ]
[ VALID_FOR=(redo_log_type,database_role) ]
[ DB_UNIQUE_NAME ]
[ MAX_CONNECTIONS=count ]
[ COMPRESSION={ENABLE|DISABLE} ]
}

IT文库 » ORA-16179: incremental changes to "log_archive_dest_31" not allowed with SPFILE
分享到: 更多 (0)

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址