ARCH process terminating and Log Shipping to Standby Failing
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ARCH process terminating and Log Shipping to Standby Failing

  1. #1
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184

    ARCH process terminating and Log Shipping to Standby Failing

    --------------------------------------------------------------------------------

    Dear All,

    O.S.: Windows 2000 Server

    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    PL/SQL Release 9.2.0.1.0 - Production
    CORE 9.2.0.1.0 Production
    TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
    NLSRTL Version 9.2.0.1.0 - Production

    I have a Dataguard Setup with managed recovery.

    Yesterday i got the below error in alert.log of Primary:

    Creating archive destination LOG_ARCHIVE_DEST_2: 'fnostby'
    Creating archive destination LOG_ARCHIVE_DEST_1: 'F:\ORACLE\ORADATA\FNO\ARCH\LOG_114727.ARC'
    Wed Oct 18 17:52:10 2006
    ARC4: Completed archiving log 4 thread 1 sequence 14724
    ARC4: Evaluating archive log 5 thread 1 sequence 14725
    ARC4: Unable to archive log 5 thread 1 sequence 14725
    Log actively being archived by another process
    ARC4: Evaluating archive log 1 thread 1 sequence 14726
    ARC4: Unable to archive log 1 thread 1 sequence 14726
    Log actively being archived by another process
    ARC4: Evaluating archive log 2 thread 1 sequence 14727
    ARC4: Unable to archive log 2 thread 1 sequence 14727
    Log actively being archived by another process
    ARC4: Evaluating archive log 5 thread 1 sequence 14725
    ARC4: Unable to archive log 5 thread 1 sequence 14725
    Log actively being archived by another process
    ARC4: Evaluating archive log 1 thread 1 sequence 14726
    ARC4: Unable to archive log 1 thread 1 sequence 14726
    Log actively being archived by another process
    ARC4: Evaluating archive log 2 thread 1 sequence 14727
    ARC4: Unable to archive log 2 thread 1 sequence 14727
    Log actively being archived by another process
    Wed Oct 18 17:53:26 2006
    ARC3: I/O error 3114 archiving log 5 to 'fnostby'
    Wed Oct 18 17:53:26 2006
    Errors in file e:\oracle\admin\fno\bdump\fno_arc3_1964.trc:
    ORA-03114: not connected to ORACLE

    ARC3: Completed archiving log 5 thread 1 sequence 14725
    ARC3: Evaluating archive log 1 thread 1 sequence 14726
    ARC3: Unable to archive log 1 thread 1 sequence 14726
    Log actively being archived by another process



    ARC4: I/O error 3115 archiving log 4 to 'fnostby'
    Thu Oct 26 17:12:18 2006
    Errors in file e:\oracle\admin\fno\bdump\fno_arc4_1952.trc:
    ORA-03115: unsupported network datatype or representation


    ARC4: Evaluating archive log 2 thread 1 sequence 14962
    ARC4: Beginning to archive log 2 thread 1 sequence 14962
    Creating archive destination LOG_ARCHIVE_DEST_2: 'fnostby'
    Thu Oct 26 17:17:19 2006
    LGWR: Detected ARCH process failure
    LGWR: Detected ARCH process failure
    LGWR: STARTING ARCH PROCESSES
    Thu Oct 26 17:17:19 2006
    ARC2: Evaluating archive log 1 thread 1 sequence 14960
    ARC2: Unable to archive log 1 thread 1 sequence 14960
    Log actively being archived by another process
    ARC2: Evaluating archive log 5 thread 1 sequence 14961
    ARC2: Unable to archive log 5 thread 1 sequence 14961
    Log actively being archived by another process


    After which the Log shipping stopped to the Standby Location and archives are not generated on the Primary Site Also.

    However after i cancel the managed recovery on STandby database and defer the log_archive_dest_state_2 on primary database, it starts generating archives on primary.

    Please advise as to how to got about resolving this issue, so that things return to normal state.

  2. #2
    Join Date
    Jun 2006
    Location
    Chennai, INDIA
    Posts
    72
    Hi,
    Was there any change made to the protocol of the connection "fnostby" in tnsnames.ora?

    Have u tried tnsping fnostby to validate the connection?

  3. #3
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Quote Originally Posted by Kamkan
    Hi,
    Was there any change made to the protocol of the connection "fnostby" in tnsnames.ora?

    Have u tried tnsping fnostby to validate the connection?

    tnsping fnostby is working fine !!!

  4. #4
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Anybody with their valuable inputs ???

  5. #5
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184

    Dataguard Issue Workaround suggested by ORACLE !!!

    Dear All,

    I finally raised an SR to oracle regarding the above issue.

    They suggessted me to upgrade to latest patchset i.e. 9.2.0.8.0.

    Has anybody tried Oracle 9.2.0.8.0 Enterprise Edition on Windows 2000 Server?

    Revert back with any inputs ...

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    how about you try it in your test environment to see how it works for you, anyone elses experience with it is worthless

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width