Re: lost datafile :(

Andrea wrote:
> 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

Shutdown the database and copy the files you backed up last night to the required locations. Then start up your database.

You should know that, as you're not in archivelog mode, you can only revert the database back to how it was when you took the backup. i.e. any subsequent changes since will be lost.

HTH -g Received on Mon Oct 23 2006 - 08:21:28 CDT