Re: lost datafile :(

From: Andrea <netsecurity_at_tiscali.it>
Date: 23 Oct 2006 06:15:51 -0700
Message-ID: <1161609351.745195.35360@h48g2000cwc.googlegroups.com>

gazzag ha scritto:

> 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?

yes,
control file, redo log and datafile are included into backup Received on Mon Oct 23 2006 - 08:15:51 CDT