URGENT - Alert Log error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: URGENT - Alert Log error

  1. #1
    Join Date
    Nov 2000
    Posts
    416
    Our Production Database looks very slow now : This is the end of alert log. What does it tell you ?

    1- Thread 1 cannot allocate new log : I know tyhis means tha log group is small, can I add two bigger log groups and not to drop the current ones


    2- What this part means , this is happens trecently !! I have no idea please help ,

    kccrsz: denied expansion of controlfile section 9 by 661 record(s)
    the number of records is already at maximum value (65535)
    krcpwnc: following controlfile record written over:
    RECID #341178 Recno 21655 Record timestamp
    03/12/02 11:34:40
    Thread=1 Seq#=341178 Link-Recid=341177



    *********************************************


    Thread 1 cannot allocate new log, sequence 406713
    Checkpoint not complete
    Current log# 2 seq# 406712 mem# 0: E:\ORANT\DATABASE\LOGNUP2.ORA
    Thread 1 advanced to log sequence 406713
    Current log# 1 seq# 406713 mem# 0: D:\ORANT\DATABASE\LOGNUP1.ORA
    Thread 1 cannot allocate new log, sequence 406714
    Checkpoint not complete
    Current log# 1 seq# 406713 mem# 0: D:\ORANT\DATABASE\LOGNUP1.ORA
    kccrsz: denied expansion of controlfile section 9 by 661 record(s)
    the number of records is already at maximum value (65535)
    krcpwnc: following controlfile record written over:
    RECID #341178 Recno 21655 Record timestamp
    03/12/02 11:34:40
    Thread=1 Seq#=341178 Link-Recid=341177
    Low
    scn: 0x0000.085f05e0
    03/12/02 11:32:34
    Next
    scn: 0x0000.085f05fe
    Thread 1 advanced to log sequence 406714
    Current log# 2 seq# 406714 mem# 0: E:\ORANT\DATABASE\LOGNUP2.ORA
    Thread 1 cannot allocate new log, sequence 406715
    Checkpoint not complete
    Current log# 2 seq# 406714 mem# 0: E:\ORANT\DATABASE\LOGNUP2.ORA
    kccrsz: denied expansion of controlfile section 9 by 661 record(s)
    the number of records is already at maximum value (65535)
    krcpwnc: following controlfile record written over:
    RECID #341179 Recno 21656 Record timestamp
    03/12/02 11:34:41
    Thread=1 Seq#=341179 Link-Recid=341178
    Low
    scn: 0x0000.085f05fe
    03/12/02 11:34:40
    Next
    scn: 0x0000.085f0617
    Thread 1 advanced to log sequence 406715
    Current log# 1 seq# 406715 mem# 0: D:\ORANT\DATABASE\LOGNUP1.ORA
    kccrsz: denied expansion of controlfile section 9 by 661 record(s)
    the number of records is already at maximum value (65535)
    krcpwnc: following controlfile record written over:
    RECID #341180 Recno 21657 Record timestamp
    03/12/02 11:34:42
    Thread=1 Seq#=341180 Link-Recid=341179
    An ounce of prevention is worth a pound of cure

  2. #2
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    THis is just a warning that the controlfile old records will be rewritten to make space for new entries, this should not be the reason for the slow down of db.
    KN

  3. #3
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    you can do either of the foll to supress these messages:
    Set the CONTROL_FILE_RECORD_KEEP_TIME to 0:

    * Insert the parameter CONTROL_FILE_RECORD_KEEP_TIME = 0 IN "INIT.ORA"

    -OR-

    * Set it momentarily if you cannot shut the database down now:

    SQL> alter system set control_file_record_keep_time=0;
    KN

  4. #4
    Join Date
    Feb 2001
    Posts
    290
    http://www.dbasupport.com/forums/sho...threadid=22456

    You may wish to see the above thread

    --Madhu

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