Re: lost datafile :(

From: Andrea <netsecurity_at_tiscali.it>
Date: 24 Oct 2006 03:11:07 -0700
Message-ID: <1161684667.151037.220020@i3g2000cwc.googlegroups.com>

gazzag wrote:
> 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.

yes, i know.
So, i need to restore ALL files (control, redo and datafile)

thanks Received on Tue Oct 24 2006 - 05:11:07 CDT