Re: RMAN Skip Tablespaces
Date: Fri, 12 Dec 2008 09:44:29 +0000 (GMT)
We have done this a couple of times in 9i and 10g. In 9i we had problems with rman while restoring as we needed to do some steps manually (rman order of dropping tablespaces did not work) we had to drop the index tablespaces first or some such thing.
10g it worked version 10.2.0.3
- On Thu, 11/12/08, amonte <ax.mount_at_gmail.com> wrote:
> From: amonte <ax.mount_at_gmail.com>
> Subject: RMAN Skip Tablespaces
> To: "oracle-l" <oracle-l_at_freelists.org>
> Date: Thursday, 11 December, 2008, 9:05 PM
> I have a 2TB database running in 10.2.0.2 Linux x64 2 nodes
> I have to refresh test environment with production
> regularly. Since this
> database contains 1.5TB LOB data in their own tablespaces
> and they are not
> requiered in the test environment, I have thought of using
> RMAN duplicate
> and skip these lob data tablespaces so I only need to
> restore 500GB instead
> of 2TB.
> Do you know if there are any issues by doing so?