Home » RDBMS Server » Backup & Recovery » error opening db
error opening db [message #199200] Sat, 21 October 2006 00:55 Go to next message
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 #199201 is a reply to message #199200] Sat, 21 October 2006 01:08 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

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.
Re: error opening db [message #199202 is a reply to message #199201] Sat, 21 October 2006 01:25 Go to previous messageGo to next message
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 #199204 is a reply to message #199202] Sat, 21 October 2006 02:50 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member




How can you create control file and check undo tbs name in new control file creation.
Re: error opening db [message #199220 is a reply to message #199204] Sat, 21 October 2006 13:02 Go to previous messageGo to next message
orausern
Messages: 817
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 #199227 is a reply to message #199200] Sat, 21 October 2006 22:52 Go to previous messageGo to next message
sujeethbala
Messages: 25
Registered: October 2006
Location: INDIA
Junior Member
hi all
problem was with file system. scandisk solved my problem. its ok now.
Re: error opening db [message #199232 is a reply to message #199227] Sun, 22 October 2006 05:24 Go to previous messageGo to next message
orausern
Messages: 817
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 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: Recovery modes on Oracle 10g
Next Topic: Oracle Backup Wizard
Goto Forum:
  


Current Time: Fri Dec 09 17:32:42 CST 2016

Total time taken to generate the page: 0.21716 seconds