Re: Lost system datafile

From: Alistair Thomson <alistair.thomson_at_spinxcst.co.uk>
Date: Thu, 21 May 1998 10:09:15 +0100
Message-ID: <3563EF3A.65B118FA@spinxcst.co.uk>

Ooooh bad luck! There's no way that I know off to get data out of a datafile without the instance being open. Have you asked Oracle Support for their opinion? Might be worth a try.

Moral of the story - Take a backup, it's worth the effort........

ADT
DBA leung_at_chime.org wrote:

> I have a database (I recently inherited) that just lost one of its datafiles
> (which is the one that system tablespace used)due to a hard disk crash. The
> database was running in Non-archive mode and no one has ever made any
> back-up. Is there any way that I can recover the data stored in other
> datafiles??
>
> Thanks!!
>
> Steve Leung
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Thu May 21 1998 - 04:09:15 CDT