Home » Infrastructure » Unix » Error: ORA-01033 ORACLE initialization or shutdown in progress (Oracle 9 on Solaris 9)
Error: ORA-01033 ORACLE initialization or shutdown in progress [message #312393] Tue, 08 April 2008 15:00 Go to next message
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!
Re: Error: ORA-01033 ORACLE initialization or shutdown in progress [message #312396 is a reply to message #312393] Tue, 08 April 2008 15:14 Go to previous messageGo to next message
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?
Re: Error: ORA-01033 ORACLE initialization or shutdown in progress [message #312404 is a reply to message #312396] Tue, 08 April 2008 15:31 Go to previous messageGo to next message
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?

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress [message #312456 is a reply to message #312404] Tue, 08 April 2008 23:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Error: ORA-01033 ORACLE initialization or shutdown in progress [message #340561 is a reply to message #312393] Wed, 13 August 2008 05:14 Go to previous messageGo to next message
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?
icon7.gif  Re: Error: ORA-01033 ORACLE initialization or shutdown in progress [message #340573 is a reply to message #340561] Wed, 13 August 2008 05:52 Go to previous message
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 .

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


Current Time: Thu Mar 28 07:25:34 CDT 2024