Re: RMAN Skip Tablespaces

Hi

You will also encounter some errors as RMAN drops the tablespaces in a reverse sorted list of tablespace names.

You’ll get errors if you try to exclude tablespaces that contain indexes used for enforcing unique or primary keys.

I also notice that you are planning to exclude LOB tablespaces i am not 100% sure but i think you are not going to suceed trying to duplicate the database by excluding the LOB tablespace

regards
Hrishy

• On Fri, 12/12/08, hrishy <hrishys_at_yahoo.co.uk> wrote:

> From: hrishy <hrishys_at_yahoo.co.uk>
> Subject: Re: RMAN Skip Tablespaces
> To: "oracle-l" <oracle-l_at_freelists.org>, ax.mount_at_gmail.com
> Date: Friday, 12 December, 2008, 9:44 AM
> Hi
>
> 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
>
> regards
> Hrishy
>
>
> --- 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
> > Hi
> >
> > I have a 2TB database running in 10.2.0.2 Linux x64 2
> nodes
> > RAC.
> >
> > 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?
> >
> >
> > TIA
> >
> > Alex
      

--
http://www.freelists.org/webpage/oracle-l