Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Error Handling in Proc Oracle
  • Find_stale_dr.sql finding stale physical DR.. Oracle
  • Session_info.ksh Linux/Unix
  • Example of How To Resize the Online Redo Logfiles Note:1035935.6 Oracle
  • To Find Orphan OS processes. Linux/Unix
  • 556976.1 Oracle Clusterware: Components installed Oracle
  • purge_trc.sh Linux/Unix
  • Giving Grant on v$DATABASE Oracle
  • tuning commmand for cpu, ip and memory stats Linux/Unix
  • TOP-N Sql to find Nth max or Top N rows Oracle
  • Temporary tablespace explaination Oracle
  • send attachment from unix-shell script Linux/Unix
  • Default User Profile Oracle
  • ext#.sql Oracle
  • Find_planinfo.sql Oracle

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

Posted on 03-Mar-2010 By Admin No Comments on 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

Oracle, SQL scripts

Post navigation

Previous Post: Sending SQLPLUS output in HTML format
Next Post: Oracle Release Explaination

Related Posts

  • sesswait.sql Oracle
  • SYSOPER Mystery Oracle
  • DBMS_JOB all example Oracle
  • Oracle 10g Wait Model Oracle
  • Find sort details from Db find_sort.sql Oracle
  • DBMS_SQL for alter session. Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Metalink Note: Note:250655.1 : ADDM Basics USING THE AUTOMATIC DATABASE DIAGNOSTIC MONITOR Oracle
  • block_ident.sql Oracle
  • Running some SQL on multiple databases connecting using monitoring userid and password Linux/Unix
  • Unix command for system configuration Linux/Unix
  • checking redhat linux version Linux/Unix
  • Roles and Stored Object behaviour Oracle
  • V$ROLLSTAT status is Full Oracle
  • How does one SELECT a value from a table into a Unix variable? From SQL to Shell Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme