Re: Complete recovery

From: <TESTAJ3_at_nationwide.com>
Date: Thu, 2 Jul 2009 06:29:50 -0400
Message-ID: <OFA02DE299.A6684DD3-ON852575E7.0039A9FC_at_lnotes-gw.ent.nwie.net>

David what you want is incomplete recovery, if u do complete, as u have seen it will not be recovered, assuming u know when it was dropped, u will need to recover to just before then and do open resetlogs, if this is not feasible since you will lose all txs since the drop, then restore the to some other server, do incomplete recovery over there, open resetlogs and export the table from there, then import that to the original db.

Hth, joe
Sent from the crackberry, so please excuse the typos and terseness.

• Original Message ----- From: David Pintor [painterman_at_gmail.com] Sent: 07/02/2009 10:47 AM CET To: oracle-l_at_freelists.org Subject: Complete recovery

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jul 02 2009 - 05:29:50 CDT