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

Thread: checkpoint in alert log file

  1. #1
    Join Date
    Aug 2001
    Posts
    390
    can someone tell me why

    Thread cannot allocate the new log
    checkpoint is not complete


    Why check point is not complete ??? What cause it and how to fix it

    Thanks

  2. #2
    Join Date
    Oct 2000
    Posts
    57

    Wink

    Your redo logs are not big enough. Drop each logfile group in turn and then recreate them. You cannot drop the active redo log., so you may have to use alter system switch logfile to switch manually. Use alter database add logfile '............' size xxxM to add the new file file. ps after you drop the logfile rename it to .sav using your OS.

  3. #3
    Join Date
    Aug 2001
    Posts
    390
    Thanks paul

    what will happen to the database if we don't fix this problem ??? will the log file corrupt in the near future ???




  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    No, your database just "hangs" until it can complete the checkpoint. You will not get corrupt logs, just lousy performance.
    Jeff Hunter

  5. #5
    Join Date
    Aug 2001
    Posts
    390
    since the log had only 1 group and no members, Would it help if I add the new member in there without making the redo log bigger ???

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    1 group and no members? I don't see how that is possible. Anyway, you could add more log groups to help alleviate this problem as a stop-gap measure. You will still have inadequate redo-logs, it will just take longer to get the CNC error...
    Jeff Hunter

  7. #7
    Join Date
    Aug 2001
    Posts
    390
    I am sorry I misinterpret myself, 3 redo log group with no members.


  8. #8
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by mike73
    I am sorry I misinterpret myself, 3 redo log group with no members.
    Misinterpretation again

    Each log group allways have at least one member...
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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