Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    kualalumpur
    Posts
    89

    Unanswered: archiving problem..

    Hello Oracle DBAs,
    v r using oracle8i (8.1.6) database.The database log mode is archive mode.
    but the archiving process is not in its place..quite often it fails to archive..
    when v refer to alert log file it is in the following format..

    Tue Jun 22 10:02:02 2004
    ARC0: Beginning to archive log# 3 seq# 42927
    ARC0: Failed to archive log# 3 seq# 42927
    Tue Jun 22 10:02:02 2004
    ARCH: Completed archiving log# 3 seq# 42927
    Tue Jun 22 11:27:04 2004
    Thread 1 advanced to log sequence 42929
    Current log# 2 seq# 42929 mem# 0: /u03/app/oracle/oradata/elx/redo02.log
    Tue Jun 22 11:27:04 2004
    ARC0: Beginning to archive log# 1 seq# 42928
    ARC0: Completed archiving log# 1 seq# 42928
    Tue Jun 22 13:21:50 2004
    Thread 1 advanced to log sequence 42930
    Current log# 3 seq# 42930 mem# 0: /u04/app/oracle/oradata/elx/redo03.log
    Tue Jun 22 13:21:50 2004
    ARC0: Beginning to archive log# 2 seq# 42929
    ARC0: Completed archiving log# 2 seq# 42929
    Tue Jun 22 14:01:50 2004
    ARCH: Beginning to archive log# 3 seq# 42930
    Tue Jun 22 14:01:50 2004
    ARC0: Beginning to archive log# 3 seq# 42930
    Tue Jun 22 14:01:50 2004
    Thread 1 advanced to log sequence 42931
    Tue Jun 22 14:01:50 2004
    ARC0: Failed to archive log# 3 seq# 42930
    Tue Jun 22 14:01:50 2004
    Current log# 1 seq# 42931 mem# 0: /u02/app/oracle/oradata/elx/redo01.log
    Tue Jun 22 14:01:50 2004
    ARCH: Completed archiving log# 3 seq# 42930
    Tue Jun 22 15:52:34 2004
    Thread 1 advanced to log sequence 42932
    Current log# 2 seq# 42932 mem# 0: /u03/app/oracle/oradata/elx/redo02.log
    Tue Jun 22 15:52:34 2004
    ARC0: Beginning to archive log# 1 seq# 42931
    ARC0: Completed archiving log# 1 seq# 42931
    Tue Jun 22 16:38:33 2004
    Thread 1 advanced to log sequence 42933
    Current log# 3 seq# 42933 mem# 0: /u04/app/oracle/oradata/elx/redo03.log
    Tue Jun 22 16:38:33 2004

    what could be the cause..what areas v need to zoom into..
    Does it affects the performance
    Please help me in finding this..
    thanking you..
    sincerely
    sridhar
    ARC0: Beginning to archive log# 2 seq# 42932
    ARC0: Completed archiving log# 2 seq# 42932

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    It is not really a problem .... The archiver can't keep up, but it DOES archive eventually ... You will notice, a "failed to archive", but a little later, "archive successful" message. It may be the speed of the disk drives, or some other wait events occurring on the database, but this is not generally a problem

    HTH
    Gregg

  3. #3
    Join Date
    Nov 2003
    Location
    kualalumpur
    Posts
    89

    thanks..

    thank you very much .. if it is really not a problem then i can strike out this and focus on other areas to fine tune..
    regards
    sridhar

Posting Permissions

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