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