Re: restore only one tablespace from a cold backup to another database?

  • From: Martin Berger <martin.a.berger@xxxxxxxxx>
  • To: Josh Collier <Josh.Collier@xxxxxxxxxxxx>
  • Date: Tue, 8 Sep 2009 21:11:45 +0200

Josh,
totally untested and from a dark corner of my brain, but this would be my method (as a baseline): 

STARTUP MOUNT;
ALTER DATABASE DATAFILE ‘<datafile name with complete path>’ OFFLINE DROP; for all datafiles which does not belong to system, undo, (sysaux?), (temp?), <yourTS> 

ALTER DATABASE OPEN;

DROP TABLESPACE <tablespace name> INCLUDING CONTENTS;
         for all the not-wanted TS.

this is just a graph of an idea, not a walkthrough.

Martin


Am 08.09.2009 um 20:52 schrieb Josh Collier:
Do you have a guide or a link to how to do this? I have only ever done this with RMAN. 

From: Martin Berger [mailto:martin.a.berger@xxxxxxxxx]
Sent: Tuesday, September 08, 2009 10:49 AM
To: Josh Collier
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: restore only one tablespace from a cold backup to another database? 

Josh,

not only one TS,
but SYSTEM, UNDO and the particular TS ( + redos) should be possible to bring your auxiliary DB up (setting all other datafiles offline). 
These should be small enough.

Am I missing anything?

Martin



All,
I am not convinced this is possible. I have a consistent cold backup, however it is very large and I don’t have the space to copy the entire thing to a dev box. Is it possible to restore only one tablespace from this cold backup to an auxiliary database? This is not RMAN. It’s a traditional cold backup. 

Thanks for your time,

Josh C.

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2009