Re: ERROR: ORA-01033: ORACLE initialization or shutdown in progress
- From: David Fitzjarrell <oratune@xxxxxxxxx>
- To: nileshkum@xxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 15 Apr 2010 08:07:26 -0700 (PDT)
From: nilesh kumar <nileshkum@xxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Sent: Thu, April 15, 2010 6:14:32 AM
Subject: ERROR: ORA-01033: ORACLE initialization or shutdown in progress
Hello DBA's
Good Morning!!
Hope everyone is doing good.
I have a question for the issue I am facing.
Here is one of the database hosted on the unix box which is a test database for
the client. The box was rebooted and the database was not cleanly shutdown once
after the rebooted completed, the database did not came up and I logged in and
checked database was down. People from the appliation side were getting this
error message.ERROR: ORA-01033: ORACLE initialization or shutdown in progress
We dont have any backup of the database other then the logical backup where in
the database is exported on schedule bases. When I tried as a DBA to startup
the database, it was expecting the recovery of the system.dbf file with one of
the archive sequence. But the database was in no-archive log mode, hence was
not able to bring up the database.
Yes, you could have brought up your database in noarchivelog mode by specifying
which redo log Oracle should use. Executing 'recover database using backup
controlfile until cancel' will cause Oracle to prompt for the redo/archive log
to use and it will also tell you which sequence number is required to start
recovery. The entire procedure would be:
startup mount
set linesize 132
column member format a60
select lf.group#, lf.member, l.sequence#
from v$logfile lf, v$log l
where lf.group# = l.group#
order by 3;
[You will have a list of redo log groups, redo log names and the starting
sequence# associated with each, in sequence# order]
recover database using backup controlfile until cancel
[This will start recovery and prompt for the log Oracle should use by
displaying the sequence number required. The list generated before the recover
database command was issued will provide the log names to choose from.]
Oracle should proceed to recover the database by prompting for the redo logs
necessary then should produce a 'recovery complete' message.
Finally we brought up the database with setting the parameter
allow_restlogs_corruption = true.
Now the database is up and running but even now when the application side try
to login they are getting the same error message as "ERROR: ORA-01033: ORACLE
initialization or shutdown in progress".
I am a junor DBA. Please help me if there a solution for this or we need to
just re-import it all and start the database is that the only solution or can
we have another solution for this problem.
Thanks
Nilesh Soni
Did Oracle support instruct you to do this or was this something you did on
your own? Since no one can login because of the way you started the database I
believe your only choice now is to export the data (if that's possible) and
drop and recreate the database, then import.
David Fitzjarrell
Other related posts:
