How to specify 2 arch location to avoid any kind of DB hanging.

Scenario:

I wish to configure two locations for log archives in the way that archives should get stored on location “A” and when it gets filled or become unavailable due to any reason then logs should automatically start using location “B” for onward.

In short failure of location A should start storing archives on location B.

But clearly I do not want duplex etc..

Solution:

clear screen;

ALTER SYSTEM SET LOG_ARCHIVE_DEST_2=’LOCATION=C:ARCHIVE2′ SCOPE=BOTH;

ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ALTERNATE SCOPE=BOTH;

ALTER SYSTEM SET LOG_ARCHIVE_DEST_1=’LOCATION=C:ARCHIVE1 REOPEN=1 MAX_FAILURE=1 ALTERNATE=LOG_ARCHIVE_DEST_2′ SCOPE=BOTH;

ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1=enable SCOPE=BOTH;

column dest_name format a30;

column status format a20;

column destination format a50;

set linesize 300;

SELECT dest_name, status, destination FROM v$archive_dest