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

Thread: alert Log

  1. 02-24-2003, 09:32 AM #1
    Barabas
    Barabas is offline Junior Member
    Join Date
    Aug 2000
    Posts
    68

    alert Log

    Hi I just pulled this from my Alert Log...

    Can someone provide a more detailed explaination of what Oracle is Telling me?

    Thanks Very much

    Thread 1 advanced to log sequence 4999
    Current log# 1 seq# 4999 mem# 0: F:\ORACLE\ORADATA\MANUF\REDO03.LOG
    Thread 1 cannot allocate new log, sequence 5000
    Checkpoint not complete
    Current log# 1 seq# 4999 mem# 0: F:\ORACLE\ORADATA\MANUF\REDO03.LOG
    Thread 1 advanced to log sequence 5000
    Current log# 2 seq# 5000 mem# 0: F:\ORACLE\ORADATA\MANUF\REDO02.LOG
    Thread 1 advanced to log sequence 5001
    Current log# 3 seq# 5001 mem# 0: F:\ORACLE\ORADATA\MANUF\REDO01.LOG
    Carpe Diem
    Reply With Quote Reply With Quote
  2. 02-24-2003, 09:37 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    The messages represent that the online redo log has been switched to the next in sequence.

    The "checkpoint not complete" is generally an indication that either your online redo logs are too small or there is not enough of them.

    Regards
    Last edited by jovery; 02-24-2003 at 09:44 AM.
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  3. 02-24-2003, 09:44 AM #3
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    This means that the checkpoint has not yet completed so the Oracle server cannot switch redo log.

    You can add more log group or increase the size of the one you have or change LOG_CHECKPOINT_INTERVAL or LOG_CHECKPOINT_TIMEOUT (RTFM)

    HTH
    Last edited by adewri; 02-25-2003 at 01:41 AM.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  4. 02-24-2003, 11:32 AM #4
    Barabas
    Barabas is offline Junior Member
    Join Date
    Aug 2000
    Posts
    68

    Thumbs up

    Thanks again For the Help.

    Im going to add a couple more Re-do Log files...
    Carpe Diem
    Reply With Quote Reply With Quote
  5. 02-24-2003, 07:18 PM #5
    grjohnson's Avatar
    grjohnson
    grjohnson is offline Senior Advisor
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Check your archiveing as well. The switch could be waiting for the archiving process to finish. Addind additional groups and increase their size should sort the issue out though.
    OCP 8i, 9i DBA
    Brisbane Australia
    Reply With Quote Reply With Quote
  6. 02-24-2003, 07:26 PM #6
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by grjohnson
    Check your archiveing as well. The switch could be waiting for the archiving process to finish.
    Not with "Checkpoint not complete" messager in alert log.... " Checkpoint not complete" has nothing to do with archiving.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width