| Startup Problem- Control File Error [message #438433] |
Fri, 08 January 2010 23:40  |
prabhaher
Messages: 11
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  |
 |
Michel Cadot
Messages: 68665
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 |
prabhaher
Messages: 11
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 #438457 is a reply to message #438454] |
Sat, 09 January 2010 04:40 |
prabhaher
Messages: 11
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 |
|
Michel Cadot
Messages: 68665
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
