Saturday, May 23, 2020

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

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

Note:- 
Typically this message/error  occur when we used the wrong command while changing the archivelog location.


SQL> select name ,database_role from v$database;
NAME      DATABASE_ROLE
--------- ----------------
TSTDB     PRIMARY



SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     50
Next log sequence to archive   51
Current log sequence           51

SQL>


I am trying to change the archive log destination and I met to a error with below message

SQL> alter system set log_archive_dest_1='+RECO/TSTDB/ARCH' scope=both;
alter system set log_archive_dest_1='+RECO/TSTDB/ARCH' 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


What i did here wrong , After looking command cautiously i go to know that i used wrong syntax to change the log_archive_dest_1


SQL>  alter system set log_archive_dest_1='location=+RECO/TSTDB/ARCH' scope=both;

System altered.

Now i can change the archive log destination.


SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +RECO/tstdb/arch ---------> New location for archivelog
Oldest online log sequence     50
Next log sequence to archive   51
Current log sequence           51

SQL>


EOD

No comments:

Post a Comment