Ora-00366 error occurs when running a long batch
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Ora-00366 error occurs when running a long batch

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    Ora-00366 error occurs when running a long batch .

    Redo Log File size is around 50MB .

    what's the cause ?

    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    It looks like you may have a corrupt redo log file

    Regards
    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!

  3. #3
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,591
    That's the error desc , if you missed checking it.

    ORA-00366 log string of thread string, checksum error in the file header

    Cause: The file header for the redo log contains a checksum that does not match the value calculated from the file header as read from disk. This means the file header is corrupted.

    Action: Find and install correct version of the log or reset the logs
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  4. #4
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    Can "alter system switch logfile' helpful in this case
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  5. #5
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,591

    Jim !!!

    Hey Jim,

    Gave a new look to your website, I see!

    cheers!!

    Tarry
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  6. #6
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Hi Tarry,

    I took a look a PHP and went a bit mad-for-it

    Regards
    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!

  7. #7
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    Hey , gurus , Please advise ,

    I want to create new redo log group and drop all the current redo log group . How do you think ?
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  8. #8
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,591
    to drop
    ALTER DATABASE xxxx DROP LOGFILE GROUP x1;
    to make
    ALTER DATABASE xxxx
    ADD LOGFILE GROUP x1
    ('diska/logx.log',
    'diskb/logx.log',
    'diskc/logx.log' );

    I wonder what effect it might have forcing archiving of that corrupted file.

    since it deals with corruption, take care in checking all pros and cons.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  9. #9
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,591
    On another note,
    you can
    Diagnose
    ________
    Check alert log.
    query : select * from v$logfile

    Repair
    ______

    See if is on yr system
    Select * from v$logfile
    check it on the OS given directory.

    Make the group with corrupt logfile inactive
    select group# , status
    from v$log;

    If active, make him inactive by

    alter system switch logfile;

    chk

    select group# , status
    from v$log;

    drop the invalid file:

    alter database drop logfile member '/blah/blah';

    do

    select * from v$logfile;

    recreate

    alter database add logfile member 'blah/blah';

    do alter system switch logfile;
    asmany time as there are groups atleast.
    then query

    select * from v$logfile;

    there shud be no invalid logfiles anymore.

    And also about the checksum story,
    If one of your logfile has checksum probs, it'll still look for the other and move on, but if all have checksum trouble the db will hand,
    You can also issue to re initialize the redo logfile

    alter database clear logfile;(after making it non current, if current).

    Cheers!!









    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  10. #10
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    The Redo log group(3 groups) has only one log file , in this case , can do switch on corrupt log file ?
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

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