Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • v$event_name Oracle
  • Rownum with Order by Oracle
  • UNderstand and eliminate Latch contention. Oracle
  • Renaming Oracle Instance Name Oracle
  • How to find who is using which Rollback segment and how many rows or blocks in that rollback segments, Oracle
  • How does one overcome the Unix 2 Gig file limit? Linux/Unix
  • get_vmstat_linux Oracle
  • How to change hostname in Linux Linux/Unix
  • Exadata Basics Oracle
  • Which environment is used by currently running process ( Very good) Linux/Unix
  • Pending Transaction Neighbors Script Oracle
  • ORA-8031 issue and solution if it is occuring due to truncate. Oracle
  • Privileges Required to Create Procedures and Functions that uses objects from other schema. Oracle
  • Good notes for shared pool Oracle
  • Benefits and Usage of RMAN with Standby Databases 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

  • Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
  • ENQ: KO – FAST OBJECT CHECKPOINT tips Oracle
  • find_log_switch.sql Find log switches in graphical manner Oracle
  • Alter procedure auditing Oracle
  • Exadata Basics Oracle
  • get_vmstat.ksh for Solaris 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 (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • CTAS with LONG Column for 7.x and 8 and 8i Oracle
  • standard Monitoring – 1 Oracle
  • move_arch_files.ksh Linux/Unix
  • UNderstand and eliminate Latch contention. Oracle
  • Building Our Own Namespaces with “Create Context” Oracle
  • Zip and unzip with tar Linux/Unix
  • Drop tempfiles from database Oracle
  • Committing distributed transaction using commit force Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme