Tuesday, March 6, 2012

ORA-16179: incremental changes

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

2 comments:

  1. And if I want to mention service then?

    ReplyDelete
    Replies
    1. Hi Ajay, Just now saw your comments ,Above one is not for standby destination, this is something related to local destination of archive logs.

      Delete