| error opening db [message #199200] |
Sat, 21 October 2006 00:55  |
sujeethbala
Messages: 25
Registered: October 2006
Location: INDIA
|
Junior Member |
|
|
hi
my database is not opening. it was giving error 'shutdown or initialization in progress'.(system restarted because of power failure). so i logged in as system/sysdba
and gave this command. 'shutdown abort'.it worked. but when i gave startup it is giving the following error.
[CODE]
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
ORA-00204: error in reading (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'D:\ORACLE\ORADATA\JSSDB\CONTROL03.CTL'
ORA-27091: skgfqio: unable to queue I/O
ORA-27070: skgfdisp: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 23) Data error (cyclic redundancy check).
SQL>
[\CODE]
please help me.
regards
[Updated on: Sat, 21 October 2006 01:08] Report message to a moderator |
|
|
|
|
|
| Re: error opening db [message #199202 is a reply to message #199201] |
Sat, 21 October 2006 01:25  |
sujeethbala
Messages: 25
Registered: October 2006
Location: INDIA
|
Junior Member |
|
|
| user52 wrote on Sat, 21 October 2006 11:38 | May be possible due to "power failure" ur control file is delete or file is unaccessible.
if you have bkp of control file then replace it. and try to open it.
or if you have no bkp then create new control file.
|
Create control file created still giving error
SQL> archive log list
Database log mode Archive Mode
Automatic archival Disabled
Archive destination d:\oracle\ora92\RDBMS
Oldest online log sequence 51
Next log sequence to archive 51
Current log sequence 53
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01115: IO error reading block from file 2 (block # 8869)
ORA-01110: data file 2: 'D:\ORACLE\ORADATA\JSSDB\UNDOTBS01.DBF'
ORA-27070: skgfdisp: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 23) Data error (cyclic redundancy check).
[Updated on: Sat, 21 October 2006 01:42] Report message to a moderator |
|
|
|
|
|
| Re: error opening db [message #199220 is a reply to message #199204] |
Sat, 21 October 2006 13:02 |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
Here , if the problem is related only to reading of a controlfile, no need to create a new control file...just remove the reference of that problematic controlfile from init.ora file's control_files parameter..
please clarify what the exact problem is...
|
|
|
|
|
|
| Re: error opening db [message #199232 is a reply to message #199227] |
Sun, 22 October 2006 05:24 |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
Great! but I have a question: I have faced similar problems and then system admin. people have suggested formatting and reinstalling...what I wanted to know is: since this problem (if I get the scenario right..) was in reading of oracle files, how scan disk could have sorted it out? i mean does it clean up some bad sector etc? I am not clear conceptually how scandisk worked or what it did to resolve the issue...
[Updated on: Sun, 22 October 2006 05:26] Report message to a moderator |
|
|
|
| Re: error opening db [message #199454 is a reply to message #199232] |
Tue, 24 October 2006 08:03 |
sujeethbala
Messages: 25
Registered: October 2006
Location: INDIA
|
Junior Member |
|
|
| nirav_hyd wrote on Sun, 22 October 2006 15:54 | Great! but I have a question: I have faced similar problems and then system admin. people have suggested formatting and reinstalling...what I wanted to know is: since this problem (if I get the scenario right..) was in reading of oracle files, how scan disk could have sorted it out? i mean does it clean up some bad sector etc? I am not clear conceptually how scandisk worked or what it did to resolve the issue...
|
they are right. you have to format and reinstall. but i had the ghost file(backup of full OS). i restored it. but my problem was not solved. it was giving the same error. while restoring ghost file process was little bit slow. so i realized problem is with the file system. i used scan disk. while running scan disk it showed 2 errors and rectified it. after that again i restored the ghost file. it worked.
|
|
|
|
| Re: error opening db [message #199568 is a reply to message #199200] |
Wed, 25 October 2006 02:10 |
n_de_fontenay
Messages: 33
Registered: October 2006
Location: Paris
|
Member |
|
|
Was it only with this particular control file?
What if you deleted it and created it again by copying one of your not corrupted control file and renaming that copy to the control file with problem.
Formatting sounds a bit over the edge to me.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
