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

From: Josh Collier <Josh.Collier_at_banfield.net>
Date: Tue, 8 Sep 2009 11:52:25 -0700
Message-ID: <C5671700C5F4EA47B08AB9E6DAE9539B3776ED754A_at_M1EXCHANGE01.mmi.local>

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 - 13:52:25 CDT

This message: [ Message body ]
Next message: Martin Berger: "check for (empty?) blocks which leads to ORA-8103 in a datafile?"
Previous message: Rich Jesse: "Re: iPhone app for Oracle DBA?"
In reply to: Martin Berger: "Re: restore only one tablespace from a cold backup to another database?"
Next in thread: Sweetser, Joe: "RE: restore only one tablespace from a cold backup to another database?"
Reply: Sweetser, Joe: "RE: restore only one tablespace from a cold backup to another database?"
Reply: Martin Berger: "Re: restore only one tablespace from a cold backup to another database?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message