ORA-16028: new LOG_ARCHIVE_DEST_STATE_2 causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ALTERNATE SCOPE=BOTH;
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ALTERNATE SCOPE=BOTH
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16028: new LOG_ARCHIVE_DEST_STATE_2 causes less destinations than
LOG_ARCHIVE_MIN_SUCCEED_DEST requires

This is due to log_archive_dest_1 is deferred.

SQL> SELECT DEST_NAME,STATUS,DESTINATION
FROM V$ARCHIVE_DEST
WHERE DESTINATION IS NOT NULL;

DEST_NAME           STATUS       DESTINATION
————————————————————
LOG_ARCHIVE_DEST_1  DEFERRED    /oradb/archives
LOG_ARCHIVE_DEST_2  VALID    /u01/oradb/TESTDB/arch

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1=ENABLE SCOPE=BOTH;

System altered.

SQL> SELECT DEST_NAME,STATUS,DESTINATION
FROM V$ARCHIVE_DEST
WHERE DESTINATION IS NOT NULL;

DEST_NAME           STATUS       DESTINATION
————————————————————
LOG_ARCHIVE_DEST_1  VALID    /oradb/archives
LOG_ARCHIVE_DEST_2  VALID    /u01/oradb/TESTDB/arch

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ALTERNATE SCOPE=BOTH;

System altered.

SQL> SELECT DEST_NAME,STATUS,DESTINATION
FROM V$ARCHIVE_DEST
WHERE DESTINATION IS NOT NULL;

DEST_NAME           STATUS       DESTINATION
————————————————————
LOG_ARCHIVE_DEST_1  VALID    /oradb/archives
LOG_ARCHIVE_DEST_2  ALTERNATE    /u01/oradb/TESTDB/arch

  • June 27, 2016 | 16 views
  • Comments