Re: ERROR: ORA-01033: ORACLE initialization or shutdown in progress
- From: "Shastry(DBA)" <shastry17@xxxxxxxxx>
- To: nileshkum@xxxxxxxxx
- Date: Thu, 15 Apr 2010 20:05:53 +0530
Sorry My bad.. This would not help :) The only option is to try "alter
database open" or else see the below possibility:
It may be the case, the database did not stop correctly.
c:> sqlplus /nolog
sql> connect sys/manager as sysdba
sql>shutdown immediate
sql> startup
sql> exit
While startup it may show error message like some of the parameter is
missing. Note down that parameter and update in initSID.ora file.
On Thu, Apr 15, 2010 at 7:51 PM, Shastry(DBA) <shastry17@xxxxxxxxx> wrote:
> Try clearing the oracle memory segments and see if it works out.
>
> Thanks,
> An
>
>
> On Thu, Apr 15, 2010 at 7:15 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx>wrote:
>
>> Sometimes you can enter recover database;, then tell it to use a redo log
>> to do the recovery when it prompts for an archive log. Doesnt always work,
>> but it works sometimes. However, if you opened it with
>> allow_resetlogs_corruption, it may be too late. Oracle says that once you
>> do that, you must export your data and re-create the database.
>>
>>
>> On Thu, Apr 15, 2010 at 5:36 AM, Karl Arao <karlarao@xxxxxxxxx> wrote:
>>
>>> Just earlier I was also recovering a "critical test database" with no
>>> backup and in "noarchivelog mode"
>>> But my case was different, my current redo log group had a corrupted
>>> block.. and yes I also used the _allow_restlogs_corruption = true
>>> then when I opened my database the UNDO tablespace datafile also had a
>>> corrupted block... I was able to fix it by making the
>>> undo_management=manual and create a new UNDO tablespace.
>>>
>>> I've documented it all here.. it will redirect you to a forum:
>>>
>>> Redo and Undo Corruption
>>>
>>> http://karlarao.tiddlyspot.com/#%5B%5BRedo%20and%20Undo%20Corruption%5D%5D
>>>
>>>
>>>
>>> Also, have they tried to re-login again? and still got the ORA-01033?
>>>
>>>
>>>
>>> For additional reading, you may want to check on the "Oracle Center of
>>> Expertise backup and recovery documents"
>>>
>>> COE papers
>>>
>>> http://karlarao.tiddlyspot.com/#%5B%5BCOE%20Backup%20And%20Recovery%20Papers%5D%5D
>>>
>>> And read more on how SCN works
>>> http://karlarao.wordpress.com/2009/05/08/understanding-the-scn/
>>>
>>>
>>>
>>>
>>>
>>> - Karl Arao
>>> karlarao.wordpress.com
>>> karlarao.tiddlyspot.com
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Thu, Apr 15, 2010 at 6:14 PM, nilesh kumar <nileshkum@xxxxxxxxx>
>>> wrote:
>>> > 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. 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
>>> >
>>> >
>>> --
>>> //www.freelists.org/webpage/oracle-l
>>>
>>>
>>>
>>
>>
>> --
>> Andrew W. Kerber
>>
>> 'If at first you dont succeed, dont take up skydiving.'
>>
>
>
Other related posts: