Re: Oracle point-in-time recovery

Point-in-time tablespace recovery means that you can recovery a single TABLESPACE to a certain point in time. You can recover the whole DATABASE to a point in time in both versions.

For instance, you could recovery your dataload tablespace to ten minutes ago, just before you accidentally ran that giant truncate script. Since the rest of the database in still functional, you could take that tablespace offline and recover it while the rest of the database is online.

hth,

Jack
Senior dba
http://www.xol.com

<bsidba_at_my-deja.com> wrote in message news:92dti9$43i$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? Does 8i Server support the RECOVER DATABASE UNTIL
> TIME command to allow you to do a time-based incomplete recovery? 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 Jan 04 2001 - 21:44:51 CST