DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, June 27, 2016

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

No comments: