DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Slow Archiving

  1. #1
    Join Date
    Mar 2003
    Posts
    34

    Slow Archiving

    Hi,

    I have O9i Prod & stdby DB. On Prod DB I have 9 Redo Log groups with 1 member each with 50MB each. The Stdby DB is config for Max Performance mode. Whenever there is a heavy lod on the DB than the Archiving process becomes very slow. At that time if I chk the alert log file, I see the following msg:
    "ARC1: Unable to archive log 4 thread 1 sequence 9587
    Log actively being archived by another process"

    Following para are set on the prod DB:

    -->log_archive_max_processes = 4

    --> archive_lag_target = 3600

    - log_archive_dest_2 service="(DESCRIPTION=(ADDRESS
    _LIST = (ADDRESS=(PROTOCOL=tcp
    )(HOST=xxx.xxx.x.xx)(PORT=1521
    )))(CONNECT_DATA=(SID=xx)(OR
    ACLE_HOME=/oracle/ora9/OraHome
    )(SERVER=DEDICATED)))", ARCH S
    YNC NOAFFIRM delay=180 OPTIONA
    L max_failure=0 reopen=300


    Please advice.

    Alet pls let me know that in the max perf mode for stby db:
    1) does Arch process creates the Arch log files 1st on the Prim & then on the Stdby & after that it creates the next Archive log
    or
    2)does the Arch process creates the Arch log files simultaneously on both DB & after that it creates the next Archive log
    or
    3) 1st Arch process creates the Arch log files the Prim & then creates the next Archive log on Prim independent of the Archive log copy on the Stdby


    Thank You.

  2. #2
    Join Date
    May 2001
    Posts
    736
    The reason for
    ARC1: Unable to archive log 4 thread 1 sequence 9587
    Log actively being archived by another process
    is there are more than one archive process trying to write the log file.
    There are so many reasons behind slow archiving.To get some idea about stand by especially in max performance mode check the following document which clarify some of ur doubts.
    http://64.233.183.104/search?q=cache...nce+mode&hl=en

  3. #3
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    Increase size of the redo log file.

  4. #4
    Join Date
    Mar 2003
    Posts
    34

    Slow Archiving

    Dear Friend,

    as u said that the reason for
    ARC1: Unable to archive log 4 thread 1 sequence 9587
    Log actively being archived by another process
    is there are more than one archive process trying to write the log file, so do I need to change the para "log_archive_max_processes", ie, do I need to increase or decrease it.

    Thank You.

  5. #5
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142

    Re: Slow Archiving

    Originally posted by sadiq
    ARC1: Unable to archive log 4 thread 1 sequence 9587
    Log actively being archived by another process
    is there are more than one archive process trying to write the log file, so do I need to change the para "log_archive_max_processes", ie, do I need to increase or decrease it.
    This is not a problem - you will see a success message following it - I wouldn't change anything because of this.

    Are you seeing any other warning/error messages in the alrt.log? (e.g. Check point not complete.)

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