Re: partial restore of a database

I've fallen way behind on email, so my apologies if someone else has already answered...

You probably want to drop the other datafiles first and then recover next, but otherwise you are very much right on track...

I have a korn-shell script on my website called "clonedb.sh" which is intended to automate this kind of operation (as much as it can be automated); it's at http://www.EvDBT.com/tools.htm, near the bottom of the page. Don't forget the "clonedb_arch.sql" script that goes along with it. Feel free to use them as documentation, if you like, but they worked for Oracle8i (i.e. uses "sqlplus -s internal" which would not work for Oracle9i)...

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, June 12, 2002 2:58 PM

> 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: gurelei_at_yahoo.com
>
> 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: ListGuru_at_fatcity.com (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: Tim Gorman
  INET: Tim_at_SageLogix.com

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: ListGuru_at_fatcity.com (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).