Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Can not open DB :(
Drop
datafile offline, drop rollbacks, recreate datafile, recreate
rollbacks.
If
there is nothing else in the tablespace only rollback
segments.
Or
recover file from backup and media recovery.
<FONT face=Arial color=#0000ff
size=2>Regards
Ivo
Libal
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Tahoma
size=2>-----Original Message-----From: andrey
[mailto:bronfin_at_visualtop.com]Sent: Thursday, March 15, 2001 11:15
AMTo: Multiple recipients of list ORACLE-LSubject: Can
not open DB :(
Dear list
!
<SPAN
class=722011410-15032001>
please help
:
<SPAN
class=722011410-15032001>
<SPAN
class=722011410-15032001>
SVRMGR> alter
database open ;alter database open*ORA-01110: data file 2:
'D:\ORACLE\ORADATA\VTP2\RBS01.DBF'ORA-01115: IO error reading block from
file 2 (block # 1)ORA-27070: skgfdisp: async read/write
failedOSD-04016: Error queuing an asynchronous I/O request.O/S-Error:
(OS 23) Data error (cyclic redundancy
check).SVRMGR>
<SPAN
class=722011410-15032001>
What do i do
?
Received on Thu Mar 15 2001 - 10:08:04 CST
![]() |
![]() |