Re: Recover a datafile which I deleted from O/S

From: Johnny Chan <j4ychan_at_PROBLEM_WITH_INEWS_GATEWAY_FILE>
Date: 1997/05/05
Message-ID: <5kl41l$e3o@gw.PacBell.COM>#1/1

jkpark_at_injo.pufs.ac.kr wrote:
> I made big mistake.
> I deleted a datafile whcih I never backup.

> I have log and control files.
> Is it possible to recover it?
> Need help, very urgent.

> I appreciate any help

if you have all the archive logs from the time the datafile was created and you are running on a Oracle 7.1 or higher, you can restore by creating the datafile using the "ALTER DATABASE CREATE DATAFILE..." command and rolling forward all the archive and redo logs.

Johnny Chan
Independent Oracle Specialist Received on Mon May 05 1997 - 00:00:00 CDT