Re: Partial Database Recovery

In article <342229de.11605833_at_news.centroin.com.br>,   lsantos_at_pobox.com,lsantos_at_bancointeratlantico.com.br wrote:
>
> Hello all!
>
> Is it possible to do a partial tablespace recovery? Let's
> suppose that one user accidently drop a table. The table are located
> in tablespace A. Then, I recover from last backup then datafile of
> tablespace A and recover it until one minute before the drop.
>
> I got the information that this is only possible with a FULL
> tablespace recovery, when I restore ALL datafiles... If I restore just
> one tablespace datafile I can just do FULL recovery.
>
> I think this is a bad implementation of recovery, and I really
> can't believe this limitation is true...
>
> Best Regards,
> --
> Luis Santos
> Banco InterAtlântico

With release 8.0.3 and up, you can perform point-in-time tablespace recovery from line-mode server manager NOT the Enterprise Manager. I have no details other that the technical PR I have seen. Ken Jacobs from Oracle Corp. said the facility is technically complicated for Oracle to have implemented, but it should be looked at if and when required.

Michael

+-------------------------------------------------------
+ Michael Abbey     Author of 5 works in the Oracle Press Series
+-------------------------------------------------------

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet