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

Home -> Community -> Usenet -> c.d.o.server -> Re: how to recover/restore a database using archive logs & control files 8i

Re: how to recover/restore a database using archive logs & control files 8i

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Tue, 04 Oct 2005 15:12:47 GMT
Message-ID: <Xns96E5538FDAF1ESunnySD@68.6.19.6> 





"etravels" <emerryan_at_yahoo.co.uk> wrote in 
news:1128437518.388982.141790_at_g44g2000cwa.googlegroups.com:



> sorry, again, so what shall I do?

> 

> 




startup mount


alter database datafile '/data1/tbs1.dbf' OFFLINE DROP;
alter database open;


drop tablespace TBS1including contents;
Received on Tue Oct 04 2005 - 10:12:47 CDT












Original text of this message













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