Getting Initialization and shutdown in progress error msg while connecting with sqlplus

From: Raj Cherukuri <raj_strobe_at_yahoo.com>
Date: 16 Oct 2001 10:06:25 -0700
Message-ID: <e6ff1e18.0110160906.109a8d7f_at_posting.google.com>

[Quoted] For whatever reason, after rebooting the workstation with windows2000 and oracle 8.1.6 production enterprise version running, I am getting an error msg:
'Ora Error - Initialization and shutdown in progress'. This is after I attempt a sqlplus session.

Getting into svrmgr and using these cmds got me to point out the missing file;
svrmgr> startup force
>alter database open

>open failed for members of log group 1 of thread1
>online log 1 thread 1: 'c:\oracle\oradata\lis\redo03.log'

Checking the path for the file redo03.log, it is MISSING. Question is how do I recreate the logfile. Is it through a controlfile creation process?. What is the recovery option with svrmgr and "alter/recover" cmds. I feel that the .ctl files in the path were modified or changed accidently while rebooting or across the network.

Any help is appreciated
Raj Received on Tue Oct 16 2001 - 19:06:25 CEST