Re: Complete recovery

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Thu, 2 Jul 2009 09:24:30 -0500
Message-ID: <e9569ef30907020724i76d743faseef7a03e6010022_at_mail.gmail.com>

I know you are asking about Recovery. But is the RECYCLE BIN in use on this database? If so, look into the FLASHBACK DROP feature. This is exactly why I like the recyclebin .

"FLASHBACK TABLE <table_name> TO BEFORE DROP;' -- simple version of it, depending on what is in the recyclebin.

Bradd Piontek
  "Next to doing a good job yourself,

        the greatest joy is in having someone
        else do a first-class job under your
        direction."

• William Feather

On Thu, Jul 2, 2009 at 4:47 AM, David Pintor <painterman_at_gmail.com> wrote:

> Hi guys,
>
> ** Oracle 10.2 on Solaris 10 box.
>
> Someone removed a user table this morning. I have a cold backup from last
> night. I want to restore just the USERS tablespace (where the table was) and
> perform a complete recovery. Is that possible? I've tried recovering the
> datafile by stopping the database, copying the datafile manually, and then
> doing a recover database. The recover is complete but my table is still
> missing... what am I doing wrong?
>
> Thanks for your help.
>
> David
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 02 2009 - 09:24:30 CDT