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

Thread: archive processes appearing in ALERT log

  1. #1
    Join Date
    Apr 2001
    Posts
    257

    archive processes appearing in ALERT log

    I notice when a DB starts up, there is only one ARC0 process recorded in the ALERT log. However, after a while, I see the following lines:

    ---------------
    ARC0: Beginning to archive log# 1 seq# 2404
    Tue Dec 10 11:49:53 2002
    Thread 1 advanced to log sequence 2405
    Tue Dec 10 11:49:53 2002
    Current log# 2 seq# 2405 mem# 0: C:\ORACLE\ORADATA\SILICON1\REDO2A.LOG
    Current log# 2 seq# 2405 mem# 1: C:\ORACLE\ORADATA\SILICON1\REDO2B.LOG
    Tue Dec 10 11:49:53 2002
    ARC0: Completed archiving log# 1 seq# 2404
    ARC0: STARTING ARCH PROCESSES
    ARC1 started with pid=16
    Tue Dec 10 11:49:53 2002
    ARC0: STARTING ARCH PROCESSES COMPLETE
    Tue Dec 10 11:49:54 2002
    ARC1: Archival started
    Tue Dec 10 14:35:39 2002
    Thread 1 advanced to log sequence 2406
    Current log# 3 seq# 2406 mem# 0: C:\ORACLE\ORADATA\SILICON1\REDO3A.LOG
    Current log# 3 seq# 2406 mem# 1: C:\ORACLE\ORADATA\SILICON1\REDO3B.LOG
    Tue Dec 10 14:35:39 2002
    ARC1: Beginning to archive log# 2 seq# 2405
    ARC1: Completed archiving log# 2 seq# 2405
    -----------------

    So it appears another archive process called "ARC1" has been started. Is it because it's too busy to catch up thus another archive process is started? The log does not appear it could not catch up.

    Thanks,

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    There is currently no way to keep the number of archive processes to a specific number of processes. This is documented in [BUG:1921532] which is fixed in 8.1.7.3 and 9.0.1. This fix introduces EVENT 16155 which when set to level 1 prevents LOG_ARCHIVE_MAX_PROCESSES from being exceeded in Oracle8i.

    event="16155 trace name context forever, level 1"

    In Oracle9i the behaviour is already such that LOG_ARCHIVE_MAX_PROCESSES will not be exceeded so there is no controling event.

    The initialization parameter LOG_ARCHIVE_MAX_PROCESSES specifies the number of ARCH processes to be invoked, when LOG_ARCHIVE_START is set to TRUE. When LOG_ARCHIVE_MAX_PROCESSES is set to the default value of 1, the system determines how many ARCn processes are needed and LGWR automatically starts up more ARCn processes when the database workload requires more. In 8i it is not possible to stop further archiver processes from being started. But with the above solution, you can control the processes for the archiver and the parameter does not allow automatic spawning of ARCn processes.

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