Forum Stats

  • 3,873,197 Users
  • 2,266,517 Discussions
  • 7,911,454 Comments

Discussions

Database startup: ORA-00333: redo log read error block 16386 count 8192

2

Answers

  • Pavan DBA
    Pavan DBA Member Posts: 2,644 Gold Badge
    well i am learning it

    nice to hear that. but i recommend to read oracle docs to get more understanding about Oracle database. you can browse those docs @ http://tahiti.oracle.com
  • 734241
    734241 Member Posts: 75
    what is the procedure to recreate it?
    last time it was normal shutdown only
  • Pavan DBA
    Pavan DBA Member Posts: 2,644 Gold Badge
    before recreating, you need to check whether it is multiplexed or not
    you can do it using
    sql> select group#,members from v$log;

    if you get a output in members column as > 1, then your groups are multiplexed and you are on safe side
    please post the ouput of above query
  • 734241
    734241 Member Posts: 75
    SQL> select group#,members from v$log;

    GROUP# MEMBERS
    ---------- ----------
    1 1
    2 1
    3 1
  • Anurag Tibrewal
    Anurag Tibrewal Member Posts: 3,901 Gold Trophy
    Hi,

    Post the output of below query
    select group#, thread#, status from v$log
    Please backup the database befor proceeding further.
    All the below action are irrecoverable and you would not be able to do recovery after wards.

    Before proceeding further please see if the status is inactive for group 2,
    If yes
    Considering you are in mount phase of the database.
    alter database clear logfile group 2
    If you get any error stop at that point only do not proceed. If not try to open your database now
    alter database open
    Regards
    Anurag
  • 734241
    734241 Member Posts: 75
    GROUP# THREAD# STATUS
    ---------- ---------- ----------------
    1 1 INACTIVE
    2 1 CURRENT
    3 1 INACTIVE
  • Anurag Tibrewal
    Anurag Tibrewal Member Posts: 3,901 Gold Trophy
    Hi,

    I doubt you had a normal shutdown, you must have had crashed shutdown of your database.
    Any way did you backed up your database. If not please do so.

    If yes you can run the other command and see if it is successfull. If not you have to do incomplete recovery.

    Regards
    Anurag
  • 734241
    734241 Member Posts: 75
    while taking dump
    but it is giving an error oracle initialization and shutdown in progress

    how to back up it?

    i am using

    exp userid=sys as sysdba file=e:\full.dmp log=e:\full.dmp full=y
  • Anurag Tibrewal
    Anurag Tibrewal Member Posts: 3,901 Gold Trophy
    Hi,

    Since your database is not in open mode, you cannot use exp command. instead shutdown the database.

    Copy your all the datafiles, and controlfiles to some other location. You wont be able to copy redo files.

    Regards
    Anurag.
  • 734241
    734241 Member Posts: 75
    edited Jan 22, 2010 7:24AM
    well ur right database is corrupt so i had dropped it and restored a back of last night

    now it is working fine

    Can u please suggest me which precautionary measures i should take to avoid such a harmful situation in future

    Thanks in advance

    Edited by: user12084499 on Jan 22, 2010 4:23 AM

    Edited by: user12084499 on Jan 22, 2010 4:23 AM
This discussion has been closed.