Re: restore only one tablespace from a cold backup to another database?
From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Tue, 8 Sep 2009 19:48:41 +0200
Message-Id: <423B007B-B003-4B6E-AF1F-73AAB7E57FFE_at_gmail.com>
Josh,
Date: Tue, 8 Sep 2009 19:48:41 +0200
Message-Id: <423B007B-B003-4B6E-AF1F-73AAB7E57FFE_at_gmail.com>
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-lReceived on Tue Sep 08 2009 - 12:48:41 CDT
- application/pkcs7-signature attachment: smime.p7s