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

Hth,

-joe
   

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Josh Collier Sent: Tuesday, September 08, 2009 12:52 PM To: Martin Berger
Cc: oracle-l_at_freelists.org
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_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?  

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.  

--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 08 2009 - 14:04:28 CDT