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

If the database was shutdown clean...
You may be able to

alter database open resetlogs;

If not issue a recover database
Then try alter database open resetlogs;

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

"Raj Cherukuri" <raj_strobe_at_yahoo.com> wrote in message news:e6ff1e18.0110160906.109a8d7f_at_posting.google.com...
> 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 - 11:14:22 CDT