Failed to Archive !!!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Failed to Archive !!!!

  1. #1
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340

    Exclamation

    Hi

    in my alert log file i m getting this error.

    ARC0: Failed to archive log# 12 seq# 22410

    later this gets archived..


    full text is as below :


    Wed Nov 07 10:23:43 2001
    Beginning log switch checkpoint up to RBA [0x578b.2.10], SCN: 0x0000.01effd03

    Wed Nov 07 10:23:43 2001
    Thread 1 advanced to log sequence 22411

    Wed Nov 07 10:23:43 2001
    ARC1: Beginning to archive log# 12 seq# 22410

    Wed Nov 07 10:23:43 2001
    Current log# 13 seq# 22411 mem# 0: J:\ORACLE\P62\ORIGLOGA\LOG_G13M1.DBF
    Current log# 13 seq# 22411 mem# 1: K:\ORACLE\P62\MIRRLOGA\LOG_G13M2.DBF

    Wed Nov 07 10:23:44 2001
    ARC0: Beginning to archive log# 12 seq# 22410

    Wed Nov 07 10:23:44 2001
    ARC0: Failed to archive log# 12 seq# 22410

    Wed Nov 07 10:23:46 2001
    Completed checkpoint up to RBA [0x578a.2.10], SCN: 0x0000.01effc62

    Wed Nov 07 10:24:00 2001
    ARC1: Completed archiving log# 12 seq# 22410


    Tell me what could be the reason..
    --------------------------
    The Time has come ....

  2. #2
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    well..chk under bkground dump directory for ARC0 text dump...it shld tell u somethg..
    how many archive destination u configured?
    ngwh,
    Singapore.

  3. #3
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340

    destinations

    ok, i will check that and revert.

    i hv only one destination where the files are archived.

    --------------------------
    The Time has come ....

  4. #4
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340

    after checking

    hey,

    i checked it but no trace file is generated for this.

    NOW WHAT ?

    this is happening today again. i saw the alert file.
    --------------------------
    The Time has come ....

  5. #5
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    your posting from alert log is not that concise, it only shows the log # 12 which is used by ARCH process and log # 13 which is your current redo log.
    You need to post at least from log sequence 10 up to log seq 15. For us to see how fast your log switches occurred and how many redo logs you have in your system, etc.

    Anyway do you at least 3 redo logs?
    Does your redo logs have enough size in order not have a frequent log switches?
    Have you set your LOG_CHECKPOINT_INTERVAL much less than the size of your redo logs?
    Or you have used time-based interval(using LOG_CHECKPOINT_TIMEOUT other than zero)?


  6. #6
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Talking


    please also post your parameter settings for anything relating to udump, bdump destinations and archive log formats/destinations.

    thanks,
    Magnus

  7. #7
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340

    Config

    Hi,

    My config is as below :

    4 log groups of 2 files each
    logfile size 20mb
    LOG_CHECKPOINT_INTERVAL = 300000
    OS Block Size = 512
    (I found this from LEBSZ col in x$kccle.

    now my 300000 * 512 > 20 mb.


    more detailed log is as below :

    ARC1: Beginning to archive log# 14 seq# 22632
    Thread 1 advanced to log sequence 22633
    Fri Nov 09 03:02:37 2001
    Current log# 11 seq# 22633 mem# 0: J:\ORACLE\P62\ORIGLOGA\LOG_G11M1.DBF
    Current log# 11 seq# 22633 mem# 1: K:\ORACLE\P62\MIRRLOGA\LOG_G11M2.DBF
    Fri Nov 09 03:02:58 2001
    ARC1: Completed archiving log# 14 seq# 22632
    Fri Nov 09 03:02:58 2001
    ARC0: Beginning to archive log# 11 seq# 22633
    Fri Nov 09 03:02:59 2001
    Beginning log switch checkpoint up to RBA [0x586a.2.10], SCN: 0x0000.01f4ec45
    Fri Nov 09 03:02:59 2001
    Thread 1 advanced to log sequence 22634
    Fri Nov 09 03:02:59 2001
    ARC1: Beginning to archive log# 11 seq# 22633
    Fri Nov 09 03:02:59 2001
    Current log# 12 seq# 22634 mem# 0: K:\ORACLE\P62\ORIGLOGB\LOG_G12M1.DBF
    ARC1: Failed to archive log# 11 seq# 22633
    Current log# 12 seq# 22634 mem# 1: J:\ORACLE\P62\MIRRLOGB\LOG_G12M2.DBF
    Fri Nov 09 03:03:01 2001
    ARC0: Completed archiving log# 11 seq# 22633
    Fri Nov 09 03:03:01 2001
    Completed checkpoint up to RBA [0x5869.2.10], SCN: 0x0000.01f4eac0
    Fri Nov 09 03:03:17 2001
    Completed checkpoint up to RBA [0x586a.2.10], SCN: 0x0000.01f4ec45
    Fri Nov 09 03:03:29 2001
    Beginning log switch checkpoint up to RBA [0x586b.2.10], SCN: 0x0000.01f4ed9e
    Thread 1 advanced to log sequence 22635
    Fri Nov 09 03:03:29 2001
    ARC1: Beginning to archive log# 12 seq# 22634
    Fri Nov 09 03:03:29 2001
    Current log# 13 seq# 22635 mem# 0: J:\ORACLE\P62\ORIGLOGA\LOG_G13M1.DBF
    Current log# 13 seq# 22635 mem# 1: K:\ORACLE\P62\MIRRLOGA\LOG_G13M2.DBF
    Fri Nov 09 03:03:31 2001
    ARC1: Completed archiving log# 12 seq# 22634
    Fri Nov 09 03:03:51 2001
    Beginning log switch checkpoint up to RBA [0x586c.2.10], SCN: 0x0000.01f4eef6
    Thread 1 advanced to log sequence 22636
    Fri Nov 09 03:03:51 2001
    Current log# 14 seq# 22636 mem# 0: K:\ORACLE\P62\ORIGLOGB\LOG_G14M1.DBF
    Current log# 14 seq# 22636 mem# 1: J:\ORACLE\P62\MIRRLOGB\LOG_G14M2.DBF
    Fri Nov 09 03:03:52 2001
    ARC1: Beginning to archive log# 13 seq# 22635
    Fri Nov 09 03:03:54 2001
    Completed checkpoint up to RBA [0x586b.2.10], SCN: 0x0000.01f4ed9e
    Fri Nov 09 03:04:15 2001
    ARC1: Completed archiving log# 13 seq# 22635
    Fri Nov 09 03:04:15 2001
    Beginning log switch checkpoint up to RBA [0x586d.2.10], SCN: 0x0000.01f4f031
    Fri Nov 09 03:04:15 2001
    ARC0: Beginning to archive log# 14 seq# 22636
    Fri Nov 09 03:04:15 2001
    Thread 1 advanced to log sequence 22637
    Fri Nov 09 03:04:15 2001
    ARC1: Beginning to archive log# 14 seq# 22636
    ARC1: Failed to archive log# 14 seq# 22636
    Fri Nov 09 03:04:15 2001
    Current log# 11 seq# 22637 mem# 0: J:\ORACLE\P62\ORIGLOGA\LOG_G11M1.DBF
    Current log# 11 seq# 22637 mem# 1: K:\ORACLE\P62\MIRRLOGA\LOG_G11M2.DBF
    Fri Nov 09 03:04:17 2001
    ARC0: Completed archiving log# 14 seq# 22636
    Fri Nov 09 03:04:18 2001
    Completed checkpoint up to RBA [0x586c.2.10], SCN: 0x0000.01f4eef6
    Fri Nov 09 03:04:36 2001
    Completed checkpoint up to RBA [0x586d.2.10], SCN: 0x0000.01f4f031
    Fri Nov 09 03:04:36 2001
    Beginning log switch checkpoint up to RBA [0x586e.2.10], SCN: 0x0000.01f4f241
    Fri Nov 09 03:04:36 2001
    ARC1: Beginning to archive log# 11 seq# 22637
    Thread 1 advanced to log sequence 22638
    Fri Nov 09 03:04:37 2001
    Current log# 12 seq# 22638 mem# 0: K:\ORACLE\P62\ORIGLOGB\LOG_G12M1.DBF
    Current log# 12 seq# 22638 mem# 1: J:\ORACLE\P62\MIRRLOGB\LOG_G12M2.DBF
    Fri Nov 09 03:04:51 2001
    ARC1: Completed archiving log# 11 seq# 22637



    IMP : sometimes i m getting checkpoint not completed error also.

    help me !!!
    --------------------------
    The Time has come ....

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    vijay8282

    I thought I answered your question regarding this in another thread? What is the problem now?

  9. #9
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340

    why i m posting here

    Hi Pando,

    yes u answered at another thread. actually i started both threads at the same time. so if someone is asking for details in a thread i need to reply.

    moreover as i cannot shutdown my server immediately i m trying to gather as much info as i can.

    i am posting for no other reson. as u know v hv to take lot of precautions while doing anything on prod server.

    thanks for all ur help. i hope u won't mind.
    --------------------------
    The Time has come ....

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    i dont mind but everyone is gonna tell you the samething anywayz

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