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

Thread: Archive process

  1. #1
    Join Date
    Dec 2002
    Location
    sydney
    Posts
    10

    Archive process

    Hi

    I have aproduction database version 8.1.7.4, when i start the database it is started with 1 archive process. From alert log, it start 2nd and 3rd archive process ie
    ARC0: Completed archiving log# 3 seq# 67397
    ARC0: STARTING ARCH PROCESSES
    ARC1 started with pid=125
    ARC1: Archival started
    Tue Sep 2 12:00:24 2003

    when it ARC1 starts to archive log say #67399
    ARCO also attempts to start but fails, so on with say 3rd process. Finally ARC1 is completed.
    My question is , is this normal behaviour.? Do these extra process started 2, 3 etc shut down itself, which i think is NOT, they are shut down only when database is shut down.


    ARC1: Beginning to archive log# 4 seq# 67399
    Tue Sep 2 12:00:35 2003
    Thread 1 advanced to log sequence 67401
    Current log# 2 seq# 67401 mem# 0: /u04/oradata/ntw/redo02.log
    Tue Sep 2 12:00:39 2003
    ARC0: Completed archiving log# 1 seq# 67398
    ARC0: STARTING ARCH PROCESSES
    ARC2 started with pid=126
    Tue Sep 2 12:00:39 2003
    ARC2: Archival started
    Tue Sep 2 12:00:39 2003
    ARC0: STARTING ARCH PROCESSES COMPLETE
    Tue Sep 2 12:00:39 2003
    ARC0: Beginning to archive log# 4 seq# 67399
    ARC0: Failed to archive log# 4 seq# 67399
    ARC0: Beginning to archive log# 5 seq# 67400
    Tue Sep 2 12:00:41 2003
    ARC1: Completed archiving log# 4 seq# 67399


    thanks

    Satish

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    You can ignore those messages.
    The messages are there when more than one proces tries to archive the same file and one fails but the other archives it successfully.
    HTH
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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