Cause :- Modifying log_archive_dest_2 will return this error for invalid
syntax. This parameter is dynamic and can be changed using the ALTER
SYSTEM/ALTER SESSION statement.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='D:\app\oradata\ARCHIVE2' SCOPE=BOTH;
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='D:\app\oradata\ARCHIVE2' SCOPE=BOTH
*
ERROR AT LINE 1:
ORA-32017: FAILURE IN UPDATING SPFILE
ORA-16179: INCREMENTAL CHANGES TO "log_archive_dest_2" NOT ALLOWED WITH SPFILE
Correct Syntax is
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='LOCATION=D:\app\oradata\ARCHIVE2' SCOPE=BOTH;
SYSTEM ALTERED.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='D:\app\oradata\ARCHIVE2' SCOPE=BOTH;
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='D:\app\oradata\ARCHIVE2' SCOPE=BOTH
*
ERROR AT LINE 1:
ORA-32017: FAILURE IN UPDATING SPFILE
ORA-16179: INCREMENTAL CHANGES TO "log_archive_dest_2" NOT ALLOWED WITH SPFILE
Correct Syntax is
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='LOCATION=D:\app\oradata\ARCHIVE2' SCOPE=BOTH;
SYSTEM ALTERED.
i m setting the parameters of dataguard and its giving err,plz check :
ReplyDeletealter system set log_archive_dest_1='location=E:\app\Dell\flash_recovery_area\ssdn\ARCHIVELOG\valid_for=(all_logfiles,all_roles) db_unique_name=ssdn' scope=spfile;
for datagurd you have to configure two parameter 1 for primary database and 2 for standby database. Please follow this two parameter.
ReplyDelete*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=erpdrb'
*.log_archive_dest_2='SERVICE=erpdcb LGWR ASYNC NOAFFIRM DELAY=0 OPTIONAL COMPRESSION=ENABLE MAX_FAILURE=0 MAX_CONNECTIONS=1 REOPEN=180 NET_TIMEOUT=30 DB_UNIQUE_NAME="erpdcb", VALID_FOR=(ALL_LOGFILES,PRIMARY_ROLE)'
SQL> alter system SET log_archive_dest_2='LOCATION =/u01/app/oracle/oradata/ORCL/archive_dir2'
ReplyDelete2 SCOPE = both;
alter system SET log_archive_dest_2='LOCATION =/u01/app/oracle/oradata/ORCL/archive_dir2'
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_2" not allowed
with SPFILE