URGETNT PLEASE HELP!!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: URGETNT PLEASE HELP!!!

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    I add more redo log file to my datafiles, and issue the command :ALTER SYSTEM SWITCH LOGFILE ;

    and the database crashed with this errors

    Errors in file C:\oracle\admin\REVD\bdump\revdLGWR.TRC:
    ORA-00321: log 3 of thread 1, cannot update log file header
    ORA-00312: online log 3 thread 1: 'C:\ORACLE\ORADATA\REVD\REDO03.LOG'
    ORA-27091: skgfqio: unable to queue I/O
    OSD-04008: WriteFile() failure, unable to write to file
    O/S-Error: (OS 5) Access is denied.

    LGWR: terminating instance due to error 321

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Somehow, there is a problem with 'C:\ORACLE\ORADATA\REVD\REDO03.LOG'

    To fix this problem,

    1. startup mount
    2. drop logfile group 3
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi,

    The OS 5 error could indicate that the permissions are not set correctly on this file.

    or

    some Backup or antivirus software has locked the file.

    Oracle server needs exclusive access to its datafiles.

    Disable the file locking in the backup and antivirus
    software.

    OR

    Disable backup and scanning of Oracle datafiles.

    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  4. #4
    Join Date
    Jan 2002
    Posts
    474
    Jeff was right, corrupt redo log file.

    Can you tell me why the datafile 3 was corrupted??? Was it b/c I issues ALTER SYSTEM SWITCH LOG FILE and not in the restrict mode??? Redo 3 is one of the old redo file and I didn't even touch it.

    Please explain


  5. #5
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Ist of all this is a redo log file, not a datafile.

    Did the oracle user have write permissions on this file ?
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  6. #6
    Join Date
    Aug 2001
    Posts
    391
    the redo3.log was corrupted so you need to start the database in mount stage and drop the corrupted file and start up the database. I hope you have two members in each group.


  7. #7
    Join Date
    Jan 2002
    Posts
    474
    Jeff,

    Could you please explain to me why the redo3.log was corrupted when I issued this command.

    'ALTER SYSTEM SWITCH LOGIFLE'

    The database already had three logs from 1 to 3 and I add three more log 4 to 6 and issue the command above. All the sudden, the database went down and the redo3.log was corrupted. Why was that ??? I have done couples times by issuing the command above. Am I supposed to put the database in restrict mode ???

    Please explain.


  8. #8
    Join Date
    Aug 2000
    Posts
    236
    What were the parameters used the create the new log groups. Were the sizes of these files the same as the old ones? And if the old ones were mirrored, did you mirroe the new ones also?
    Nizar

  9. #9
    Listen, if possible, make a reboot of the system. It isn't so unusual for win2000 (sometimes even NT) to wrongly keep some locks on a file, and untill the system reboots is nothing to do.
    A workaround is to force REWRITING the user-rights on that file.
    BR,
    ovidius
    ovidius over!

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