Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, vishnudas.

Asked: October 16, 2018 - 5:50 am UTC

Last updated: October 17, 2018 - 5:42 am UTC

Version: 11.2.0.1.0

Viewed 1000+ times

You Asked

HI,THERE I HAVE A SITUATION HERE,DUE TO POWER OUTAGE, DATABASE KEEP GIVING ERROR

 <code> select name,open_mode from v$database; 

NAME      OPEN_MODE                                                             
--------- --------------------                                                  
TESTDB    MOUNTED                                                               


So tried to open the database

<code> alter database open; 

alter database open
*
ERROR at line 1:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 11061 change 2342464 time 10/08/2018
13:52:29
ORA-00312: online log 2 thread 1:
'D:\APP\ADMINISTRATOR\ORADATA\TESTDB\REDO02.LOG'


I got the above error

What should i do to overcome this???

FOLLOWING ARE THE DETAILS FOR REDO FILES



GROUP# THREAD# MEMBER ARCHIVED STATUS

1 1 D:\APP\ADMINISTRATOR\ORADATA\TESTDB\REDO01.LOG NO ACTIVE

2 1 D:\APP\ADMINISTRATOR\ORADATA\TESTDB\REDO02.LOG NO CURRENT

3 1 D:\APP\ADMINISTRATOR\ORADATA\TESTDB\REDO03.LOG YES ACTIVE


and Connor said...

Step 1 *whenever* you have a corruption is:

Contact Support.

Do *not* go trying things etc without getting them involved first.

Ultimately they might guide you to MOS notes:

1078456.6
1796433.1

But ... speak to Support first.

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database