Re: restore only one tablespace from a cold backup to another database?
Date: Tue, 8 Sep 2009 21:11:45 +0200
totally untested and from a dark corner of my brain, but this would be my method (as a baseline):
ALTER DATABASE DATAFILE Ď<datafile name with complete path>í OFFLINE
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.
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_at_gmail.com]
> Sent: Tuesday, September 08, 2009 10:49 AM
> To: Josh Collier
> Cc: oracle-l_at_freelists.org
> Subject: Re: restore only one tablespace from a cold backup to
> another database?
> 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?
> 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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 08 2009 - 14:11:45 CDT
- application/pkcs7-signature attachment: smime.p7s