Re: lost datafile :(

From: gazzag <gareth_at_jamms.org>
Date: 23 Oct 2006 05:12:42 -0700
Message-ID: <1161605562.542399.225180@b28g2000cwb.googlegroups.com>

Andrea wrote:
> hi,
>
> i've lost one datafile (table data for users) on my database 10g
> (luckily in a test db) , the DB is not set on ArchiveLog mode.. but i
> 've a backup of all datafile from last night.
>
> How i restore database? restore only datafile lost and restart
> instance? and which time the data are consistent??
>
> thanks for your support!
>
> bye
> Andrew

How did you take that backup last night? Did you back up the control file? Received on Mon Oct 23 2006 - 07:12:42 CDT