Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Can not open DB :(

RE: Can not open DB :(

From: Libal, Ivo <ivo.libal_at_knapp-systems.com>
Date: Thu, 15 Mar 2001 08:08:04 -0800
Message-ID: <F001.002CD695.20010315064226@fatcity.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US