Re: RMAN Skip Tablespaces

Hi

I am not sure neither.

The LOB data is located in two tables so i think as long as these two tables are isolated in their own tablespace it should work?

The note says it muight fail when dropping LOBs, not really sure what it means!

thank you

alex

On Fri, Dec 12, 2008 at 10:57 AM, hrishy <hrishys_at_yahoo.co.uk> wrote:

> 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