Gene I can't think of anything you're missing. I recall that read-only tablespaces if you have any must be offline, but maybe that is only for a database restore, not a tablespace restore. I assume you have a plan to move the tables back to your production system, maybe just export/import if they are small.
Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Wednesday, June 12, 2002 3:59 PM To: Multiple recipients of list ORACLE-L Hi all: I'm doing a partial restore of a database in order to recover two lost tables. I figured I would only need to restore the tablespaces where the tables are stored, SYSTEM and RBS tablespaces. I will also need to restore to a specific point in time (last Friday). I'm a little less clear on what I will have to do after the restore of the datafiles, archived logs and controlfile is done. I will need to recover the datafiles, drop all other datafiles that I don't need and open the database in resetlogs mode. Is that a good plan or am I missing something? thanks Gene __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).