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

Hello,

Losing an online redo log group could be a big problem. You may want to try the following:

1. Backup the damaged database (in case you want to rollback your recovery operations when things go wrong).
2. Check the status of data files and missing logs

SVRMGR> connect / as sysdba
SVRMGR> startup mount;
SVRMGR> select * from v$recover_file;
SVRMGR> select lf.member, lg.group#, lg.archived, lg.status
                  from v$logfile lf, v$log lg
                  where lf.group#=lg.group#
                  order by 1,2;

3. Initialize (recreate) the missing redo log group

If the missing redo log group has been archived (see the results of the above query), initialize it using the command:

ALTER DATABASE CLEAR LOGFILE GROUP 1; If the missing redo log group has not been archived, initialize it using the command:

ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1; If this is successful, you can open the database. If not, you need to perform an incomplete recovery (if database mode=ARCHIVELOG) or restore the database from a cold backup (if database mode=NOARCHIVELOG).

Hope this will help.

Cong

Raj Cherukuri wrote:

> 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