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;
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
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>
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