SQL> alter system set log_archive_dest_1='d:\archive\' scope=spfile;
alter system set log_archive_dest_1='d:\ora\' 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
When i try to enable Archivelog mode in production server, i faced this ORA-16179.
production server is version 10.1.0.2 and host is solaris sparc 64bit.
Cause:
Incremental changes to a log_archive_dest_n parameter cannot be made when using an SPFILE.
Solution:
Specify either LOCATION or SERVICE plus all other attributes to be set in one ALTER SYSTEM/SESSION SET command.
Action :
SQL> ALTER SYSTEM SET log_archive_dest_1 = 'LOCATION=/db1/archive';
System altered.
Reff: Metalink Doc ID: 194494.1
No comments:
Post a Comment