Alert Log in Oracle 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Alert Log in Oracle 9i

Hybrid View

  1. #1
    Join Date
    Oct 2001
    Posts
    34

    Alert Log in Oracle 9i

    Dear all,

    I have an oracle 9i database in unix. I find the following message appears in alert log file repeatly.

    kccrsz: denied expansion of controlfile section 9 by 55826 record(s)
    the number of records is already at maximum value (65535)
    krcpwnc: following controlfile record written over:
    RECID #25503 Recno 61954 Record timestamp
    11/14/02 18:41:55
    Thread=1 Seq#=25503 Link-Recid=25502
    Low
    scn: 0x0000.57ce1b4e
    11/14/02 18:41:55
    Next
    scn: 0x0000.57ce1b7a

    What is it about?

    Thx
    _____________________________
    Loren

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Assuming that your CONTROL_FILE_RECORD_KEEP_TIME is set to default value of 7, your are hitting the max value(65535) MAXLOGHISTORY.

    You can set CONTROL_FILE_RECORD_KEEP_TIME to 0 either in init.ora or dynamically alter system set control_file_record_keep_time=0;

    Check Metalink for more info.

    HTH
    Sanjay

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