Complete recovery
From: David Pintor <painterman_at_gmail.com>
Date: Thu, 2 Jul 2009 10:47:54 +0100
Message-ID: <f7321f200907020247o3671f528ib6596eb4853f2c95_at_mail.gmail.com>
Hi guys,
Date: Thu, 2 Jul 2009 10:47:54 +0100
Message-ID: <f7321f200907020247o3671f528ib6596eb4853f2c95_at_mail.gmail.com>
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-lReceived on Thu Jul 02 2009 - 04:47:54 CDT