OraFAQ Forum: Unix » Error: ORA-01033 ORACLE initialization or shutdown in progress

Home » Infrastructure » Unix » Error: ORA-01033 ORACLE initialization or shutdown in progress (Oracle 9 on Solaris 9)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error: ORA-01033 ORACLE initialization or shutdown in progress [message #312393]

Tue, 08 April 2008 15:00

bcastle63
Messages: 2
Registered: April 2008

Junior Member

At Database Startup I get:

Error: ORA-01033 ORACLE initialization or shutdown in progress

It eventually tells me it can't read/open one of the control files...

If I have a corrupt/damaged CTL file. What is the best way to work around the damaged file and get the database back up?

Thanks!

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress [message #312396 is a reply to message #312393]

Tue, 08 April 2008 15:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

The 1st thing you should do is take a complete cold backup of what you have now.

>If I have a corrupt/damaged CTL file. What is the best way to work around the damaged file and get the database back up?
By not referencing it, or possibly copying a good one over the top of it.

Any ideas how or why the control file went bad?

Are you sure no others files got corrupted?

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress [message #312404 is a reply to message #312396]

Tue, 08 April 2008 15:31

bcastle63
Messages: 2
Registered: April 2008

Junior Member

Thanks...

No idea what happened to the file...

OK... once I get the backup... what's next?

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress [message #312456 is a reply to message #312404]

Tue, 08 April 2008 23:19

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

once I get the backup... what's next?

Answer is:

Quote:

not referencing it, or possibly copying a good one over the top of it.

Either copy a good control file ovber the bad one or remove the bad control file from the control file list.

Regards
Michel

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress [message #340561 is a reply to message #312393]

Wed, 13 August 2008 05:14

sheetalpalarpwar
Messages: 1
Registered: August 2008
Location: Pune

Junior Member

I am also getting same error as
oracle initialization or shutdown in progress

after firing
alter database mount
shutdown abort
startup

i got to know that my control files are corrupt
how to recover these 2 control files?

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress [message #340573 is a reply to message #340561]

Wed, 13 August 2008 05:52

sumanthd
Messages: 10
Registered: June 2008
Location: Hyderabad

Junior Member

hi

Take the back up of all the three control file .
and place them in a safe place and take a control file and make three copies and then change the name of the copied files as the contol file 1 and control file 2 and control file 3 . and if it does not work then try with the other two from the backup . hope this will solver the problem

if u still have the problem then use the command

Smile

shut down all the instances

sql:>RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL

then the control file will be recovrered and and hope that u can use the database as usual.if still u have problem tell me the error u are typing in the recover command.
so that i can suggust u in a better way .

Report message to a moderator

Previous Topic:	Oracle 9.2.0.1 won't start in Solaris 5.8
Next Topic:	can vmware run Solaris sparc

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 18:33:13 CST 2024