Re: Oracle point-in-time recovery

TSPITR is a very particular method of using a clone database to recover data which is then exported/imported back into the production database -usually performed once in a very blue moon, and only when a bog-standard incomplete recovery (which is the correct term, incidentally, for a 'point in time recovery') is not possible (eg, "When did you drop your table?" "Er, four weeks ago").

Normal incomplete recoveries, including 'until time', 'until cancel' and 'until SCN' are not affected.

Regards
HJR <bsidba_at_my-deja.com> wrote in message news:92dp75$ch$1_at_nnrp1.deja.com...
> We are currently running Oracle8i Enterprise
> Edition. I need to setup an additional server
> and I was thinking about going with Oracle8i
> Server because it is MUCH cheaper than the
> Enterprise Edition. However, I was a little
> spooked when I read that Oracle8i Server does not
> support point-in-time tablespace recovery. Does
> this mean that there is absolutely no way to do a
> point-in-time recovery on 8i Server? Doesn't 8i
> Server have redo log files and archive redo log
> files just like EE? I will be storing important
> data on this server and proper backup/recovery is
> very important. Any information you could
> provide on this matter or other pros/cons on EE
> vs Server would be greatly appreciated.
>
> Thank you
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Dec 28 2000 - 00:37:59 CST