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

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

  1. #11
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    sure
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  2. #12
    Join Date
    May 2002
    Posts
    193
    Hello everyone,

    How about taking a complete export backup with consistent=y before resetting the logfiles and then a complete cold back up after the log files are reset.

    Correct me if Iam wrong...

    K.Diwakar

  3. #13
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Originally posted by Tarry
    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!!









    noooo way you can switch a log file if it is corrupted. You have to go for in complete media recovery.
    -nagarjuna

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