"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
news:aaffqr$c5d$1_at_lust.ihug.co.nz...
> "Sergey Adamenko" <adamenko_at_i.com.ua> wrote in message
> news:aaf5ko$2m3t$3_at_news.dg.net.ua...
> >
> > Hi, ALL!
> > Did someone get used of such thing as DSPITR (Database point-in-time
> > recovery)?
> > My base works with ARCHIVELOG mode.
> > I'm trying to rollback an hour ago.
>
> Not being flippant, but this is your first mistake. Database don't ever
get
> rolled back. They can only ever roll forward. It sounds like a meaningless
> distinction when you first hear it, but it actually has profound
> implications.
>
> If you could roll a database back, you'd take your perfectly consistent
and
> working database, and issue some sort of rollback command, and
transactions
> would be removed from the database step by step.
10i enhancement request maybe?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Sun Apr 28 2002 - 03:31:26 CDT