RE: restore only one tablespace from a cold backup to another database?
- From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
- To: <Josh.Collier@xxxxxxxxxxxx>, "Martin Berger" <martin.a.berger@xxxxxxxxx>
- Date: Tue, 8 Sep 2009 13:04:28 -0600
Metalink 102786.1 seems to fit the bill for what you are trying to do.
Hth,
-joe
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Josh Collier
Sent: Tuesday, September 08, 2009 12:52 PM
To: Martin Berger
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: restore only one tablespace from a cold backup to another
database?
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:
