Home » RDBMS Server » Server Administration » Startup Problem- Control File Error (10g Release2 SUSE Linux)
Startup Problem- Control File Error [message #438433] Fri, 08 January 2010 23:40 Go to next message
prabhaher
Messages: 6
Registered: December 2009
Location: Muscat
Junior Member
Hi ,

when i start the database Im getting the following error.

SQL> startup
ORACLE instance started.

Total System Global Area 364904448 bytes
Fixed Size 1261804 bytes
Variable Size 331353876 bytes
Database Buffers 25165824 bytes
Redo Buffers 7122944 bytes
ORA-00221: error on write to control file
ORA-00206: error in writing (block 1, # blocks 1) of control file
ORA-00202: control file: '/U02/database/mydb/control01.ctl'
ORA-27072: File I/O error
Linux Error: 11: Resource temporarily unavailable
Additional information: 4
Additional information: 1

when i see in the server, PHYSICALLY control01.ctl is AVAILABLE in the specified location /U02/database/mydb/.

Pls help me to solve this problem..

Thanks in Advance,
Prabhaher
Re: Startup Problem- Control File Error [message #438439 is a reply to message #438433] Sat, 09 January 2010 02:06 Go to previous messageGo to next message
Michel Cadot
Messages: 63820
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
when i see in the server, PHYSICALLY control01.ctl is AVAILABLE in the specified location /U02/database/mydb/.

How do you see that? Did you try to write into it? If not you cannot know if it is available for a write access as Oracle did it.

Retry to start the database.
If it does not work, stop the instance, save the control file somewhere, copy another control file into this one, and try to restart the database.

Regards
Michel

[Updated on: Sat, 09 January 2010 02:06]

Report message to a moderator

Re: Startup Problem- Control File Error [message #438453 is a reply to message #438439] Sat, 09 January 2010 04:05 Go to previous messageGo to next message
prabhaher
Messages: 6
Registered: December 2009
Location: Muscat
Junior Member
Hi Michel ,

thanks for your reply i have the following doubts.

you mentioned "copy another control file into this one". that means which control file and from where ?

pls clarify me.

Thanks,
Prabhaher

Re: Startup Problem- Control File Error [message #438454 is a reply to message #438453] Sat, 09 January 2010 04:13 Go to previous messageGo to next message
Michel Cadot
Messages: 63820
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check your "control_files" parameter in init.ora file (or spfile) and you will know the list of your control files, you should have at least 2, so copy the other one onto the first one.
You can also remove the first one from the list and can restart the database without it.
But if you have only 1 control file, you are in bug trouble, the process is more complex to retrieve the database.

Regards
Michel
Re: Startup Problem- Control File Error [message #438457 is a reply to message #438454] Sat, 09 January 2010 04:40 Go to previous messageGo to next message
prabhaher
Messages: 6
Registered: December 2009
Location: Muscat
Junior Member
hi michel,

i got 3 control files in the list

SQL> show parameter control file

NAME TYPE VALUE
--------------- ---------- --------------------
control_files string /U02/database/moi1/control01.ctl,
/U02/database/moi1/control02.ctl,
/U02/database/moi1/control03.ctl



so you are asking me copy paste the controlfile2 and rename as control01.txt, and startup.

prabhaher
Re: Startup Problem- Control File Error [message #438459 is a reply to message #438457] Sat, 09 January 2010 05:00 Go to previous message
Michel Cadot
Messages: 63820
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Now you have 2 options:
- copy the number 2 into the number 1
- remove the number 1 from the list (but you will have to do the first option at the shutdown to keep the same safety)

Regards
Michel
Previous Topic: How to copy the Oracle database structure to new server?
Next Topic: Oracle 10g
Goto Forum:
  


Current Time: Sat Oct 01 16:12:58 CDT 2016

Total time taken to generate the page: 0.09122 seconds