Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Posts
    4

    Unanswered: Question:ORA-00368: checksum error in redo log block

    Database is can not open,The Error message is :

    ORA-00368: checksum error in redo log block

    ORA-00353: log corruption near block 60807 change

    26080386 time 02/18/2004 19:28:19

    ORA-00312: online log 2 thread 1:

    '/datacenter/oracle/oradata/test/redo02.log'

    what i can do?
    Thanks

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    I guess Your Online redo log no. 2 has been currupted. If your database was in ARCHIEVELOG mode, then perform incomplete recovery clear that redo log and create the new one.

    If your database was in NOARCHIVELOG mode, then restore the last most recent backup. (loss of data)

    You should also make sure to implement multiplexing of redo logs on different disks in future.
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  3. #3
    Join Date
    Oct 2003
    Posts
    4
    Thanks hings,
    My database is NOARCHIVELOG mode, your means is i can not perform incomplete recovery?
    I use command "recover database until cancel using backup controlfile"
    and "alter database open resetlogs"(i modify the file init.ora for _allow_resetlogs_corruption=ture);
    but the error message is
    "..system01.dbf need recovery", how about it?

  4. #4
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    Originally posted by richard98cn
    Thanks hings,
    My database is NOARCHIVELOG mode, your means is i can not perform incomplete recovery?
    I use command "recover database until cancel using backup controlfile"
    and "alter database open resetlogs"(i modify the file init.ora for _allow_resetlogs_corruption=ture);
    but the error message is
    "..system01.dbf need recovery", how about it?
    Because the database files (*.dbf) are inconsistent at the time of faulire. In this case you apply redo logs (Archived redo) to make all of your *.dbf consistent using RECOVER DATABASE command. But in your case, you do not have redo logs (archieved) available to make *.dbf consistent because Your database were in NOARCHHIVELOG mode. So, eventhough you execute RECOVER DATABSE..statement, it will not do anything. and at the end Oracle replys that your system file is NOT CONSISTENT.

    If your Database is running in NOARCHIVELOG mode, then no recovery is necessary instead you have to restore your last most-recent full backup, if one of the following happens.

    (1) if you lose all the controlfiles

    (2) if you lose any one of the online redo log groups including all the members( as in your case).

    (3) if you lose any database files EXCEPT temporary one.

    HTH
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  5. #5
    Join Date
    Apr 2007
    Posts
    1

    ORA-00368 due to nfs mount failed

    We also had this error on a standby database in archive log mode. The reason was simply that the redo logs were mounted from the main server by nfs and the nfs export stopped to work after some months. Restarting the nfs - server where the archive logs were stored and umount/mount of the nfs device on the standby server solved the problem

    Database solutions aberger.at

  6. #6
    Join Date
    Oct 2003
    Location
    Republic of Srpska, Bosnia and Herzegovina
    Posts
    35

    Recover in noarchivelog mode

    See this blog about recovering in noarchivelog mode:
    http://www.gnjatovic.blogspot.com/
    Dragoslav Gnjatovic
    Oracle9i Database Administrator
    Certified Professional

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •