ORA-16179: incremental changes to "log_archive_dest_2" not allowed with SPFILE
You can simply avoid this error by cross checking your command once again.
Use your command like this
SQL>ALTER SYSTEM SET log_archive_dest_2 = 'LOCATION=/OPT/ARC' SCOPE=SPFILE;
Cheers!!!
And if I want to mention service then?
ReplyDeleteHi Ajay, Just now saw your comments ,Above one is not for standby destination, this is something related to local destination of archive logs.
Delete