1 Reply Latest reply: Apr 14, 2013 5:40 PM by user8875620 RSS

    rollback a dataguard parameter

    user8875620
      I am trying to roll back my data guard setup parameters while primary database is online.
      But I cannot make destination 2 back to NULL (blank)


      SQL> alter system set log_archive_dest_2=null scope=both;
      alter system set log_archive_dest_2=null 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