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

Pavan DBA

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

what is the procedure to recreate it?
last time it was normal shutdown only

Pavan DBA

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

SQL> select group#,members from v$log;

GROUP# MEMBERS
---------- ----------
1 1
2 1
3 1

Anurag Tibrewal

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

GROUP# THREAD# STATUS
---------- ---------- ----------------
1 1 INACTIVE
2 1 CURRENT
3 1 INACTIVE

Anurag Tibrewal

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

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

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

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