I tried to log into my database and the following error props up:
Error:
ORA-01033: Oracle initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial Number 0
----------
I tried to solve the problem but encountered more problem
1. I logged in using sys as sysdba
2. I shutdown the database
3 I mounted the database by issuing this command startup mount
4 I tried to open the database by issuing this command alter database open but it came with the following error
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 31249 change 7497494 time 02/10/2014 11:15:12
ORA-00312: online log 3 thread 1: 'c:\app\frank\oradata\orcl\redo03.log
I have been searching the web to resolve this issue but to no avail. Pls, I will be grateful if any person can help me resolve this problem.